Answered

File content conversion creates unreadable word file: uploading file with CDS connector and attaching as a Note in Dynamics 365 CRM

(0) Share

Report

Posted on by sarahmcd9000

Hello,

I was trying to see if I could use the CDS trigger "When a record is selected" to have the user upload a file as a word document, do some things with the file, and then attach the file as a note on a Dyanmics 365 entity. I have created a siple flow to see if this is possible as below:

base64(triggerBody()['file']['contentBytes'])

I used the base64 conversion. This flow will attach the file as a note, but the word document is unreadable and will not open:

Here is what it looks like after I test the flow:

Does anyone know why this is not working? Is there a special conversion needed for contentBytes?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sarahmcd9000 ,

You could try to change base64() function to base64ToBinary() function.

Best Regards,

Was this reply helpful? Yes No
sarahmcd9000 32 on at

Like (0)

Report
Copy link

Link copied!
Thanks, I tried that already. Both of the expressions below give the error:

"The field 'documentbody' contains one or more invalid characters."

base64ToBinary(triggerBody()['file']['contentBytes'])

base64ToString(triggerBody()['file']['contentBytes'])

Was this reply helpful? Yes No
Verified answer

sarahmcd9000 32 on at

Like (2)

Report
Copy link

Link copied!
I just tried this and it works:

string(triggerBody()['file']['contentBytes'])

Was this reply helpful? Yes No