Submitting a Powerapp to Multiple SHARE POINT LISTS BASED ON SELECTION FROM DROPDOWN

[maruthi216]

Hello,

I was wondering if there is a Way i can submit "Same Form" that built on 1 SP List to Multiple Other SP lists based on a selection from a dropdown in the Powerapp.

Thanks.

[Surya_PH]

@maruthi216 

OnSelect function of a button, Use either Patch or UpdateIf to save/update same data to multiple SP lists.

Hope it helps!

[PavanKumar]

H @maruthi216 ,

On select property of the button you can write Patch to Create/Update in any number of lists.

example.

Patch(yourListname,uniquerecordid,{columname:value,columnname2:value2});

if this answers your question mark it as verified and give thumbs up

Regards,

Pavan Kumar Garlapati

[maruthi216]

Currently : submitform(sharepointform1)  This auto submits to Master List.

so how to do the same onto Other List's...?

[PavanKumar]

Hi,

As mentioned below instead of submitform please try to use Patch and let me know if that works.

if this answers your question mark it as verified and give a thumbs up

Regards,

Pavan Kumar Garlapati

[Surya_PH]

So in addition to your submit form, your function should look like,

SubmitForm(MasterList);
Patch(List1, {column1: TextInput1.Text, column2: TextInput2.Text});

Patch(List2, {column1: TextInput1.Text, column2: TextInput2.Text});

Patch(List3, {column1: TextInput1.Text, column2: TextInput2.Text});

.....

And you can even replace your SubmitForm with Patch function as well.

Hope it helps 🙂 

[v-yutliu-msft · Accepted solution]

Hi @maruthi216 ,

Please note that the value in the form will be invalid after you submit the form.

So if you want to use this value , you need to use it before you submit the form.

Remember this order:

Patch(list1,Defaults(list1),{field1:drop down.selected.value);
Patch(list2,Defaults(list2),{field2:drop down.selected.value);
Patch(list3,Defaults(list3),{field3:drop down.selected.value);
....;
SubmitForm(Form1)   //it shoule be the last 

Best regards,