Tech Battle Field

Patch function will submit data from PowerApps to Destination Data location. Sometimes we may not see if patch is successful or failure in the PowerApps until we see the record in Destination location. By using Error Functions in PowerApps we will Notify the Patch errors. Error, IfError, ISError, IsBlankOrError functions will be helpful to detect the errors in the Action. But all these functions will be available in Experimental features in PowerApps. To get the functions, we need to enable the Experimental Features in PowerApps in Settings -> Upcoming Features -> Experimental as below. Error Function will allow us to see if there is any error on patching the Destination. We can add Error function for patching as below. If(IsEmpty(Errors(' <<Destination>> ',                                                   ...

In one of my projects, I got a requirement to get the data from Multiple tables in SQL server and update it to SharePoint list. I have using Join function to combine three tables and saved it to a collection as below. ClearCollect(EmployeeDetails,     AddColumns(         Employees,         "Subjects",         LookUp(Subjects, EmployeeId = Orders[@EmployeeId]))) After collecting data, we can loop all the data in the collection and update it to SharePoint list using the patch function as below. ForAll(EmployeeDetails, Patch(                 MarksDetails,                 Defaults(MarksDetails),                 {Marks1: Marks1, ...