I'm creating a Power Automate cloud workflow that, for each email received from a specific recipient with an attachment:
1/ Retrieve the attachment
2/ Save the attachment to a SharePoint folder
This works perfectly. Once this file is saved to SharePoint, I query it using a Power Query for an Excel file.
However, if I update the query for the file saved by Power Automate, I get an error message when updating the query in Excel: "The key did not match any row in the table." I think the saving isn't working correctly in Power Automate.
I tested it, and if I save it manually to SharePoint without Power Automate, the update works fine. of the query.
Furthermore, when the query is updated, cache files are created in the background (which correspond to the query file).
I am requesting your help with these two problems. Thank you very much
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.