
Announcements
Hello,
I'm having what appears to be a common problem with a flow I inherited without a common solution that I can see. Using a "When a new email arrives (V3)" trigger, getting the attachment from the email, creating an item in a SP list and then trying to add the email attachment to both SP and OneDrive. I am using the content bytes value for filling in the file content.
Typically what happens when running is it takes forever and either errors out with a Bad Gateway or it says it works but gives me files with this error: "This workbook couldn't be opened because the file format may not be matching with the file extension.".
It's a really simple Excel file, just a few rows and columns of content. What is going wrong here? TY in advance!
I fixed my own problem - it was the two Apply to Eaches in my case, for some reason.
Each reference to file content was just the same thing - items('Apply_to_each')?['contentBytes'] - made sure to reference the trigger, not a later action. Ran in seconds and the file opens as expected now.