cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Damo10
Frequent Visitor

Delegation issue with filtering SharePoint list with lookup column

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

1 ACCEPTED SOLUTION

Accepted Solutions

hello @Damo10 ,
Please try this:

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

 

this should work.

-----------------------------------------------------------------------------------
Liked My Solution? Click on the Thumbs Up below.
Did I answer your Question? Please Click Accept as Solution below

Want to Support me? Buy Me A Coffee

View solution in original post

6 REPLIES 6
theapurva
Super User
Super User

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)
-----------------------------------------------------------------------------------
Liked My Solution? Click on the Thumbs Up below.
Did I answer your Question? Please Click Accept as Solution below

Want to Support me? Buy Me A Coffee
Damo10
Frequent Visitor

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
Super User
Super User

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:

 

BCBuizer_0-1665478059558.png

 

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)

 

 

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
Damo10
Frequent Visitor

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.

Damo10_0-1665478414179.png

 

Regards,

Damian

hello @Damo10 ,
Please try this:

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

 

this should work.

-----------------------------------------------------------------------------------
Liked My Solution? Click on the Thumbs Up below.
Did I answer your Question? Please Click Accept as Solution below

Want to Support me? Buy Me A Coffee
Damo10
Frequent Visitor

Hi,

That works perfectly, thanks for your help.

Regards,

Damian

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,577)