Hi @WarrenBelz ,
Thank you for your proposal, I tried to use the patch function but no success. This what I have:
In SharePoint
- List N° 1 name 'Material Specification', the form is displayed from the list when a new item is created
- List N° 2 name 'Change Request', the form is hidden for users
In PowerApps
- 2 Data Sources connected, [@'Material Specification'] and [@'Change Request']
- 1 form 'SharePointForm1'
In the 1st case:
- The user saves the form with the default 'Save' button in SharePoint, the record is saved with all form information in 'Material Specification', the unique ID is 'Item N°', no workflow, no entry in 'Change Request'.
In the 2nd case:
- The user saves the form with the 'Save & submit' button in PowerApps, the record is saved/updated with all form information in 'Material Specification, and in 'Change Request' to populate the 'Item N°' and 'Request Status' with "pending". Also, all the fields form are grey out, checking
For the PowerApps 'Save and Submit' button, I have the submit action:
SubmitForm(SharePointForm1)
And the second action should take the 'Item N°' and create the item in 'Change Request' list with the Status "Pending", all the remaining tasks are managed via PowerAutomate.
The patch function is not clear to me, should I try something like:
SubmitForm(SharePointForm1);
Patch(Change Request, Defaults(Change Request), {Title:"Item N°".... ?
