How can I make this block of code delegatable

[jbucks]

It is not querying everything and only returning the starting "X" values.

I am trying to filter through my SharePoint list and only display the data that matches the value selected in my drop down list "ddlAssignedTo" to the data in my choice column "Assigned_To" in my SharePoint list.

I am getting delegation issues and I am not sure how to rewrite this code to make it work.

Filter(
    Lanes,
    Completed = false &&
    Assigned_To in ddlAssignedTo.SelectedItems
)

[Prabhakar_S]

Hi @jbucks ,

Try this,

Filter(
Lanes,
Completed = false &&
LookUp(
ddlAssignedTo.SelectedItems,
Value = Assigned_To
) <> Blank()
)

or

Filter(
Lanes,
Completed = false &&
IsBlank(ddlAssignedTo.Selected) || Assigned_To = ddlAssignedTo.Selected.Value
)

If you still encounter any issues, post the error with a screenshot.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[jbucks]

There is a syntax error on the first one where the "<>" is

The second code runs but gives the same, only shows the first 2 records when there should be 6 records displayed.

First screenshot is the program, and the second screenshot is the data in the sharepoint list

[Prabhakar_S]

Hi @jbucks ,

Try this,

Filter(
AddColumns(
Lanes, 
complet, 
Completed, 
assignto, 
Assigned_To),
complet = false &&
assignto in ddlAssignedTo.SelectedItems
)

You can use the AddColumns Function to overcome the delegation.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[jbucks]

Still does not work just shows the first 2, I just tested and confirmed it as delegation as well, the 2000th record shows up but when i make a change to the 2001st record it does not show up.

[Prabhakar_S]

Let's try a different approach to overcome the delegation limitations and filter the data properly. One potential solution is to use a combination of delegable and non-delegable functions to filter the data.

Filter(
Lanes,
Completed = false &&
LookUp(
Lanes,
ID = LookUp(
ddlAssignedTo.SelectedItems,
Value = Assigned_To
).ID
).ID = ID
)

- 'LookUp(Lanes, ID = ...).ID' looks up the item in the 'Lanes' list that matches the ID of the selected item from the dropdown.
- We compare the IDs of the items to ensure proper delegation.

This approach uses delegable functions for lookup and comparison, which should help overcome delegation limitations. Please replace 'ID' with the actual primary key column name in your SharePoint list ('Lanes'). This solution assumes that the primary key column is delegable.

If it's not, you may need to reconsider your data model or filtering strategy.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[jbucks]

Thanks for the help but still not working.

I believe I have to figure out a way to not use the "in" keyword. It is causing the issue with the delegation

[Prabhakar_S]

Refer this blog to avoid delegation:

Delegation – Practical Power Apps

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[jbucks · Accepted solution]

I figured out how to fix this and it was much easier then I thought:

Filter(
    Lanes,
    Assigned_To.Value = ddlAssignedTo.Selected.Value &&
    Completed = false
)

[BIVRE]

Take into consideration this will only filter by your last selected item in the dropdown, not all items.