cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meneghino
Level 10

Re: Filter gallery items based on a lookup filter :(

hi @Anonymous

are you reposting to see if there are updates on the blue circle warning?

if so, does your app in any case work as it should?

Anonymous
Not applicable

Re: Filter gallery items based on a lookup filter :(

Hi @Meneghino

 

Yes the app works, i just want to know if the blue circle could be deleted.

Anonymous
Not applicable

Re: Filter gallery items based on a lookup filter :(

Hi

 

Yes the app works, i just want to know if the blue circle could be deleted.

Meneghino
Level 10

Re: Filter gallery items based on a lookup filter :(

I suspect that this will go away in one of the next releases, and there should be something imminent.  This is just a feeling, I have no information.

fbxiii
Level: Powered On

Re: Filter gallery items based on a lookup field :(

I am getting the blue i and the message about suboptimal results.  The search appears to be working as I am expecting though as I want to see the 'suboptimal' results on every key stroke in the Search box.  I am just ignoring the message as the App is working as I want/expect.

rdorrani
Level: Powered On

Re: Filter gallery items based on a lookup field :(

Blue symbol indicates no delegation and hence you are limited to the max number of items fetched in PowerApps which is 200 (it has been increased to 500 now)

 

So if you are filtering results from a list which say has 600 items - the query/filter on the lookup column will only run on the first 500 items and hence the warning stating sub optimal results.

As long as your query is being performed on less than 500 items - you should have your results

fbxiii
Level: Powered On

Re: Filter gallery items based on a lookup field :(

Would this be the case if the list is over 500 records but I am filtering the Gallery which should never contain more than 500 records (in this App instance)?

 

I'm still quite new to PA, can you explain what Delegation means and how I could apply it?

rdorrani
Level: Powered On

Re: Filter gallery items based on a lookup field :(

PowerApps delegation and Blue dot suggestions

 

https://docs.microsoft.com/en-us/powerapps/delegation-overview

fbxiii
Level: Powered On

Re: Filter gallery items based on a lookup field :(

I have just got round looking in to this further and after a couple of reads of the article, I still can't work out what is wrong.

 

I am using a sharepoint list which is apparently delegable.  I am trying to search a field called Abbreviation but the blue wavy line is appearing under it.  This list has more than the 500 records so I am seeing the behaviour of the list not showing everything now.

 

Can anyone help me identify what is wrong here please?

 

SortByColumns(
Search(
'Sharepoint List',
TextSearchBox1.Text,
"Abbreviation","Description"),
"Created",
If(!SortDescending1, Ascending, Descending))

 

Meneghino
Level 10

Re: Filter gallery items based on a lookup field :(

Search is not delegable in SharePoint:

 

1.JPG

Helpful resources

Announcements
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: 49 members 4,885 guests
Please welcome our newest community members: