Power Platform Community Forum Thread Details

Hello,

I have 2 Sharepoint lists: Parent and Child with a 1-N relation. The same are related with a lookup column that every child has one Parent related item.

I want to be able to filter (using a Text Search Box) my gallery not only the Parent list items but also to fetch a parent list item whenever I find a reference in a certain column from the child list items.

Example:

Parent list:

Title

Child list:

Title	Related Item
A2	A1
B2	A1
C2	C1

If I write in my text search box C2, I want to fetch the related item - C1.

I have the following query in my gallery:

If(
Checkbox1.Value = true && IsBlank(TextSearchBox1),
If(
!IsBlank(Dropdown1.Selected.Value),
Filter(
'KB_items (mirror)',
Department.Value = Dropdown1.Selected.Value
),
'KB_items (mirror)'
),
If(
!IsBlank(TextSearchBox1),
Filter(
'KB_items (mirror)',
Approval = "Approved" And (Or(
IsBlank(Dropdown1.Selected),
StartsWith(
Title,
TextSearchBox1.Text
),
Department.Value = Dropdown1.Selected.Value
)) And (TextSearchBox1.Text in Title || TextSearchBox1.Text in 'Tag Value' || TextSearchBox1.Text in Concat(
'VB Products'.Value,
Value & ","
) || TextSearchBox1.Text in Concat(
'Market Segment'.Value,
Value & ","
) || TextSearchBox1.Text in Concat(
'Use Cases'.Value,
Value & ","
))
)
)
)

Is this possible to achieve? Can someone guide me with this?

Thanks and sorry if I sound rookie but I am quite new in Powerapps...

Categories:

Building Power Apps

Hi @evaristo ,

I am not totally clear what list belongs where, but the structure below maintains a big of Delegation capability and adds the fields from the parent list

With(
 {
 wData:
 Filter(
 'KB_items (mirror)',
 (
 Checkbox1.Value ||
 Approval = "Approved"
 ) &&
 (
 Len(Dropdown1.Selected.Value) = 0 ||
 Department.Value = Dropdown1.Selected.Value
 ) 
 )
 },
 Filter(
 AddColumns(
 wData,
 "ParentField1",
 LookUp(
 ParentList As aList,
 aList.Title = 'Related Item'
 ).ParentField1,
 "ParentField2",
 LookUp(
 ParentList As aList,
 aList.Title = 'Related Item'
 ).ParentField2
 ),
 (
 Len(TextSearchBox1.Text) = 0 ||
 (
 TextSearchBox1.Text in Title || 
 TextSearchBox1.Text in 'Tag Value' || 
 TextSearchBox1.Text in Concat(
 'VB Products',
 Value
 ) || 
 TextSearchBox1.Text in Concat(
 'Market Segment',
 Value
 ) || 
 TextSearchBox1.Text in Concat(
 'Use Cases',
 Value
 )
 )
 )
 )
)

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.

MVP (Business Applications) Visit my blog Practical Power Apps