cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gottijay2000
Level: Powered On

Searching Large Lists for a lookup fields while filtering the result for cases where Current User Appears in Multiple People Field

i'm looking to implement a search feature where users can search for items from a Lookup field in the list while also filtering the results to only show items where the current users has been assigned to or his name appears in the multi people field.

 

Both actions are problematic because of delegation and i'm strugling to see any walk around available to solve this 

Details

ListName: TaskList (~7000 items)
Multi People Field Name: Assigned To

LookupField: FirstName (which is a text field in another List called CaseNames which is also ~8000 items)

First tried to grab all the items that match the the search string first before fitering the Col_search collection further to  retrieve only the items the user was assigned to using Startswith which is delegable on sharepoint, but that didnt work because the Firstname is a lookup 

Collect(Col_Search, Filter(TaskList, StartsWith(Text(CaseNames_0034x_FirstName), "Steve")));

then

Collect(Col_FilteredItems, Filter(Col_Search, "john.Doe@email.com" in 'Assigned To'.Email) )

But this secon line would not work because i'm not actually all the items because of the delegation issues

 

Also thought about swapping the logic around where i'm first checking to pull all the items that are currently assigned to the current user before then applying the search string.

 

Any ideas on how to approach this will be appreciated

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: Searching Large Lists for a lookup fields while filtering the result for cases where Current User Appears in Multiple People Field

Hi @Gottijay2000 

 

Please check

http://rezadorrani.com/index.php/2019/09/18/powerapps-delegation-with-sharepoint-as-a-data-source-wi...

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
Highlighted
Dual Super User
Dual Super User

Re: Searching Large Lists for a lookup fields while filtering the result for cases where Current User Appears in Multiple People Field

Hi @Gottijay2000 

 

Please check

http://rezadorrani.com/index.php/2019/09/18/powerapps-delegation-with-sharepoint-as-a-data-source-wi...

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,619)