Filtering a gallery based on another gallery whilst avoiding delegation

[Tono_Analyst2]

Hi,

I have two related SharePoint Lists by an ID. List 1 contains the information I want to display in the gallery. List 2 contains a field that I want to filter on.

I have created two galleries one for List 1 (Gallery 1) and one for List 2 (Gallery2). Gallery 2 is being filtered by the selection of a combo box.

Filter(
    Gallery2,
    IsBlank(CB_Filter.SelectedItems)||IsEmpty(CB_Filter.SelectedItems) || Filter_GUID = 
    Value(CB_Filter.Selected.ID)
)

Gallery 1 is looking at the IDs contained in Gallery 2 that are common using the following code:

Filter(
    'Gallery1',
    GUID in Gallery2.AllItems.Gallery1_GUID
)

However, the in operator causes delegation issues. Is there a work around for this?

[v-yujincui-msft]

Hi @Tono_Analyst2 ,

Could you please provide more details such as your table data structure and App configuration? That will make it much easier to assist.

Best Regards,

Charlie Choi

[Tono_Analyst2]

Hi @v-yujincui-msft , 

I have two galleries that are driven by two separate SharePoint lists. 

Gallery1 'items' = Filter(List1, Gallery2_GUID in Gallery2.AllItems.GUID)

Gallery2 'items' = Filter(Jobs, WP_GUID = 'WP_GUID Filter'.Selected.Value)

Essentially, Gallery1 is related to Gallery2 via the field Gallery2_GUID. I want to filter the column Gallery2_GUID in Gallery1 to contain all GUIDs that are in Gallery2.

In the in image, I have the delegation limits set to 3. Hence. only the first 3 records of List1 is displaying.

I understand that the in operator is not delegable within a filter. What can I do to overcome delegation following the above workflow

[v-yujincui-msft]

Hi @Tono_Analyst2 ，

One simple thing you can do is go to the advanced settings and increase your delegation limit to 2,000 rows.

Best Regards,

Charlie Choi

[Tono_Analyst2 · Accepted solution]

Thank you for your response, however, I would not consider that a robust solution for larger datasets.

I have since solved this following Reza Dorrani's video - Group By in Power Apps Gallery with Large SharePoint Lists - YouTube