Hi everyone,
I am trying to build up an Asset Check-Out system in Power Apps, and I have a sharepoint list to record the request from my team. What I wanted to do is to display pending cases details and update asset serial number through an input box.
I am using a gallery with filters to display all the pending cases that need to patch the serial numbers; and a DisplayForm to show the details of the selected case. These first two steps are working just fine. But the last step, the text input and button fail to do what I wanted.
Here's the code I currently use:
Patch('ISC Asset Request Form', LookUp('ISC Asset Request Form', 'Case ID'= DataCardValue17.Text),{'Asset S/N':AssetSerialNumber_Input});
- Source: 'ISC Asset Request Form'
- Case ID works as an identifier to find the specific request case:
- 'DataCardValue17' is the display value in the display form.
- 'Case ID' is the key column in sharepoint list
- Information I need to patch: Asset Serial Number
How can I revise the code to make the patching right? Or might there be another efficient ways to do this update record?
Thanks in advance!
