Others

How to Append a SharePoint Item ID Using Power Automate Formulas

Elise Williams Sep 30, 2026 869 views

Question details

The user needs to create a Power Automate expression that merges a SharePoint column's text with its generated list item ID upon creation.

How to Append a SharePoint Item ID Using Power Automate Formulas

Product: Microsoft Power Automate & SharePoint
Device & OS: not provided
Scenario: Creating an automated flow when a new SharePoint item is generated to concatenate specific column data with the newly generated item ID.
Observed behavior: A new text string combining the original column text and the list item ID is dynamically generated and saved into a destination column.

Before you start

Ensure you have the necessary permissions to create flows in Power Automate and edit lists in your target SharePoint site.

Solution 1Recommended

Use the Concat and String Expressions to Append the ID

Utilize the built-in 'concat' and 'string' functions in a Power Automate flow to combine SharePoint column values dynamically upon item creation.

Because SharePoint Item IDs are generated as integers and your column data is typically text, you must convert the ID to a string before appending it. The standard concat function handles this operation perfectly.

Create an automated flow

Log into Power Automate, click on 'Create', and select 'Automated cloud flow'. Choose the 'When an item is created' SharePoint trigger.

Configure the trigger

Select your SharePoint Site Address and List Name from the dropdown menus in the trigger settings.

Add an action

Click 'New step' and add an 'Update item' action to target the same SharePoint list, or add a 'Compose' action if you just need to generate the string.

Insert the expression

In the destination field, click the 'Expression' tab and input: concat(triggerOutputs()?['body/Column1'], string(triggerOutputs()?['body/ID'])). Replace 'Column1' with your actual SharePoint column internal name.

Save and test

Save your flow and test it by creating a new item in your SharePoint list to verify that the text and ID append correctly.

Use the Concat and String Expressions to Append the ID

Format with Leading Zeros: If you require formatted IDs (e.g., 001 instead of 1), use the formatNumber expression in place of the string function: formatNumber(triggerOutputs()?['body/ID'], '000').

Solution 2

Consult the Power Automate Community for Complex Flows

If your expression requires complex conditions, nested logic, or custom formatting not covered by standard functions, the official community is the best place to ask.

Free Microsoft Office alternative

Boost Your Daily Productivity with WPS Office

While Power Automate handles complex SharePoint workflows, you still need a reliable office suite for everyday documents, spreadsheets, and presentations. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office that meets all your productivity needs.

1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to set up the suite.
3. Start creating: Open WPS Office and immediately start viewing, editing, or creating your documents with full Microsoft format compatibility.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Advanced spreadsheet features for data processing without complex coding or formulas.Lightweight software that installs quickly and runs smoothly on both new and older devices.Familiar user interface that requires zero learning curve when migrating from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my flow fail when trying to append the SharePoint ID?

This usually happens because the SharePoint Item ID is formatted as an integer, while the column you are appending it to is text. You must wrap the ID output in the string() function before concatenating it to prevent a type-mismatch error.

How can I format the SharePoint ID to always display three digits (e.g., 005)?

You can use the formatNumber expression instead of the string expression. For example, writing formatNumber(triggerOutputs()?['body/ID'], '000') will ensure your appended ID always displays with leading zeros up to three digits.

Can I use WPS Office to automate SharePoint tasks?

WPS Office focuses on powerful desktop and mobile document productivity (Writer, Spreadsheets, Presentation, and PDF). While WPS Spreadsheets supports advanced macros and VBA for local automation, cloud-based triggers like updating SharePoint lists are best handled by Microsoft Power Automate.

Office Quick Solutions