Dataflow Refresh Failing

[bhenry]

I have a dataflow built to combine the files from a sharepoint folder.  This folder holds a number of xlsx docs that are daily reports of our phone system usage by our employees.

Each morning at 1 AM, the previous day's data is received from the phone service provider as an attachment in an email.  I have a Power Automate flow that gets the contents of the attachment and saves it into the deignated sharepoint folder.

The datafow runs about an hour later, but it fails.

I need to go to the sharepoint folder and Open and then Close the newly added attachment.  Once I have done that, I manually refresh the dataflow and it executes successfully in seconds.

Any trouble shooting ideas to solve this problem and allow this to be a fully automated process? 

Thanks

[bhenry]

It has not worked.  I built the flow and the flow worked but the query is not refreshing until I open it one time.  It is coming in as an .xlsx attachment in the email.  I was thinking it may be something related to our email security measures for attachments, but wasn't sure if anyone else has seen this

[hackcrr · Accepted solution]

Hi, @bhenry 

After saving the attachment in SharePoint, add a step in the Power Automate flow to validate the file. You can check the file properties or even use a script to programmatically "open" the file.

Adjust the timing of the data flow to ensure it runs after the email processing is fully completed. You can add a delay to the flow to give it extra time. Implement logging in the Power Automate flow to capture any errors when saving or processing the file.

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Did this work before?  Sounds like the Excel file they sent is not a true .xlsx and only becomes one when you touch it.