Problem with excel columns from file created inside flow

[Turborabbit2000]

Hi everyone!
I'm creating a flow that is:

1. Downloading an excel file from local server which contains two columns: Location and Name (done)
2. Creating 1:1 copy of this file inside my Sharepoint(done)

Inside this Excel I have only 1 table with two columns:
File Location(LOC) and name

Now I have to work with this data file but Key column and key value are not available as dynamic content to choose:

Sorry for non-english version of GUI. This is a "Get excel row" step.

Can I somehow work on columns from excel which is created in the same flow?

I have created flow when excel is already inside sharepoint, pointed it directly and these two values were available to choose.

Thank you!

[Turborabbit2000]

I have resolved this issue by:
Creating two variables
Parsing JSON from step "Get a row form Excel"
Setting variables with values from JSON parsing

[rzaneti · Accepted solution]

Hi @Turborabbit2000 ,

This is expected: Power Automate won't provide you with the dynamic content of the columns, your table is technically a variable, and the program will get the details about your file/table only in the flow run moment. But don't worry, we have some alternatives here 🙂

I was running some tests here and I could not directly access a row by key value through 'Get row' action. However, we have a workaround here: you can use the 'List rows in a table' action and filter the column with 'Filter Query'. 

In the example below, I'm getting all tables from a file and passing the table as expressions to a 'List rows present in a table' action (highlighted in blue). The expression that I'm using is: outputs('Get_tables')?['body/value'][0]['id']. In the 'List rows present in a table', I'm also filtering it by country column, to return only the records matching to 'UK' (highlighted in yellow). For your use case, you can follow the same process, but filtering it by your key column and value.

Output:

I don't know if you are facing some trouble to get the table details from your file. If yes, you can use the 'Get tables' action as I did above. You can find a little more details about this action and the integration between Power Automate and Excel in this article: http://digitalmill.net/2023/07/17/integrating-power-automate-and-excel-tables/ 

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/ 

[Turborabbit2000]

Thanks for your solution! 
For now I'm using JSON parsing and variables as I wrote in previous post - seems to work fine.
I will try to use your way in future - looks less complicated than using additional variables.

Regards