I have this problem, I am using SharePoint as a Database and I have a collum with a group of people that can see specific information in Power Apps, so the problem is that I am the in function because I have the email address in a text column so I have email@example.com; firstname.lastname@example.org, so if the email is in that column shows this data, but I am going to have more than 2000 records and I need a way to be able to solve this, any ideas?
I need to be able to show all the data in my collection, but it has the 2000 limit and directly from the list, the warning problem, so is the same at the end of the day:
Consider changing your formula to the following:
Filter( AddColumns( Filter( WorkFlow_Tool_Power...can'tReadTheRest, ApproverNameTXT = VarUser.displayName ), "GroupTxt", DistributionGroupFTxt & DistributionGroupSTxt ), VarUser.mail in GroupTxt )
I hope this is helpful for you.
Thank you for your help, in this case, I do not need to combine the information, I need to use "in" but is not delegable in SP and my collections are just showing the limit that i have in the non delegable option
Did you try the formula I provided?
It will get you past the delegation issue of using the In operator.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!