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)

Sort by

theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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,833 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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
a
(2)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Poliva 3 on at

Like
a
(0)

Report
Copy link

Link copied!

This is the answer, thank you

Was this reply helpful? Yes No