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
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,492)