Not able to uplaoad files to sharepoint using power automate and powerApps

(0) Share

Report

Posted on by KrishnaV

5,023

Hi Team,

I have been breaking my head from the last 3 hours as I am not able to upload files/images to the SharePoint library using PowerApps through power automate. I have followed the below article step by step advised in article http://johnliu.net/blog/2019/4/flowninja-hack-87-lock-microsoft-flow-powerapps-trigger-to-upload-images-to-sharepoint-with-ease but the flow was getting failed with the error as: "Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '2279': 'The template language function 'base64ToBinary' was invoked with a parameter that is not valid. The value cannot be decoded from base64 representation.'"
I have also tried the video blog https://www.youtube.com/watch?v=ZXWyDgDEHPo by @RezaDorrani but no luck.

flow error.png

This is my flow simple straight as advised in the blog.

flow error2.png

I really appreciate your help.

Regards,

Krishna

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Not sure if the advice given in the following link can fit your needs

https://social.msdn.microsoft.com/Forums/azure/en-US/0f8eefe4-e5b9-4d87-8b90-bdb85ec63ebf/incoming-base64-string-to-a-sharepoint-list-issue?forum=azurelogicapps

Hope this helps

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @KrishnaV,

Could you share the code of the "Upload" button in PowerApps?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @KrishnaV

What I have done in the past, was upload a attachment from Power Apps to SharePoint as a list item, using a Edit form in Power Apps.

Than on Success of the form property, I would trigger a flow to grab that attachment from the list and create a file in a Document Library.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!

I am calling the flow with the input values as follows:
'UploadfilestoSharepoint-2'.Run(UploadFile.Media,UploadFile.FileName)

Regards,
Krishna

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!

unfortunately no 😞, I need this as a separate app not with the form in the list or a library.

regards,
Krishna

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@KrishnaV

Right, my proposed suggestion is just an example.

You can use the Form in Power Apps to upload the Attachment into SharePoint. The flow can be kicked off using the onSuccess property of the form.

The flow does not have to add the document to a library. You can use my suggestion to get the File Content of the file.

After the last step, you will be able to call the dynamic content for File Content

The SharePoint list just acts as an intermediary to easily get the attachment out from Power Apps.

After you get the Attachment content, you can put anywhere.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!

Jcook,

Would you be able to share the flow with me? I am a little confused about your proposal.

Regards,
Krishna

Was this reply helpful? Yes No