Unanswered

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)

Verified answer

royg on at

Like (0)

Report

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 (0)

Report

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 (0)

Report
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