Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Using Power Automate t...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Using Power Automate to save email csv attachment to Onedrive, but the output file is unreadable

(1) ShareShare
ReportReport
Posted on by CU16040255-0 2
Using Power Automate to save email csv attachment into Onedrive, however it change the original csv file format/contents. 
How to overcome this? 
Categories:
Dynamics 365 general
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 5,917 on at
    Using Power Automate to save email csv attachment to Onedrive, but the output file is unreadable
    Good morning, afternoon, or evening depending on your location!
     
    This issue often occurs due to how Power Automate processes file content when saving attachments. Here are some steps to resolve it:
    Possible Causes & Solutions
    1. Ensure Proper File Content Handling:
      • When using the "Get Attachment" action, ensure that the File Content is correctly passed to the "Create File" action in OneDrive.
      • Avoid using expressions that modify the content unintentionally.
    2. Check File Encoding:
      • Power Automate may alter the encoding of the CSV file. Try explicitly setting the encoding to UTF-8 when saving the file.
      • If the file appears unreadable, open it in Notepad and check if there are unexpected characters.
    3. Verify File Extension:
      • Ensure that the file is saved with the correct .csv extension.
      • If Power Automate is saving it without an extension, manually append .csv in the "Create File" action.
    4. Use "Convert File" Action:
      • If the format is being altered, try using the "Convert File" action before saving it to OneDrive.
    5. Test with Different Storage Locations:
      • Try saving the file to SharePoint or another cloud storage to see if the issue persists.
     
    Hope this is helpful :)

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans