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 / Power Automate Keeps D...
Power Automate
Unanswered

Power Automate Keeps Disconnecting From Linked Excel File

(1) ShareShare
ReportReport
Posted on by 2
I created an automation to pull a list of emails from an excel file create an email to each and then attach a file from a folder that matches the file name in the excel file. The automation works perfectly, however, it always disconnects from the excel file. I run this once a quarter so 4 times per year. I have to manually go and reselect the file path, file and table every time. The file name and folders never change, sometimes just updates to the table such as adding or removing rows. What could be causing this disconnection as it's more of an annoyance to re link it every time I want to run it. It is supposed to look like this but a lot of times the document library, file and table will have a bunch of characters instead with a loading circle next to it
Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,960 Moderator on at
    The file is changing over time, and its manual so its annoyingly going to do that.
     
    To save your headache, I would make it either an Environment variable, or store the name etc etc in a list in SharePoint or DV or a file in onedrive, and pull it in real-time it will stop doing it then
     
  • ME-20011934-0 Profile Picture
    2 on at
    @FLMike So it disconnects just because the excel file has data that changes based on my input?
     
    How would I do that? I don't know much about Power Automate as I built this from googling a bit and used the "new designer" format since having it off was even harder to make this flow work

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

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard