cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
s44
Post Patron
Post Patron

Send data from a Power Apps form to a different SharePoint list

Hello,
I created a form with Power Apps based on the fields of 2 Sharepoint lists. The "Categorie et Filiere" list and the "Filiere et Sous-Filiere" list.

I would like that when the user fills in the form, the data entered by the user is saved in another list called "Donnees Formulaire". But I don't know how to do this. 😞 

Could you help me please? Thanks in advance !

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @s44 ,

 

Do you want to save data from a form to another SharePoint list?

You could try to use Patch() function to achieve this.

 

I have made a test for your reference.

 

1. Here are my lists.

vyujincuimsft_0-1652427403781.png

vyujincuimsft_1-1652427421370.png

2. Select the Icon and apply the following formula on its OnSelect property as:

Patch(datasource,Defaults(datasource),{ColumnName1:DataCardValue3.Text,ColumnName2:{Value:DataCardValue4.Selected.Value},ColumnName3:DataCardValue7.Text});SubmitForm(Form3);ResetForm(Form3)

vyujincuimsft_8-1652428330577.png

Result Screenshots:

vyujincuimsft_3-1652427952866.pngvyujincuimsft_4-1652427973848.png

vyujincuimsft_6-1652428095771.png

 

 

Best Regards,

Charlie Choi

 

 

 

 

View solution in original post

1 REPLY 1
v-yujincui-msft
Community Support
Community Support

Hi @s44 ,

 

Do you want to save data from a form to another SharePoint list?

You could try to use Patch() function to achieve this.

 

I have made a test for your reference.

 

1. Here are my lists.

vyujincuimsft_0-1652427403781.png

vyujincuimsft_1-1652427421370.png

2. Select the Icon and apply the following formula on its OnSelect property as:

Patch(datasource,Defaults(datasource),{ColumnName1:DataCardValue3.Text,ColumnName2:{Value:DataCardValue4.Selected.Value},ColumnName3:DataCardValue7.Text});SubmitForm(Form3);ResetForm(Form3)

vyujincuimsft_8-1652428330577.png

Result Screenshots:

vyujincuimsft_3-1652427952866.pngvyujincuimsft_4-1652427973848.png

vyujincuimsft_6-1652428095771.png

 

 

Best Regards,

Charlie Choi

 

 

 

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,828)