cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ruddi84
New Member

Flow: attachment to sharepoint, csv always corrupt

Hi all,

 

I've made a flow to download attachments from certain mails to a sharepoint location.

The flow in itself is simple and works fine (see image below). 

The only problem is the contnt of the file is not what it's supposed to be, it's just a long string in cell A1 like: "/9j/4RwaRXhpZgAATU0AKgAAAAgADAEAAAMAAAABAJYAAAEBAAMAAAABAEQAAAECAAMAAAAEAAAAngEGAAMAAAABAAUAAAESAAMAAAABAAEAAAEVAAMAAAABAAQAAAEa (and so on)"

 

The attachments are perfectly fine csv-files and opening them directly from the mail is no problem at all. So issues with the source file don't seem to be a possible cause.

 

flow.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
sudharsan1985
Super User
Super User

Hi @Ruddi84 

Try to use the Get Attachments action inside the Apply to each and then use the Name & Content Bytes to create the file. It should work

sudharsan1985_0-1614072180010.png

 

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

View solution in original post

2 REPLIES 2
sudharsan1985
Super User
Super User

Hi @Ruddi84 

Try to use the Get Attachments action inside the Apply to each and then use the Name & Content Bytes to create the file. It should work

sudharsan1985_0-1614072180010.png

 

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

View solution in original post

Ruddi84
New Member

Hi Sudharsan, 

 

This worked. Just added a condition to rule out images from sigantures an used the create file from sharepoint but i think the 'get attachment' and content bytes combo did the trick to make the file non-corrupt. Thank you very much!

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (67,942)