Skip to main content

Notifications

Power Automate - Building Flows
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
  • ME-20011934-0 Profile Picture
    ME-20011934-0 2 on at
    Power Automate Keeps Disconnecting From Linked Excel File
    @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
  • FLMike Profile Picture
    FLMike 31,580 on at
    Power Automate Keeps Disconnecting From Linked Excel File
    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
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard