Forum Discussion
Dataflow Refresh Failing
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.
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
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.