Others

Append SharePoint Fields to a Power Automate Concatenation

Maira Mehtab Sep 27, 2026 869 views

Question details

The user wants to combine a generated identifier with specific SharePoint fields using a Power Automate concat expression.

Product: Power Automate and SharePoint
Device & OS: not provided
Scenario: Creating a custom identifier in a workflow by combining generated text with dynamic SharePoint list items.
Observed behavior: To successfully generate the correct string, the exact internal column names of the SharePoint fields must be referenced within the expression.

Before you start

Ensure your Power Automate flow is properly connected to your target SharePoint list, and have a recent test run's output ready so you can verify the exact internal field names.

Solution 1Recommended

Use Internal Column Names in the Concat Expression

Extend your concat expression by referencing the exact internal column names returned by the SharePoint action to avoid null values.

SharePoint often uses internal names that differ slightly from the display names you see in the list (for example, containing '_x0020_' for spaces). Power Automate requires these precise internal names to successfully retrieve and concatenate the data.

Run a test flow to find internal names

Execute a manual test of your flow. Once it finishes, review the raw output of the SharePoint 'Get item' or 'Get items' action to identify the exact internal names for your target columns (e.g., DecisionId_x002_ and Title).

Update the concat expression

Open the dynamic content expression builder in your flow. Write or modify your concat function to include those exact internal names. For example: concat(variables('Identifier'), body('Get_item')?['DecisionId_x002_'], body('Get_item')?['Title']).

Save and test the workflow

Save your flow and run another test. Check the final output of the step where the concat function is used to confirm that the identifier is formatted correctly.

Solution 2

Consult the Power Automate Community

If you are working with a highly complex custom flow and face expression syntax errors, reach out to community experts.

Free Microsoft Office alternative

Need a Reliable and Free Office Suite? Try WPS Office

While automated workflows and SharePoint integrations are handled by Microsoft Power Automate, your daily document creation, spreadsheet data analysis, and presentations can be efficiently managed with WPS Office. It is a highly compatible, free alternative that is lightweight and easy to use.

1. Download the Installer: Visit the official WPS Office website and click the free download button.
2. Install WPS Office: Run the downloaded installer file and follow the on-screen instructions to complete the setup.
3. Open and Edit Files: Launch WPS Office to seamlessly open, edit, and save your existing Microsoft Office documents.

Fully compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight software that loads quickly for everyday office tasks.Familiar user interface that requires no steep learning curve.Built-in PDF editing tools alongside core office applications.

Frequently Asked Questions

Why is my Power Automate concat expression returning empty values for SharePoint fields?

This usually occurs if you are using the column's display name instead of its internal name. You must check the raw JSON output of your SharePoint action to find the exact internal name (which may contain characters like _x0020_) and use that in your expression.

How do I find the internal name of a SharePoint column?

You can find it by navigating to your SharePoint List Settings, clicking on the specific column, and looking at the URL in your browser's address bar. The internal name is located at the very end of the URL, right after 'Field='.

Can I add spaces or characters between fields in a concat expression?

Yes, you can format the identifier by inserting text strings enclosed in single quotes directly within the concat function. For example: concat(item1, ' - ', item2, ' ', item3).

Office Quick Solutions