cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aadilganie
Level 8

Re: Filter/Search Function SharePoint List

Hi
Not necessarily to be honest. SharePoint has certain delegable types. "=" Is the best in my opinion, but since the lookup field is a complex field that consists of an ID and a VALUE it requires extra attributes.

However if you would like to filter a lookup field it would most likely be something like
Filter(SharePointList, SharePointLookupField.Value = SearchTextBlx1.Text)...Something to that extent.

Hope it helps
Highlighted
rafaelbenicio
Level: Powered On

Re: Filter/Search Function SharePoint List

Thank you for your reply @aadilganie

 

I'm getting the same error message as before! 😕

 

Screen Shot 2018-10-04 at 12.31.44 PM.png

tchin-nin
Level 10

Re: Filter/Search Function SharePoint List

Hi,

Once again you put the formula into the textInput Default property, this can't work.
The TextInput default property expects a string because it is the default text inside the TextInput, you can't use a filter function here.

You have to select your gallery, and set the Items property to set the filter.
Gallery.Items : Filter(...)
Your filter seems correct now, you just have to put the formula in the right place.

Filtering a LookUp works fine only if you have less than 500 (up to 2000) items in your list because of the delegation. Otherwise you'll have to find a workaround.

Théo

aadilganie
Level 8

Re: Filter/Search Function SharePoint List

You’re totally right there. Has to be in the items property.

If you try the formula now it should give more positive results.

All the best

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,826)