Unanswered

Search for a User in a Person or Group Column

(0) Share

Report

Posted on by CEDRICK

Hello,

This formula works, but i need it to work on large data sets. Do you guys know any alternative to make this work on large data sets?

Filter('Department List', User().Email in CC.Email)

This Formula checks if the logged in user is in a Person or Group Column. It returns all of the department the User Belongs to.

ID	Department	CC
1	Accounting	jon.snow@got.com;johnny.silverhand@cpunk.com
2	Security	johnny.silverhand@cpunk.com;jon.snow@got.com
3	IT	jon.snow@got.com;

If User().Email is johnny.silverhand@cpunk.com

It Returns: Accounting, Security

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CEDRICK ,

You did not say how large, but the in filter is not Delegable (which you clearly need here). I have done a blog on Delegation and maybe one of the large collection options may be suitable. Happy to assist with your code if you get stuck.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
CEDRICK on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , Apologies, but i don't understand delegations. Right now the formula has a delegation warning. The solution i'm looking for is the same output but without the delegation warning.

Thank you for your understanding.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@CEDRICK ,

That is the whole point - the in filter is not Delegable - you simply cannot search a large data set in SharePoint using it and you need it if you are looking for part of a field. Please take the time to read at least the first part of my blog as if you do not understand Delegation and want to work with SharePoint, you will see this issue more regularly than you want to.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
CEDRICK on at

Like
a
(0)

Report
Copy link

Link copied!

Apologies, So what your saying is there is no solution because the in filter is not delegable? If that's the case do you recommend any alternatives? or do you have a recommendation on how to design the SharePoint list to prevent the usage of In ?
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@CEDRICK ,

You would need all the items you are searching for to be in separate records (single lines of text), then the query would simply be equals (which is Delegable). You still did not say how big the list was as there may be workarounds with collections.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.