Announcements
I have a sharepoint list with email field on records and i want filter all records with email different of my email-> Filter(source,Worked_User <> MyProfile.Mail) and of course i get delegation warinig(because "<>") :(. How i can get this filter results without delegation problem ?
*mypofile is global variable of office356user.myprofile()
How many records are in source?
@SGavoux
Expressions that are joined with And or Or are delegable to SharePoint. Not isn't delegable.
One workaround would be to call MS Flow to query the results and send it back to PowerApps
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1800+ increase rapidly
@Anonymous wrote:How many records are in source?
@RezaDorrani wrote:@SGavoux Expressions that are joined with And or Or are delegable to SharePoint. Not isn't delegable. One workaround would be to call MS Flow to query the results and send it back to PowerApps Regards,Reza Dorrani If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
i have limited flows (2000 per month) in my package. Alse i dont know do this procedure with flow
Hmmm, you could change the data row limit to 2000 for now.
If the amount of records reaches 2000 or more, you could consider creating collections which take the first 2000 records from the SharePoint-list (based on id for example), the second 2000, etc. To reduce the loading time, my advice would be to do this using the concurrent function as well. And when these have been created, merge them in a new collection, so you have a complete copy of the SharePoint-list in your PowerApp.
Check this for more options:
https://michalguzowski.pl/how-to-overcome-500-items-limit-in-powerapps/
How i can filter first 2000 items without "<" , " ,">"v operators ??. Also Startwith makes delagation but Endwith not. Seems trivial to me 😞
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 846
Valantis 532
Haque 410
