Answered

Power Automate failed to read Excel table.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I created an power automate to read an excel table on sharepoint. The flow is schedule to run at 6PM, read the excel table, assign read access to folder and send email to users on read access. The flow runs successfully for a week.

I am having problems this week. Even I refreshed the excel table, the flow still use previous table data to process. I have to open the flow, delete the excel file, add it back to the flow, rerun the flow manually.

Does anyone knows to solve this? It seems that flow is reading previous version of excel files.

Categories:

Using flows

All responses (3)

Answers (1)

Sort by

Verified answer

v-duann-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Anonymous

Thank you for posting.

According to your description, your flow failed to get latest data from excel this week and it works fine last week. If I misunderstood, please kindly let me know.

If that’s the case, please try to reestablish the excel connection. Since there is no error message appearing. I believe it’s not caused by server incident. Actually, there are some known issues for excel connector that may cause data delay to update. Since you didn’t mention your flow details, please feel free to check by yourself.

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/
https://docs.microsoft.com/en-us/power-automate/fix-flow-failures

Hope the content above may help you.

Thanks
Anna
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks
v-duann-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Thank you for your reply.

Please click Accept as Solution if my post is helpful to you. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Best regards,
Anna