Hi @PornpiroonT ,
Firstly, the delegation warning is not an error. So your formulas do not have any problem.
Let me tell you more about delegation.
Actually, delegation is powerapps itself limit.
PowerApps could only deal with at most 2000 records in local.
So when your record is larger than 2000, you app may not perform good, for example it will return wring result.
To avoid delegation's effect, there are two solutions:
1)only use delegateable data source and delegateable functions
Then the data could be dealt in data source, not in powerapps.
Here's a doc about delegateable functions of sharepoint list, plese modify your formulas based on this:
https://docs.microsoft.com/en-us/connectors/sharepointonline/
2)save data in collection
In collection, there will not have delegation problem
If your record is smaller than 2000, then do not need to worry about delegation warning. It will not effect your app's performance.
Just need to change this limit to 2000:
Here's a doc about delegation in details for your reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
Source - https://powerusers.microsoft.com/t5/Building-Power-Apps/Delegation-warning-in-combo-box/td-p/436509.
Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
