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

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

Highlighted
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
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 216 members 4,705 guests
Please welcome our newest community members: