Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

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

Like (0) ShareShare
ReportReport
Posted on 22 Dec 2024 15:11:32 by 19
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
  • Suggested answer
    Pstork1 Profile Picture
    Pstork1 64,396 on 22 Dec 2024 at 17:25:25
    Cloud Flow issue with Excel file, when file gets replaced weekly in SharePoint library
    The only real fix for this is to use MS Graph to lookup the ID for the changed file and use that instead of the filename.  Here's an article that explains how to do that. Workarounds needed to use the Excel Connector in Microsoft Flow — John Liu .NET

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,563

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,396

Leaderboard
Loading started