Answered

Need help with Power Apps form to pre-populate based on selection and then add new record to sharepoint list

(0) Share

Report

Posted on by lterrazas

Hello

I am very new to PowerApps and im stuck and need some guidance. I have a gallery that based upon the gallery selection (machine type) the form pre-populates information for that record. Several fields are populated as info only for the user. I then want the user to fill in several drop-down fields and some text fields and then i want to be able to add a new record to my SharePoint

list. So for example, there may be 5 users that click the same machine type on the gallery but I need to show those get submitted a 5 new separate records.

Please help cant figure it out

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

royg on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lterrazas,
Basically all you need is a Form that's default mode is set to New.
your pre-populated data cards "Default" property need to be manipulate:
Machine Type: galMachines.Selected.MachineType
Operation#: galMachines.Selected.Operation
etc...
For your gallery "OnSelect" add ResetForm(Form1), so your defaults get re-calculated.
Your submit button will submit the form and upon success reset the form.
Hope this makes sense.

Was this reply helpful? Yes No
Verified answer

lterrazas 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Omg you are a genius and helped me out so much. When I select the machine type from the gallery to display on the form with some field populated it adds it to a new record in my sharepoint list.

Question now is i noticed it added that same machine again to my gallery which i dont want. Basically gallery should only show one type of machine. How can i get it from doing that?

Was this reply helpful? Yes No
royg on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lterrazas,
I'm glad you got further.
For your new question, I think I need more info. The list on the left is a cross join (Cartesian join) of the MachineType and the OpertaionNumber? if that is the case, change the Items property of that gallery to:
With({Table1: RenameColumns(Choices(YOUR_LIST[@MachineType]), "Value", "Title"), Table2: RenameColumns(Choices(YOUR_LIST[@OperationNumber]), "Value", "Subtitle")}, Ungroup(AddColumns(Table1, "Subtitle", Table2), "Subtitle"))
Replace the list name and field names with yours.

Hope this helps

Was this reply helpful? Yes No