Power Platform Community Forum Thread Details

I have an Excel table which contains a column named:

"Date

(dd/mm/yyyy)"

*** I cannot change the column name ***

The first step I have done is "list rows in a table", then I loop over every row to try to retrieve its values with compose action. However, it fails using the system generated dynamic expression (btw, the expression is "item()?['Date (dd~1mm~1yyyy)']". The result keeps showing blank value.

After numerous of testings. I tested a created column named"Date (dd/mm/yyyy)", with expression "item()?['Date (dd/mm/yyyy)']", and this works. So, I am sure that the problem is on "\n" and I hope to know what the expression should be to represent column name:

"Date

(dd/mm/yyyy)"

Thank you!

Categories:

Building flows

Hi @SDX1

This seems to be strange, i am wondering why the system generated dynamic content for that column is not working .

Well i have a solution for this 🙂

Actually you have to specify the new lines in the column name when using item()?[column name]

see below, in a compose action, i have placed the column name:

expression used in compose action under apply to each loop

items('Apply_to_each')?[outputs('Compose_2')]

as you see in expression, it will take the column name from compose 2 action.

Well another way without specifying column name in compose action !

If you see there are two new lines in column

Date

(dd/mm/yyyy)

So while retriving the column value from that row, use below expression:

Expression:

items('Apply_to_each')?[concat('Date',decodeUriComponent('%0A'),decodeUriComponent('%0A'),'(dd/mm/yyyy)')]

Here i won't be using column named specified in a compose action, instead i use concat function to concat the file name with new line represent by code decodeUriComponent('%0A')

Hope this info helps !

Seems system generated dynamic content from power automate to be a bug

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌