Issues in file upload to salesforce - File is getting created but in salesforce it is showing 'No preview available'

(1) Share

Report

Posted on by SagarKusekar96

I am trying to upload a SharePoint pdf file in salesforce via Power Automate desktop flow.

Steps I followed-

1. I used Get file content SharePoint action to read a file.

2. Compose action- In the "Inputs" field of the Compose action, I entered base64(body('Get_file_content'))

3. Create record salesforce action- used the base64 content in the "Create a file" action in Salesforce.

File is getting created in Salesforce but it's not readable. Showing 'No preview available'

Need your valuable inputs.

Categories:

Building flows

File_Upload_SFDC_...

I have the same question (0)

All responses (10)

Answers (0)

jmin 9 on at

Like (0)

Report

I'm having the same issue. The file content that gets uploaded to Salesforce is the base64 string. It seems like Salesforce fails to convert the base64 string back to binary upon insert of the record. When using the REST API's, I dont face this issue, but I seem to be facing this issue with the "Create Record" action in Power Automate.

Also separate unrelated note. I'm seeing you're inserting a ContentVersion record, then a ContentDocumentLink. You can simplify that into one step by using the First Publish Location ID field when inserting the ContentVersion record.

Was this reply helpful? Yes No
DanHardy on at

Like (0)

Report

I'm having the same issue to. @jmin did you use a http post in Power Automate to create a ContentVersion instead of the Create Record action? If so, would you mind sharing how you did that.

Was this reply helpful? Yes No
jmin 9 on at

Like (0)

Report

@DanHardy @SagarKusekar96

I forgot to follow up on this, but I was able to resolve this.

First, use "Get file content using path" instead of "Get file content". For some reason, "Get file content" always results in a corrupt file being generated. I think it's an issue that Microsoft needs to resolve.

Second, when inserting ContentVersion, you can just put the "File content" variable from "Get file content using path" in the Version Data field. No need to do any data manipulations like converting to base64.

Let me know if this helps or if you have questions.

Was this reply helpful? Yes No
DanHardy on at

Like (0)

Report

@jmin Thanks for your help! Using your instructions, I was able to upload the file ok to Salesforce, but it's not being recognized as a pdf file either in preview mode, or if I download it. Any ideas? Here are my settings:

Not being recognized as a pdf

Was this reply helpful? Yes No
jmin 9 on at

Like (0)

Report

@DanHardy

Salesforce has some quirks in how it determines content type.

Within the Path on Client field, you'll need to make sure it ends with the appropriate file extension (i.e. .pdf). Can you try adding .pdf to the end of that variable?

Was this reply helpful? Yes No
DanHardy on at

Like (0)

Report

do you mean the title variable?

Was this reply helpful? Yes No
jmin 9 on at

Like (0)

Report

This one should end in .pdf

Was this reply helpful? Yes No
DanHardy on at

Like (0)

Report

This is what I got when I did that.

Was this reply helpful? Yes No
SagarKusekar96 8 on at

Like (1)

Report

Hey all,
I found a way to fix this issue. It's a bug in new designer. You can try by using legacy designer, disable new designer and try to test. I will work in your case.

Thank you.

Was this reply helpful? Yes No
DanHardy on at

Like (0)

Report

Sagar- You are amazing! That worked!! Thank you.

Was this reply helpful? Yes No