Unanswered

Dynamic content from excel

(0) Share

Report

Posted on by RachelUC

Sorry if this has been talked about before, I can't find anything.

I'm setting up a flow using data from an excel spreadsheet which has separate tables named for each month of the year (i.e. September). I was my flow to use data from the table named after the current month so I have used a compose function to find the month. I then use this dynamic content to tell the flow which table to look at as so -

This stage definitely works as when I run it and check the outputs the correct data is there. But I can't use any of that data in future steps as the column names aren't listed as they usually are -

Whereas if I manually put the month in, it works as usual -

I'm assuming it's something to do with power automate not being able to access the excel table because I'm trying to use dynamic content rather than just giving it the name as normal - is there a way around this? I don't want to have to go in and manually change the month.

Thanks for any help

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Unknown geen idee 1,757 on at

Like (1)

Report

Dear RachelUC,
The compose action does not show you any column names because PowerAutomate cannot look into your defined excel table (you use dynamic content).
If you are sure that you table structure is the always the same, you can refer to the current items in that row by using the expression 'items('Apply_to_each')?['ColumnName']. Give it a try.

If this helps, please state so in the thread.
Happy flowing,
Koen

Was this reply helpful? Yes No
RachelUC 5 on at

Like (0)

Report

That works thanks!

Was this reply helpful? Yes No
PranayMokida 2 on at

Like (0)

Report

It shouldnt be just plain data in rows and columns, you also need to create a table in the excel. Then you will be able to select the table name.

Was this reply helpful? Yes No