web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Excel file corruption

(0) ShareShare
ReportReport
Posted on by 183

Working with an outside vendor that sends a daily status report email to an Admin email account. I have set up a very simple flow that will take the attachment they send (.xlsx) and place a copy of it in a SharePoint document library. The original idea was that they file they send would overwrite the previous day's submission.

 

I've tested this myself by just sending an image to see if the flow would pull out the attachment and had no issue. The flow would even overwrite the previous file if they were named the same thing. 

 

The original file is a 35KB Excel document, but in the SP library it is a 1KB file. I checked the email account, and the file opens fine there. But when opening the file in the library this is what I get:

NathanFra_1-1611879684924.png

 

Here is the flow I used originally with .JPEG that worked when I tested sending the email from my account to the Admin account.

NathanFra_2-1611879798480.png

NathanFra_3-1611879867865.png

 

Would it matter if the user is not in our tenant as a guest account?

Categories:
I have the same question (0)
  • Verified answer
    Gopala_Krishna Profile Picture
    1,495 on at

    @NathanFra 

     

    That doesn't matter if the user is not in your tenant as your are trying to extract email attachment and flow is running in context of your user account. The issue here is only with file content how that is being created

     

    Can you please try changing the include attachments option on the trigger to YES and on the create file action in the file content instead of directly passing the attachment content pass it in a binary format. For that you can use the expression base64tobinary("AttachmentContent"). 

     

    Make the above mentioned changes and check if that helps with overcoming the issue

     

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.

Under review

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard