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?