Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

filter for gallery works only if outside of a card

I have a form which has a gallery, that works well but there's a delegation warning because of converting the title to value

Filter(Sort('SPO List', ID, Descending), ThisItem.ID = Value(Title))

 so i created a new number column called ParentID and adjusted the formula, but no results:

Filter('SPO List', ParentID = ThisItem.ID)

 I was wondering if when i replace for specific value... but its the same...

I then moved the gallery outside of the form and card and there it works (with specific value or referring to a label that contains the ThisItem.ID...

Any idea why?

Regular Visitor

If i am understanding what you are trying to create is a Form for users to update data and gallery to display any related data on the same screen? Matching is not clear to me besides the first which matches the ThisItem.ID = Title.  

On the second Filter ParentID = ThisItem.ID might be reversed if ParentID is set on the form and that is what you are filtering for in the gallery. 

@doubleecpu form contains the ID (this item ID)... the spo list has in the title or in the column parentid the same value so a connection can be created...

Regular Visitor


Filter(Sort('SPO List', ID, Descending), ThisItem.ID = Value(Title))

 Change it to this, You can ignore the delegation warning if you have less rows that the row limit or 2000 rows 

Sort(Filter('SPO List', ThisItem.ID = Value(Title)), ID, Descending)


If that doesn't work you need to figure out the correct ID, Card_Name.Default, TextLabelName.Default... etc to use in the filter especially if you want it to change based on user input.  

unfortunately i started investigating because users could not see their items... were too old items but still so i must obey the delegation...

@doubleecpu @WarrenBelz 

i have now figured a way how to sort it...., pre filter the source, kind of nested filtering, this throws a warning but works well....

Filter(Filter('SPO List', ThisItem.ID = ParentID), ThisItem.ID = Value(Title))

@Sifu ,

If you want to get rid of the warning

         'SPO List', 
         ThisItem.ID = ParentID
      ThisItem.ID = Value(Title)


Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps


Helpful resources

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,257)