I want to update a SharePoint-List Item with a canvas-app Powerapp. The data is distributed on 6 different screens with each one form. All the data from all 6 forms should be updated on the last screen with just one button.
I tried using the Patch function on the OnSelect Property of the submit button:
Onboarding is my SharePoint-List
GeneralForm_HR and the other one are my Powerapp forms, where I insert the data to them uptade it on SharePoint
Patch( Onboarding; Defaults(Onboarding); GeneralForm_HR.Updates; WorkplaceForm_HR.Updates; SoftwareForm_HR.Updates; TelephonyFrom_HR.Updates; OtherForm_HR.Updates; AdministrationForm_HR.Updates);;
Using this function all the data will be saved in my Sharepoint-List, but it automatically creates a new completed item and the old Item remains unchanged.
Solved! Go to Solution.
Hey,
if you want to create new item in your sharepoint list, that is when you use Default in your formula as a second argument. If you want to edit a particular item in your list on the second position you have to define it, either using LookUp function or ThisItem or variable where the item is saved.
Hope this helps.
Hey,
if you want to create new item in your sharepoint list, that is when you use Default in your formula as a second argument. If you want to edit a particular item in your list on the second position you have to define it, either using LookUp function or ThisItem or variable where the item is saved.
Hope this helps.
Thank you!
Using the Lookup function to compare the ID of the Item it worked.
User | Count |
---|---|
157 | |
93 | |
78 | |
73 | |
57 |
User | Count |
---|---|
202 | |
166 | |
98 | |
94 | |
79 |