
I've built a Power App which uses the barcode scanner and then updates as SharePoint list once the form data is summited.
Now, I have created a custom connector for Service Now using their API so that the Scan data can go straight to Service Now bypassing SharePoint.
I have a few questions to make this App efficient for our users.
1. A scan Button initiates the scanner/camera and then populates a field in a form with the serial number. At this stage can I add an action for the Snow connector to run a GET command to check if this serial already exists.
2. On submission of the form data, how can i run a check to see if the asset exists already and then give the user an option to either Update the Record in Service Now using the PATCH method (via connector) or Create a new record using the POST method (via connector)