Fetch record based on any unique attribute and update the record using patch in canvas app
A Canvas app in Power Apps is a type of app that allows you to build custom business applications for various purposes, such as data collection, process automation, and data visualization. You can build Canvas apps using a drag-and-drop interface, with no coding required. You can also add custom logic to your app using Power Apps formulas and functions, or by integrating with other services and APIs. In this blog we are going to discuss a specific scenario which is to fetch a particular record fulfilling our filtering criteria and modifying the record using Patch function. We have a Contact table in Dataverse and each record in the Contact table has a unique AutoNumber . Here we are trying to fetch the record by calling the unique AutNumber value and updating another attribute named Score of the record. Step 1: Add a textbox and a button to a blank page of canvas app. We will set the names of textbox and button as txtBox and btn respectively. Step 2: In the OnSelect prope