filter for gallery works only if outside of a card

[Sifu]

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 thisitem.id 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?

[doubleecpu]

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. 

[Sifu]

@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...

[doubleecpu]

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.  

[Sifu]

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

[Sifu]

@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))

[WarrenBelz]

@Sifu ,

If you want to get rid of the warning

With(
   {
      wList:
      Filter(
         'SPO List', 
         ThisItem.ID = ParentID
      )
   },
   Filter(
      wList, 
      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