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

PowerApps Search function broken after filter?

Hi all,

 

I've created an App to lookup information from a sharepoint list and have filtered that list. The filter looks up a choice field and selects only those records that are set to active or inprogress.

 

So the Gallery item property looks like this... Filter('SharepointList', Status.Value="Active"||Status.Value="Inprogress")

This works fine and brings back only those fields that are active or inprogress. However the search bar at the top doesn't do anything, at all. I'm pretty sure the filter has killed the ability of the search.

 

Also I get a warning about part of the filter cannot be evaluated remotely. Could this lead to the 500 limit being hit and stopping it from working?

 

Thanks in advance

jam

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino
Level 10

Re: PowerApps Search function broken after filter?

hi @jam, let's take all your valid points one at a time:

 

1) I'm pretty sure the filter has killed the ability of the search.

In order for the search to work, the Items property of the gallery should include the search item.  I assume the search bar is a text input, let's say TextInputSearch.  Then the Items property of your gallery should be:

Search(Filter('SharepointList', Status.Value="Active"||Status.Value="Inprogress"), TextInputSearch.Text ,"MySearchColumnName")

2) I get a warning about part of the filter cannot be evaluated remotely. Could this lead to the 500 limit being hit and stopping it from working?

Your app will still work, however only the first 500 items of your data source will be queried.  Anything in the gallery will be a subset of the first 500 items (in order of ID) of your data source.

 

Please let me know if anything needs further clarification

View solution in original post

5 REPLIES 5
Meneghino
Level 10

Re: PowerApps Search function broken after filter?

hi @jam, let's take all your valid points one at a time:

 

1) I'm pretty sure the filter has killed the ability of the search.

In order for the search to work, the Items property of the gallery should include the search item.  I assume the search bar is a text input, let's say TextInputSearch.  Then the Items property of your gallery should be:

Search(Filter('SharepointList', Status.Value="Active"||Status.Value="Inprogress"), TextInputSearch.Text ,"MySearchColumnName")

2) I get a warning about part of the filter cannot be evaluated remotely. Could this lead to the 500 limit being hit and stopping it from working?

Your app will still work, however only the first 500 items of your data source will be queried.  Anything in the gallery will be a subset of the first 500 items (in order of ID) of your data source.

 

Please let me know if anything needs further clarification

View solution in original post

jam
Level: Powered On

Re: PowerApps Search function broken after filter?

Thanks for your help Meneghino, that worked perfectly. All but for the annoying blue dot.

 

Next I need to know when PowerApps will be able to Delegate this to SharePoint Online as I'm using this as my data source? The list is for a small sales pipeline tool so not going over the 500 limit yet, but they will and I don't want that to happen.

 

Thanks

Jam

Meneghino
Level 10

Re: PowerApps Search function broken after filter?

Hi @jam, you are welcome.

 

I am not sure when PG plan to extend delegation to SharePoint Online.  My suggestion would be to have a look at using CDS (Common Data Service) as a back end, as delegation works already with CDS and I have had a reasonably good experience with CDS so far.

jam
Level: Powered On

Re: PowerApps Search function broken after filter?

Thanks for the quick response. I take it SharePoint Online also supports CDS? I've never used it before so I guess there's a steep learning curve to CDS? Are there any tutorials you could recommend or documentation to read on how CDS works?

Meneghino
Level 10

Re: PowerApps Search function broken after filter?

CDS is part of PowerApps and is not yet supported in SharePoint Online (in the sense that you cannot show data from CDS on a SharePoint page web part etc.).

Please have a look at the following and I or someone else can give you specific guidance.

 

https://powerapps.microsoft.com/en-us/tutorials/data-platform-intro/

 

The tutorial is not particularly clear, and also please note that CDS is relatively new, and I have noticed that features are being added on a regular basis.

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 (5,289)