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
thirdimage

Power Platform 24

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps 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

Top Solution Authors
Top Kudoed Authors
Users online (6,869)