Others

Fix Blank SharePoint List ID for New Microsoft Forms Items

Maira Mehtab Sep 22, 2026 868 views

Question details

Users are experiencing an issue where new items added to a SharePoint list from Microsoft Forms responses have an empty ID, and the ID column is missing from the associated Power Automate flow.

Product: Microsoft SharePoint, Power Automate, Microsoft Forms
Device & OS: not provided
Scenario: Creating automated SharePoint list items from Microsoft Forms submissions using a workflow.
Observed behavior: The SharePoint List ID is completely blank for newly created items, and the ID column cannot be accessed as dynamic content in the Power Automate flow.

Before you start

Ensure you have full edit permissions for the target SharePoint list and access to the associated Power Automate flow to run manual tests.

Solution 1Recommended

Isolate the Issue by Creating a Manual Item

Determine if the missing ID issue is rooted in the SharePoint list itself or the Power Automate workflow.

By manually creating an item directly in SharePoint, you can verify if the system's auto-incrementing ID function is working. If the manual item receives an ID properly, the issue is isolated to your Power Automate flow.

Navigate to SharePoint

Open your SharePoint site and go to the specific list where the Microsoft Forms responses are supposed to be recorded.

Create a new item manually

Click the 'New' button at the top of the list menu to manually add a test entry without using Microsoft Forms or Power Automate.

Verify the ID column

Save the item and check if the 'ID' column populates automatically. If the ID is successfully generated, the core issue lies within your Power Automate flow configuration.

Next Steps: If the manually created item lacks an ID, there may be a deeper issue with the SharePoint list settings or site collection database.

Solution 2

Troubleshoot Power Automate Flow Configuration

If manual items receive IDs, the automation workflow needs to be investigated or reconstructed.

Free Microsoft Office alternative

Looking for a simpler way to manage data and forms?

While complex SharePoint and Power Automate workflows can sometimes encounter synchronization issues, WPS Office offers a streamlined, lightweight alternative for your daily document and spreadsheet needs. Enjoy high compatibility with Microsoft Office formats without the steep learning curve.

1. Download the installer: Visit the official WPS website and click the download button for your operating system.
2. Install WPS Office: Run the downloaded installation file and follow the on-screen instructions to set up the software.
3. Open existing files: Launch WPS Office to seamlessly view, edit, and manage all your existing Microsoft Office documents and spreadsheets.

Fully compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight architecture that runs smoothly on Windows, Mac, and Linux.Built-in spreadsheet features for straightforward data management and tracking.Free to download with an intuitive, tabbed user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the SharePoint List ID column missing in my Power Automate dynamic content?

This can happen if the SharePoint list connection needs to be refreshed or if the 'Create item' action hasn't fully executed to return the ID property. Try removing and re-adding the SharePoint action in your flow to refresh the available dynamic content.

Are SharePoint List IDs generated before or after an item is saved?

SharePoint List IDs are only generated and assigned after the item has been successfully committed and saved to the list database. They are not available during the initial draft or creation phase.

How do I show the ID column in my SharePoint list view?

Click on 'Add column' or the current view name at the top right of your list, select 'Show or hide columns', check the box next to 'ID', and click 'Apply' to display it in your current view.

Can I manually set or change a SharePoint List ID?

No, the ID column in a SharePoint list is a read-only, auto-incrementing system column managed entirely by SharePoint. Users cannot manually edit, assign, or reuse these values.

Office Quick Solutions