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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow is Grabbing Old E...
Power Automate
Answered

Flow is Grabbing Old Excel Documents in OneDrive Instead of Documents Currently in Folder

(0) ShareShare
ReportReport
Posted on by 43

Hello!

 

I'm having an issue with a flow that is designed to grab a couple of Excels stored in OneDrive/Teams, do a comparison, send out some emails and move the Excel documents out into an archival folder.

 

This is a weekly process, and needs to be run on Excel documents with new data weekly and those documents are manually placed in the same OneDrive/Teams folder a few hours before the process runs. The documents are named the same and are in the same format as the previous ones.

 

Here's the issue. It still picks up and runs the flow on the old documents even though they're in a completely different archival folder. How is this even possible? The only fix I've found so far is to go through the flow and reselect the exact same file pathway options that are already there. Obviously, having to do that defeats the purpose of automation.

 

I've tried dropping the files directly into OneDrive vs. in the Teams folder and syncing them there and that doesn't seem to make a difference. 

 

Please help!

Categories:
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @sjd889  what action are you using to grab the file from onedrive, could you please share the screenshot of the flow?

  • sjd889 Profile Picture
    43 on at

    @annajhaveri  I'm using List rows present in a table.

     

    sjd889_1-1657804189328.png

     

     

  • Verified answer
    annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @sjd889  try using dynamic values for file name and table name, so that flow doesnt cache the table values, see below on  how to do it. This will ensure that flow always gets the latest data from the file.

     

    1. Add compose action and store your file name

    annajhaveri_0-1657878849388.png

    2. Add Get Tables action, in file parameter, use the output of compose action

    annajhaveri_1-1657878867088.png

    3. Add List rows present in table action, for file parameter select output of compose action, for table parameter use below expression, if your excel has just one table, if it has more than one table let me know then i can provide the logic accordingly.

    first(outputs('Get_tables')?['body/value'])['id']

    annajhaveri_2-1657878900218.png

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 315 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 267

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard