cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Advocate II
Advocate II

@maruthi216 

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

 

Hope it helps!

Responsive Resident
Responsive Resident

@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

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

 

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

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

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 🙂 

Community Support
Community Support

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (8,267)