cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rafaelbenicio
Helper II
Helper II

Filter/Search Function SharePoint List

Hi Everyone, 

 

I'm sorry for a possible duplicate post but none of the solutions I've found over here worked for me. I'm trying to have a simple search bar field that searches for some request types from my sharepoint list. Thanks for stopping by and trying to help me out. 

 

Here are some of the screenshoots so then you can have a better understanding of my case. Thanks! 

 

Overview from my applicationOverview from my application

 

Error Description on PowerAppsError Description on PowerAppsOverview from my applicationOverview from my applicationError Description on PowerAppsError Description on PowerApps

13 REPLIES 13

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

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

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

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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,719)