Bulk creating items in PowerApps using For All and Patch
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, ...