Hi @Anonymous ,
Do you want to get rid of the Delegation warning issue in your Filter formula?
According to the issue that you mentioned, I think you have faced a Delegation issue with your Filter formula. Currently, the 'in' operator is not delegated in SP connector, please check the following article for more details:
https://docs.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint
The Delegation warning issue is not an error, it just means that you could not delegate the Data process from your app to your data source itself. Instead, you could only process data locally. And you could only process 2000 records locally at most.
More details about the Delegation issue in PowerApps, please check the following article:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
If the amount of records in your SP List is not more than 2000, you could ignore this warning issue. Please make sure set the "Data row limit for non-delegable queries" option to maximum value -- 2000. Then you need also to modify your formula as below:
Filter(
Approvals,
Title = Gallery_approvals_list.Selected.Result,
User().Email in Concat(Approver, Email & ";")
)
Please try above formula then check if the filtered results could be displayed well in your Gallery.
If you want to remove the Delegation warning prompt, and the amount of your SP List is not more than 2000, I think the collection could achieve your needs. Please try the following workaround:
Set the OnSelect property of the OnStart property to following:
ClearCollect(RecordsCollection, Approvals)
then modify your formula as below:
Filter(
RecordsCollection,
Title = Gallery_approvals_list.Selected.Result,
User().Email in Concat(Approver, Email & ";")
)
then re-load your canvas app, then check if the Delegation warning issue is gone.
If the amount of your SP List records is more than 2000, I think there is no direct way to achieve your needs in PowerApps. As a possible solution, you could consider fire a flow from your canvas app, and then retrieve records from your SP list using the flow, then return the retrieved records back to your canvas app, and save it into a collection. After that, you could apply above Filter formula to collection.
Please check and see if the following thread solution or video resource could achieve your needs:
https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-get-combobox-to-show-all-the-results-from-SP-list/m-p/612204#M193064
https://www.youtube.com/watch?v=2M0zCyu__20
Regards,
