in delegation issue SharePoint

[felipewltc]

Hello there, 

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@hotmail.com; email1@hotmail.com, 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:

[RandyHayes]

@felipewltc 

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.

[felipewltc]

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 

[RandyHayes]

@felipewltc 

Did you try the formula I provided?

It will get you past the delegation issue of using the In operator.