Answered

Delegation issue with filtering SharePoint list with lookup column

(0) Share

Report

Posted on by Damo10

Hi,

I have 2 SharePoint lists and the second has a lookup column to get the ID from the first one, so that when adding images to the second list they have the ID from the original entry.

What I am having issues resolving is that I have created a gallery to show the images for the selected item but I am getting a delegation warning and I am not sure how to correct it.

The issues is with the Value(Issue.Value)= section

'Issue' is the lookup column to the other SharePoint lists ID column. I know that Value is not delegable but I don't know a way around it.

Below is the code for the filter, any help would be greatly appreciated.

Filter('Reported Issues Images',Value(Issue.Value)=galTrailerRAG.Selected.ID)

Regards,

Damian

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Hello @Damo10 ,

Because you are storing Id gets stored automatically when you create Lookup column so use below formula:

Filter('Reported Issues Images',Issue.Id=galTrailerRAG.Selected.ID)

Was this reply helpful? Yes No
Damo10 22 on at

Like (0)

Report

Hi,
Thanks for the reply.

I tried that but it is still getting a delegation warning on the .ID= for the Issue.

Regards,
Damian

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (2)

Report
Hi @Damo10 ,

In the original filter, it was the Value function that is not delegable.

For LookUp columns, only the Value field is delegable, so can you please confirm what has been selected for the Value?

In the below example it is the Title column of the parent list:

An example of a delegable filter for this, matching LookUpColumn.Value against Test.Title (in the TestGallery), is:

Filter(DataSource,LookUpColumn.Value = galTest.Selected.Title)

Was this reply helpful? Yes No
Damo10 22 on at

Like (0)

Report

Hi,
Here is how the lookup column is set up. I have not used the Title column as there will be several entries with the same value so I used the ID as this will be unique.

Regards,
Damian

Was this reply helpful? Yes No
Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like (2)

Report
hello @Damo10 ,
Please try this:

Filter('Reported Issues Images',Issue.Value=Text(galTrailerRAG.Selected.ID))

this should work.

Was this reply helpful? Yes No
Damo10 22 on at

Like (0)

Report

Hi,
That works perfectly, thanks for your help.
Regards,
Damian

Was this reply helpful? Yes No
Poliva 3 on at

Like (0)

Report

This is the answer, thank you

Was this reply helpful? Yes No