Delegation issue with filtering SharePoint list with lookup column

[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

[theapurva]

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)

[Damo10]

Hi,

Thanks for the reply.

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

Regards,

Damian

[BCBuizer]

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)

[Damo10]

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

[theapurva · Accepted solution]

hello @Damo10 ,
Please try this:

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

this should work.

[Damo10]

Hi,

That works perfectly, thanks for your help.

Regards,

Damian