Iterate through dynamic Excel file

[Awinad]

We have Excel files that are produced on a daily basis. The number of rows is always different.

There is a Key Column called ID and multiple columns with values, that I then need to use to populate some word file.

How do I iterate through the columns? I created a foreach, but when I then try to get a row, it asks for a specific Key ID.

Is there some value that iterates with the foreach, that I could use, so that ID will be 1, 2, 3 etc.?

Or do I need to create some array etc. - if yes how would that be done specifically?

[JamesYumnam · Accepted solution]

Hi @Awinad  please check the following flow for reference;

As you can see in the flow, I got the list of rows from the excel table, then i am reading each rows using Apply to each.

While iterating through each row, you can see that the columns for each are already available and you can perform your required actions to populate your word file (in my case: appending to the string variable)

This way you can directly used the columns for each row and not depend on some column iteration  variable.

[Awinad]

Thanks a lot for the quick reply, James.

So this means I won't need "Get a row"? 

Anyway, in my case it's a bit more complex: There are multiple dynamic files processed, so Power Automate doesn't give me any Columns to use, since it's not a static file, but a dynamic file/file name.

How could I access the columns in such a case?
Use something like this, in your example:

body('List_rows_present_in_a_table')?['Region'] ?

[JamesYumnam]

What i understood from your original problem statement is that you were able to read those excel files but not able to iterate through the rows/columns.

Once you are able to read any excel file, the rest of the steps will be same to read the rows and iterate through them. 

few questions for clarification:

1. Are you able to read those excel files dynamically? Where are these excel files stored?
2. Could you show me how you are reading your dynamic excel files or your flow?

[Awinad]

Actually I got it sorted. I could access the column by using the according code, e.g. body('List_rows_present_in_a_table')?['Columnname'] instead of being able to select it from the list of values in case of a static file.