Tech Battle Field

 Every time while working with PowerApps with large data sets I can see the delegation issue and get only 2000 items. By default PowerApps supports only 500 items. We can set the items until 2000 in the PowerApps setting by navigating Settings of the Power Apps and set “Data Row Limit” to 2000 as below. But working with more than 2000 records is always issue in Power apps due to delegation limitation. For that I have used simple function using Concurrent as below. Concurrent function will run multiple functions concurrently. Using following logic, I got multiple items (for my case it is 10000 records in the SharePoint Lists item. I have used following function to get the items Concurrent( ClearCollect( Collection1To2000, Filter(SharePointListName,ID<2000) ), ClearCollect( Collection2000To4000 , Filter(SharePointListName,ID >=2000 And ID<4000)), ClearCollect( Collection4000To6000, Filter(SharePointListName,ID >=4000 And ID<6000)), ClearCollect( Collection6...

While merging two SharePoint lists in Power Apps, I have used Employee ID as a lookup Column. But both lists are using Same Name as “Employee ID”.   To Fix the issue, we need to use “With” function to update the column. Here are the logic I have used to merge the lists. Here “NewStudAdmin” is a partial data. Here With  function evaluates a formula for a single record. This formula calculate the value to perform actions to modify the data while working with collections. The above formula will work to combine two lists data based on Employee ID. Here EmployeeData1 – LIST1 EmployeeData2 – LIST2 We need to merge these two lists based on Employee ID common field in the two lists. When I try to merge these lists with ForAll and Lookup without “ With ” function, I got an error “Incompatible to comparing the two lists in the Lookup” Hope this helps.