@Canadiansal
Rather than to worry about all those intermediary Collections, instead just
1) add the SharePoint List as a data source directly in your Canvas App, then
2) add a single Button Control to the app and finally
3) simply add this formula below in your OnSelect property of that Button:
Patch(TitleColumnPersonList,LookUp(TitleColumnPersonList,Title = "Test1"),{Person:TextInput1.Text})
and that is all. See if this works better for you.
The response above is presuming the following:
SharePoint List called TitleColumnPersonList (use the name of your SharePoint List instead).
Tested by us - actual result in SharePoint List after the button is clicked in Canvas App:
Notice - that only Person column was changed of only that first row / record!
See it in action below as well:
The example above also presumes:
One Text Input control called TextInput1 for the TextInput1.Text part of the Patch formula. This can just be something else entirely in your case, obviously - you can even just hard code a string value there instead first when practicing.
The Gallery1 being there and hooked to the SharePoint List data source in the visual example above is not presumed or required - it is only there to show it visually in action and that it is working to Patch only the one column in the one record from SharePoint List.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
PS: Just noticed you meant to create new record based on original record. So do it like this instead for that way:
Screen1 OnVisible:
Set(_BaseRecord,LookUp(TitleColumnPersonList,Title = "Test1"))
In this simple example we set one record to the variable on screen visible. You could easily instead adapt this example and Set that variable from another trigger, such as to select a specific record instead from a Gallery, and use the Lookup accordingly there in that property.
Button1 Patch:
Patch(TitleColumnPersonList
,
{Title: _BaseRecord.Title, Column1: _BaseRecord.Column1, Person: TextInput1.Text}
)
Version in action that we think you really wanted:
Check if the above helps you @Canadiansal .
