cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vstar19
Helper V
Helper V

updating dynamic excel files

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

Vstar19_0-1622639234586.png

Whereas if I manually select the file using icon next to file, i get the below options to update Primary Key, Status and Name

Vstar19_1-1622639512941.png

 

 

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. 

1 REPLY 1
Rahber
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,074)