Power Automate Get Column Value in Expression

Question

 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'])

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

Answer 1

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:
   

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

Comments

Got it thank you