Forum Discussion
Solved
Concatenate Fieldname into Expression
I have an Excel table with fields for Year1, Year2, Year3, Year4, Year5 I want to create a Sharepoint item in Power Automate for each. I have created an array ( [1,2,3,4,5]) I have an apply ...
- Hi All
For anyone who cares, the correct syntax is -
outputs('Get_a_row')?[concat('body/Year', Items('Apply_to_each_financial_year'))]
So the concat is only applied to the "Body/year" part of the statement. Encompassing the entire output statement results only in a string that isn't evaluated.
Hi All
For anyone who cares, the correct syntax is -
outputs('Get_a_row')?[concat('body/Year', Items('Apply_to_each_financial_year'))]
So the concat is only applied to the "Body/year" part of the statement. Encompassing the entire output statement results only in a string that isn't evaluated.
For anyone who cares, the correct syntax is -
outputs('Get_a_row')?[concat('body/Year', Items('Apply_to_each_financial_year'))]
So the concat is only applied to the "Body/year" part of the statement. Encompassing the entire output statement results only in a string that isn't evaluated.
Geoffers Great, glad you found the correct solution. Happy that you were able to figure out the correct expression based on my hint about using concat function.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.