The ask, help a maker scale their Power Apps solution. They created a canvas app some years back and being frugal, they chose SharePoint Online (SPO) lists as their app's data source. Now, three years later, that frugal decision is haunting them as they've hit the 2,000-item delegable limit. To rebuild their data source with … Continue reading SharePoint Lists: Migrating to Dataverse Tables | Enforce Unique Values
SharePoint Datasets
Power Automate + SharePoint Online: Get Items | Lookup Column Threshold Error
The ask, correct a failing Power Automate cloud flow. For months, this flow ran daily, without issue, querying a growing SharePoint Online list, but now, the Get Items action is failing and throwing an error: "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold." Figure 1 … Continue reading Power Automate + SharePoint Online: Get Items | Lookup Column Threshold Error