Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
2 like 0 dislike
in Power Automate by 23 25 33
recategorized by

 In Power Automate, I need to use the SharePoint column value in the Expression formula so I tried to use the below formula to use the SharePoint list field in Expression but it's not working.

concat(items('Apply_to_each')?['Field Name'],items('Apply_to_each')?['Field Name'])

I also tried to use Compse to get column value from the SharePoint list in the compose expression below with no vail.

concat(item()?['Field Name'],item()?['Field Name'])

Get Column Value in Expression in Power Automate

How can I add a field name in an expression in Power Automate?

1 Answer

2 like 0 dislike
by 154 174 350
selected by
Best answer

How to Get Column Value in Compose Expression in Power Automate?

The solution for using the SharePoint List Column Value in an Expression in Power Automate as the following:

  1. Click on the "Expression" tab, type first your function concat,
  2. then Switch back to "Dynamic Content" to select your fields name as below:
    add a field name in an expression in Power Automate

The final syntax to get column value in Power Automate Expression should look like

concat(triggerBody()?['Field Internal Name'],' ',triggerBody()?['Field Internal Name'])

Note that in the above formula, you have to use the Internal Field Name, not the Field Display Name.
Read more at How to combine strings in Power Automate

by 23 25 33
0 0
Got it thank you
If you don’t ask, the answer is always NO!