web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / EXCEL - Get a row extr...
Power Automate
Unanswered

EXCEL - Get a row extracting old legacy data

(0) ShareShare
ReportReport
Posted on by Jedikevin 15

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?

Categories:
Using flows
I have the same question (0)
  • v-litu-msft Profile Picture
    v-litu-msft Microsoft Employee on at

    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 Profile Picture
    Jedikevin 15 on at

    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

     

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans