Unanswered

Attachments are not converting to base64

(0) Share

Report

Posted on by vaishali_37

Hi,

I have created the flow which retrives the attachments from Dynamics CRM email and then create folder and add attachments in SharePoint.

I am converting the attachment to base64 as in below screenshort.

sharepoint 1.png

base64ToBinary(items('Apply_to_each_2')?['body'])

when i run flow attachments get created and it works properly.

but I noticed that the value of File Content is changing automatically as per below.

due to which I am gettig error when I open document in sharepoint.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @vaishalivyas1,

Could you share the full screenshots of your Flow configuration?

I have tested it on my side. If the content of the file is not in the standard pdf format, then the same error will occur.

I noticed that you filled in the content of the Body, is this the content of the email body, or the Body when you get the Attachment?

This Body seems to contain the attachment File content, but not the File content.

I am wondering if you are not using the contents of the correct attachment file to fill the File Content. The screenshot shows that the file is a pdf file. If the file content does not match, it cannot be opened normally.

Please provide more details and we may provide a proper workaround for you.

Best Regards,

Barry

Was this reply helpful? Yes No
Tom_Slosse 1,430 on at

Like (0)

Report
Copy link

Link copied!

Hey @vaishalivyas1

Just like @v-bacao-msft said you need to put the File Content of the attachment in the File Content property of the Create File action otherwise your file that will be created has no content.

Kind regards

Tom

Was this reply helpful? Yes No
vaishali_37 84 on at

Like (0)

Report
Copy link

Link copied!

Hey @v-bacao-msft

Body when I get the Attachment.
Steps I perform:
1. I retrieve all the attachment related to that Mail.
2. We check Document Location in MS CRM if present we create attachment file in sharepoint else we create document location in MS CRM and then attachment file in Sharepoint.

Was this reply helpful? Yes No
Tom_Slosse 1,430 on at

Like (0)

Report
Copy link

Link copied!

Hey @vaishalivyas1

If I see this correct those actions you defined of Dynamics are just renamed actions but arent actually actions to get the attachment out of Dynamics right.

Maybe you should look for actions that are specially made to get attachments.

Kind regards

Tom

Was this reply helpful? Yes No