Hi All,
Based from Microsoft Docs ,
Merge records
Patch( Record1, Record2 [, …] )
=============
If my:
1.) Record1 = is the customized canvass that I created on Screen1
2.) Record2 = is the edit form on Screen2 (came from SharepointList1)
Question: How can I use the Patch function back to SharepointList1 and merge the data from both Record(s) ?
Merge function is to merge two records outside of a data source, which means to merge the different columns into a record and return a record, If two records contain the same column but different value, it will take the value of the record at the back.
The example:
Formula: Patch( { Name: "James", Score: 90 }, { Name: "Jim", Passed: true } )
Result: { Name: "Jim", Score: 90, Passed: true }
To your question, you have the ensure all columns of two records are from the sharepoint list, then try the following codes.
Patch('SP list', First('SP list'),Patch(Record1,Record2))
Sik
User | Count |
---|---|
252 | |
104 | |
94 | |
50 | |
39 |