Answered

Error missing column. your formula is missing a column 'contentBytes' with a type of Blob when uploading a file

(0) Share

Report

Posted on by mm31

Hi everybody,

i have a power app with a power automate flow triggered by powerapps V2. Such flow takes a text and a file as input and i run it with this expression (as i've always done):

sign.Run(Signed; {file:{name: First(attach3.Attachments).Name; contentBytes: First(attach3.Attachments).Value}})

where signed is a text variable and the rest takes the content and the name from an attachment control.

My problem is that, even if I use the same expression i've always used for other apps, this time there's an error:

"missing column. your formula is missing a column 'contentBytes' with a type of Blob"

What can i do?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!
hi @mm31 ,
you can use this:
FolwName.Run( { contentBytes: Att.Value, name: Att.Name } );
Note how I left out the 'file:' part and one pair of curly brackets. For some reason this worked, but putting back in '{file: }' broke it again. Maybe it's some weird syntax behavior behind the scenes.

Was this reply helpful? Yes No
mm31 16 on at

Like (0)

Report
Copy link

Link copied!
hi @anandm08
i tried the solution you said (as follows) but it doesn't work
sign.Run(Signed; { contentBytes: attach3.Value; name: attach3.Name } )

Was this reply helpful? Yes No
Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!
try this:
sign.Run(Signed; { contentBytes: First(attach3.Attachments).Value; name: First(attach3.Attachments).Name } )

Was this reply helpful? Yes No
DS1060 86 on at

Like (0)

Report
Copy link

Link copied!

Put File parameter optional in the flow.

Credit: Solved: Problems with file upload using V2 powerapps triger in Power Automate

Was this reply helpful? Yes No