SharePoint Document Issues

Fix SharePoint ID Column Empty for Items Created by Power Automate

Nimra Malik Sep 28, 2026 869 views

Question details

The user needs to resolve an issue where the SharePoint ID column remains empty for list items automatically generated through Power Automate and Microsoft Forms.

How to Fix Empty SharePoint ID Column for Items Created by Power Automate

Product: SharePoint, Power Automate, Microsoft Forms
Device & OS: not provided
Scenario: Automating list item creation in SharePoint using Microsoft Forms and Power Automate workflows.
Observed behavior: Newly submitted items have an empty ID field, and the ID column is missing from the Power Automate flow.

Before you start

Ensure you have list management permissions in the affected SharePoint list and access to edit the associated Power Automate workflow.

Solution 1Recommended

Verify SharePoint Automatic ID Generation Manually

Determine if the issue is native to SharePoint or caused by the Power Automate workflow by creating an item manually.

SharePoint is designed to assign a unique ID automatically to every new list item. By manually testing list item creation, you can isolate whether the SharePoint list itself is functioning correctly or if the issue is exclusively linked to the Power Automate data submission process.

Open the SharePoint List

Navigate to the specific SharePoint list where the Microsoft Forms responses are being recorded.

Create a Manual Item

Click the 'New' button located at the top left of the list view to open the item creation panel.

Save the Item

Fill in the required fields with test data and click 'Save' at the bottom of the panel.

Verify the ID Column

Refresh the list page. Check if the 'ID' column populated automatically for your manually created item. If it did, the SharePoint list is working properly, indicating the issue lies within the Power Automate flow.

Verify SharePoint Automatic ID Generation Manually

Next Steps: If the manual item receives an ID, proceed to inspect your Power Automate flow.

Solution 2

Inspect Power Automate Flow and Seek Specialized Help

Check the workflow for configuration errors and consult the Microsoft Power Platform Community if the issue persists.

Free Microsoft Office alternative

Try WPS Office for Your Document and Data Needs

While troubleshooting complex Microsoft automation workflows, consider WPS Office as a free, lightweight, and easy-to-use alternative for your everyday document, spreadsheet, and presentation tasks. It offers seamless migration and high compatibility with Microsoft formats.

Highly compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation and fast performance on Windows, Mac, Linux, iOS, and Android.Free to use with an intuitive, familiar tabbed user interface.Built-in cloud sync for easy document collaboration and sharing.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the ID column not visible in my Power Automate flow?

The ID column is a system-generated, read-only field in SharePoint. Power Automate typically does not display it in the 'Create item' action because it is automatically assigned by SharePoint only after the item is successfully created, not before or during the creation process.

Can I manually edit the SharePoint ID column?

No, the SharePoint ID column is automatically managed by the system. It is uniquely generated in a sequential order for each new item and cannot be manually edited, overridden, or reset by users, even if previous items are deleted.

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

To display the ID column, click on 'Add column' at the far right of your column headers, select 'Show/hide columns', check the box next to 'ID' in the right-hand pane, and click 'Apply'.

Document & File Issues