cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KRDE
Level: Powered On

1 form, on submit save data to multiple lists

Hello,

 

I have a scenario where I want 1 form with multiple fields (say 3 fields for this example). On submitting the form I want to save the data of each field to a different SharePoint list. So in this example I have 3 SharePoint lists. Then on submitting the form:

- the data in field 1 should be saved to SharePoint list a

- the data in field 2 should be saved to SharePoint list b

- the data in field 3 should be saved to SharePoint list c

 

It is important that as user I only see 1 form, on 1 page.

 

Is this possible? And if yes, how?

 

Thanks in advance!

 

 

2 REPLIES 2
Super User
Super User

Re: 1 form, on submit save data to multiple lists

Hi @KRDE

 

Yes, it's possible to do this. The first step is to add a screen and to insert text input or data entry controls for your 3 fields

 

Next, you can add a button or icon, and attach formula to the OnSelect property that calls the Patch function. You can find details on how to do this through the following link and if you search for the word 'patch' on this forum, you'll find plenty of code samples.

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

 

 

SanchezCSG
Level 8

Re: 1 form, on submit save data to multiple lists

Ok lets try this.

 

Fields:

Field1

Field2

Field3

Field4

Field5

Field6

 

Sharepoints:

Share1 - Column1 - Column2

Share2 - Column1 - Column2

Share3 - Column1 - Column2

 

Button1 - On Select

Path(Share1;Defaults(Share1);{Column1: Field1.Text; Column2: Field2.Text});;

Path(Share2;Defaults(Share2);{Column1: Field3.Text; Column2: Field3.Text});;

Path(Share3;Defaults(Share3);{Column1: Field5.Text; Column2: Field5.Text})

 

This insert Field1 and Field2 in Sharepoint1; Field3 and Field4 in Sharepoint2 and Field5 and Field6 in Sharepoint3

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Users online (5,206)