Hello There.
I have a two excel files stored in sharepoint, for e.g April.xlslx and May. xlsx - both files contain the same structure.
Each Excel file is formatted as a table and has a Primary Key, e.g below
Primary Key | Name | Status
1 | John |
2 | James | Complete
I have written a flow which extracts data from both the file where the Status is Empty. This part works fine.
I need to update both files with a value i have. I have the value stored in Flow; however, i am unable to update both the excel file. I am using the Update a row, but within the Update a row - it appears i have to hardcode a single excel file and cant select a dynamic file. The flow is throwing back an error saying it cant find the file.
I have the update a row inside of an apply to each, and the File i have specified as a variable - but no luck. see below
Whereas if I manually select the file using icon next to file, i get the below options to update Primary Key, Status and Name
Is this a flow limitation whereby you cannot update dynamic Excel Files?. Or is there an alternative way and i am doing this wrong?
Hope that make sense.
You need to have a workaround to select the file dynamically because when you select a file manually its schema and format is picked up by Power Automate.
A workaround is mentioned here: http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow
and here: https://manueltgomes.com/microsoft/powerautomate/how-to-access-dynamic-path-excel/
Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.
Thanks,
Rahber
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
15 | |
13 | |
13 | |
10 | |
10 |
User | Count |
---|---|
32 | |
26 | |
18 | |
12 | |
12 |