Others

Fix Microsoft Lists ID Not Populated by Power Automate

Muhammad Talha Sep 27, 2026 869 views

Question details

The user is attempting to map or retrieve the built-in ID column when creating a Microsoft Lists item via Power Automate, but the field is unavailable or empty.

Product: Microsoft Lists, Power Automate
Device & OS: not provided
Scenario: Creating a new list item in Microsoft Lists or SharePoint using a Power Automate workflow.
Observed behavior: The built-in ID column is not available as an input field during item creation and appears empty until the process completes.

Before you start

Ensure your Power Automate connection is active and that your account has the necessary edit permissions for the target Microsoft List or SharePoint site.

Solution 1Recommended

Retrieve the ID from the Create Item Output

Since Microsoft Lists generates the ID automatically after an item is created, you must fetch the ID from the output of the creation action instead of trying to populate it manually.

The built-in ID field in SharePoint and Microsoft Lists is a system-generated, read-only column. Power Automate cannot populate this field during the 'Create item' step because the ID does not exist until the item is successfully saved to the list.

Add the Create item action

In your Power Automate flow, add the 'Create item' action and fill in the required fields for your Microsoft List. Do not attempt to map an ID field here.

Use Dynamic Content for subsequent actions

Add your next action (such as 'Update item' or 'Send an email'). Click on the input field where you need the ID, and the Dynamic Content pane will appear.

Select the generated ID

In the Dynamic Content pane, look under the 'Create item' category and select 'ID'. This maps the newly generated ID to your current action.

Retrieve the ID from the Create Item Output

System Generated Field: If you require a custom ID format, consider creating a separate custom text column in your list and populating it using a Power Automate expression or variable.

Free Microsoft Office alternative

Boost Your Productivity with WPS Office

If you are looking for a highly compatible, cost-effective solution for your daily document workflows, WPS Office serves as an excellent free alternative to Microsoft Office. It seamlessly handles your spreadsheets, presentations, and documents in a single lightweight application.

1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the application: Run the installer and follow the on-screen instructions to complete the setup in just a few minutes.
3. Open your files: Launch WPS Office and directly open your existing Microsoft Office documents without any format conversion.

Fully compatible with Microsoft Excel, Word, and PowerPoint formats (.xlsx, .docx, .pptx).Lightweight application that uses minimal system resources and runs smoothly.Familiar, tabbed user interface ensures a zero-learning-curve seamless migration.Powerful built-in PDF toolkit to edit, convert, and manage PDF documents easily.

microsoft office alternative - wps office

Frequently Asked Questions

Can I manually set the ID for a new item in Microsoft Lists?

No, the built-in ID field is a read-only system column. It is automatically assigned sequentially by SharePoint or Microsoft Lists only after a new item is successfully saved.

Why does my Power Automate flow fail when I try to update the ID?

Because the ID is a system-managed column in Microsoft Lists and SharePoint, modifying it is strictly prohibited. Attempting to write data to this field will result in a flow execution error.

How do I use the new item's ID in an email notification?

Add a 'Send an email' action immediately after your 'Create item' action. Click inside the email body field, open the Dynamic Content menu, and select 'ID' from the 'Create item' outputs.

Office Quick Solutions