Answered

Problems with file upload using V2 powerapps triger in Power Automate

(1) Share

Report

Posted on by OH-07080958-0

Hi there,

I'm trying to upload a file to SharePoint from a PowerApp using the V2 trigger in Power Automate but I'm having problems with the formula used to run the flow. I've been following Shane Young's video (Power Apps Upload File v2 to SharePoint Document Library (youtube.com)) walkthrough for this but I'm always having the a warning come up saying "Missing Column. Your formula is missing a column 'name' with a type of 'Blob'. In Shane's video, he says that this can happen if you miss the capital B in contentBytes, but I've definitely go that bit correct.

This is the code I'm using in the OnAddFile property of an Attachment Control:

This is the warning that keeps coming up as well:

This is the Flow that I'm using as well. This was made the same way as in the video using the new designer:

Any help on this would be really appreciated.

Categories:

Building Power Apps

I have the same question (2)

All responses (5)

Answers (1)

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report

Hi @Evil_Zoidberg ,

I run exactly the same Flow (except I include an ID to attach the file to) and it works fine. Can you please post your code in Text and a screenshot of the Flow in the Classic designer (not sure what I am looking for as what you have looks OK)

Was this reply helpful? Yes No
OH-07080958-0 47 on at

Like (1)

Report

Thanks for the response

Flow in old designer:

This is the code I've got in the OnAddFile property of the attachment control:
V2Upload.Run({file:{contentBytes:Last(Self.Attachments).Value, name:Last(Self.Attachments).Name}})

I've tried putting the code in a separate button (referencing the last file stored in the attachment control) but the same issue happens there as well.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (4)

Report

@Evil_Zoidberg ,

Try making it not optional (although this does not explain the issue). I assume you are using a standard attachment control.

2 people found this reply helpful.

Was this reply helpful? Yes No
OH-07080958-0 47 on at

Like (1)

Report

@WarrenBelz

I clicked on 'make the field optional' so it now reads 'make the field required'. I was assuming that this would mean it was originally required and is now optional, but it does seem to have fixed the issue. Thank you for the help.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (1)

Report

Thanks @Evil_Zoidberg for asking this question even I was facing the same issue and @WarrenBelz for the answer.

Regards,
Sidhant.

Was this reply helpful? Yes No