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 / Opening Excel document...
Power Automate
Answered

Opening Excel document located on SharePoint using PAD

(0) ShareShare
ReportReport
Posted on by 86

Hello everyone,

I hope your day is going well. I need to open and work with an Excel file that is located on Sharepoint. To achieve this I synced the Sharepoint folder to my local device and I'm using the local path. However, the issue I experience is that if I make changes on Sharepoint and run my flow right after it the file doesn't reflect the most recent change. When I run it again the changes are reflected. Is it a normal behavior to have sync delay? Is there a better way to work with an Excel document located on Sharepoint using PAD?

Thank you,

  • Verified answer
    CU16071609-1 Profile Picture
    6,255 Moderator on at

    @pae1 

    I'm not sure about your use case, but have you attempted to utilize the Excel Online (Business) package? This package allows you to open your Excel files directly from sharepoint rather than from a synced folder.

     

    To access these actions or packages, first, establish your Excel connection reference within your solution. Then, create a desktop flow from your solution and utilize the necessary actions from this package.

     

    Deenuji_0-1710261374845.png


    Thanks,
    Deenuji Loganathan
    🤖 Automation Evangelist
    Deenuji - Follow me on LinkedIn

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

  • Verified answer
    Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    What you're experiencing is likely related to auto-sync by the OneDrive desktop app.

     

    If you have a Premium account, it makes a lot of sense to use the SharePoint actions in Power Automate Desktop to get the file, make changes to it locally, and then push the file back to SharePoint again. This is a significantly more reliable way of doing it than using the OneDrive desktop app to sync the directory.

     

    If you do not have a Premium license, and have to use the OneDrive app for syncing, I recommend copying the file locally before making the changes, and then moving it back to the synced directory. This is because the auto-sync by OneDrive can also cause issues when saving your changes or writing to Excel in general. I have experienced these issues numerous times. So, use Copy file(s) to copy it locally, then do what you want to do with it, and then use Move file(s) to move it back.

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 229 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 223 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 136 Super User 2026 Season 2

Last 30 days Overall leaderboard