Cloud Flow issue with Excel file, when file gets replaced weekly in SharePoint library

Hi there,

I have a worrying situation whereby I am trying my best to find the best solution around it.

Background info.

I have a SharePoint List table that contains all New Hires information.

I am currently have a scheduled Power Automate desktop flow, whereby from a PowerBI Dashboard i am downloading weekly new hire data into an excel file called NewHire.

My Desktop flow, will automatically replace this New Hire file stored inside my SharePoint library.

I have an issue now with the Scheduled Cloud Flow Importing of Data from the NewHire excel file inside Sharepoint library into my SharePoint table.

I am using the usual List Rows present in Table and then run a Create Item(sharepoint) using the values in my Excel file.

This automation works fine. However the issue starts when the next week i replace the new hire file.

The automation to import seems to be taking the old new hire file.

I checked in my flow and see that the File id has not changed. If i update my automation to repoint the file back to the same NewHire excel file, i see the file ID changes.

I would like to know what is the workaround that can be done here in my situation. How can i ensure when my List Rows Present in Table uses the latest Excel file found inside my SharePoint library and pointing to Table1

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate