cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jedikevin
Regular Visitor

EXCEL - Get a row extracting old legacy data

I use a flow which extracts data from an Excel Spreadsheet held on SharePoint using the 'Get a row' function.  The Spreadsheet is updated regularly with new information.  This is done by deleting and replacing the old spreadsheet,  the new one being saved with the same name and in the same location.

 

My flow continues to work after each change, but sometimes the data it extracts appears to be old information from a previous spreadsheet instead of new data from the latest version.

 

Is this a bug?

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @Jedikevin,

 

You could create a delay action after the trigger to let the SharePoint service get the last version of Excel file, then use the List rows present in a table action to get the newly Excel content:

Screenshot 2021-05-20 104948.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jedikevin
Regular Visitor

Hi Lin Tu,

 

Thanks for getting back to me so quickly.  So how does this solution work? 

 

I'm assume that the flow stores a copy of the spreadsheet data that 'Get a row' extracts from in the background. So if it can't find the data via SharePoint due to connection problems, it refers to the old store?

 

If that's the case how does the delaying the action affect that? If there was a problem when the flow first initiated couldn't there also be an issue after 10 mins? 

 

Sorry I'm not familiar with the Delay and List rows function.

 

Many thanks,

 

JediKevin

 

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,673)