Answered

Gallery search function on nested columns

(0) Share

Report

Posted on by PowerBridge

Hi There,

I have a collection (Col_Sample) and it has Column name "WO" which has table inside and it has "WO_test" column. I need to use Col_Sample as data souce of Gallery and want search contents of "WO_test". Have spent significant time to create a search function to search on "WO_test". Nothing is working, i would appreciate if someone can help. Here is the sequence

Col_Sample->"WO"->"WO_test.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerBridge

Use AddColumns() on the collection to add WO_test by looking up the value in the WO table. This will expose it to be searched.
PowerBridge 15 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp thanks for your advice, this AddColumns suggestion is not working in my case. I created WO_test column by using group by function. Is there anything else which i can try?
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerBridge

I would have suggested that next.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerBridge :

Could you tell me what "WO_test"'s datatype is?I assume it is a text column.

I assume there is a collection something like:

ClearCollect( Col_Sample, { ID: 1, WO: Table( {WO_test: "A"}, {WO_test: "B"} ) }, { ID: 2, WO: Table({WO_test: "C"}) }, { ID: 3, WO: Table({WO_test: "D"}) } )

1\Add a TextInput control(TextInput1)

2\Add a gallery and set it's items property to:

Filter(Col_Sample,TextInput1.Text in WO.WO_test)

Best Regards,

Bof