I have a manual trigger flow that takes an excel file that is stored on SPO each week and merges (updates or creates a new record) in an existing SPO list. Currently, I use the 'List rows present in a table' step to pull the file + table using the dropdown navigation for the file and table section. In this example, let's call it 'project.xlsx' with the table name 'report'.
The next step, I start my apply to each loop and the rest of the flow works great. The SPO list gets updated properly and the flow works. Afterwards, I manually update the file name by adding a timestamp at the end and move it into an Archive subfolder in that location. The next week, we get a new file with the same original name, project.xlsx, in that original folder location with the same table name. However, when I run the flow it seems to still reference the old file even though I changed the file name and moved it to a subfolder. This leads me to believe the List rows present in table step is instead using the file id instead of the actual name I specified in the step. If I remove that step and recreate it, the flow works correctly and uses the new weekly file.
How can I fix this flow so that it will always use the new file that comes in each week instead of seemingly referencing the same old file?
2
Share
Report
All responses (
Answers (
