Submit Form with data from gallery

(0) Share

Report

Posted on by VO-16022037-0

Hi! I need some help with a Power Apps form, maybe someone here knows how to fix this.

I have a form in Power Apps where the user needs to upload an attachment.

The form contains several fields, like request number, status and the attachment, however these fields are saved into a SharePoint list. The problem is with the request number and status since they are values created earlier in the process in a different screen and are stored in a different SharePoint list.

What I tried to do is:

Add a Gallery that pulls items from the other SharePoint list
Display the Request Number and status in that gallery
When the user submits the form, I want the form to read the selected record from the gallery and patch those same values into the new SharePoint list, along with the attachment

The issue:
The manual fields Attachment save correctly, but the values coming from the gallery always save as blank.

It seems like the form isn’t actually reading the gallery’s selected values when patching.

Has anyone dealt with this before? What’s the correct way to make a form capture values from a gallery and save them into a SharePoint list?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @VO-16022037-0,

A bit of reversing things here. The issue is that you need a Form with the second list as the DataSource and the use the Default of the new field controls from the fields selected in the Gallery for the values there. You cannot save attachments without having an attachment control on a Form based on the target list.

So (assuming this is a new record), you could set a Variable when you select from the gallery
Set( gblRecord, ThisItem ); NewForm(YourFormName)

Then using a Text value as an example, the Default (Value on a Modern control) of the value you want to bring over in the Text Input
gblRecord.YourFieldName

You would then complete the Form, add the attachment and submit it. If you also wanted to send a value back to the first List, use Patch
Patch( List1, { ID: gblRecord.ID, Field1: YourControlOutput . . . . . } )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @VO-16022037-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No