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