Answered

Uploading files to document library from Power Apps via Power Automate not working

(0) Share

Report

Posted on by marumaru

Hi,

I created a canvas power apps that lets the user upload documents to their folders in a SharePoint Document Library. These folders were created via Power Automate. I followed Matthew Devaney's approach to get the file from Power Apps then Power Automate creates/uploads the file to their assigned folders.

All was working well a few weeks ago but yesterday, we have been getting errors. Upon my investigation, the file object/data is not being carried over to Power Automate.

This is my Upload button formula:

Uploadattachment.Run(
 3, //MasterFileID
 "Employee Photo", //DocType
 "MyFolderName", //FolderName
 {
 contentBytes: First(attFile.Attachments).Value,
 name: First(attFile.Attachments).Name
 }
)

File Name:

ContentBytes Value:

Then this is my Power Automate Trigger:

Then this is the error I get:

Things I've tried:

Uploading file directly in the document library folder
Checked my permission and the service account's permission
Checked the file data from Power Apps and it is not empty, I can see the name and contentBytes value

Has anybody else encountered this error? I tried redoing the same approach on a new app and flow but it is still the same.

I'm not sure if this is the right place to ask or in the Power Automate community, please let me know if I need to move the question.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

The content bytes cannot be a blob link, so in order to get the content bytes of the file you can create a image control and set the image as:

First(attFile.Attachments).Value

and then set the content bytes as the image from the image control like this:

Uploadattachment.Run( 3, //MasterFileID "Employee Photo", //DocType "MyFolderName", //FolderName { contentBytes: ImageControl.Image, name: First(attFile.Attachments).Name } )

Here is a demo:

I set the image background to yellow to make it easier to see, but you can set the visible to false to hide it.

I hope it helps 🙂

Was this reply helpful? Yes No
marumaru 16 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I tried your approach but it is still giving me the same error in power automate. The file content in Power Automate is still empty.

Was this reply helpful? Yes No
Verified answer

victorcp 2,350 Moderator on at

Like (2)

Report
Copy link

Link copied!

There is another thing that you should do, you have to make it required (I don't know why it is needed but it only works this way)

Let me know if it works

Was this reply helpful? Yes No
marumaru 16 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This worked! It's kind of funny that everything broke just because I did not make this required 😅.
Thank you very much 😊

Was this reply helpful? Yes No
hemalathamodini 4 on at

Like (0)

Report
Copy link

Link copied!

For me this option not showing....what should i do?....actually i have another field also i.e, Person
how can write the powerapps code for that? i have five fields 1.File content,2.File name,3.MainlistID,4.Person,5.DocTypName......tell me the PowerApp formula for this

Was this reply helpful? Yes No