Filter 2 Sharepoint Lists in 1 Gallery

(0) Share

Report

Posted on by ZRK

Hi All,

I've 2 SharePoint Lists. (List-1 is old data list & List-2 is new data list). Both lists have same columns.

I want to filter certain records from both lists based on the column named "XID".

I'm using a textinput control to filter the data. I want to filter both lists and show data in 1 gallery.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ZRK ,

Do you want to combine two filter results and show them in the gallery?

If so, please try this.

OnChange of TextInput.

ClearCollect(COL,ShowColumns(Filter(List1,XID=Self.Text),"ColumnName1","ColumnName2"),ShowColumns(Filter(List2,XID=Self.Text),"ColumnName1","ColumnName2"))

Items of Gallery.

COL

ColumnName1 and ColumnName2 are same named column in two list.

Best regards,

Rimmon

Was this reply helpful? Yes No
ZRK 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-mengmli-msft but i'm currently using this code. I'm working with a live updates data and the ClearCollect function requires to be pressed every time i update data.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ZRK ,

Do you mean that list is updating at the same time? I think ClearCollect is required, have you tried use Timer control to complete press ClearCollect manually?

Or you just don't want to press the ClearCollect function every time, you can combine two list on OnVisible of screen or OnStart of App firstly, the use the Filter.

OnVisible of Screen.

ClearCollect(COL,ShowColumns(List1,"XID","ColumnName1","ColumnName2"),ShowColumns(List1,"XID","ColumnName1","ColumnName2"))

Items of Gallery.

Filter(COL,XID=TextInput.Text)

Best regards,

Rimmon

Was this reply helpful? Yes No
ZRK 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Both lists have more than 50K records. They have a unique number in XID column that connects them. (connected records are not more than 5). Also i've to deal with the data fast. Is there any approach other than ClearCollect that can help me get records from both lists in one gallery?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ZRK ,

Could you please show your formula? I expect more details.

Was this reply helpful? Yes No
ZRK 12 on at

Like
a
(0)

Report
Copy link

Link copied!

ClearCollect(
ccss,
AddColumns(
Filter(
Leads2024,
Last(
Split(
TextInput1.Text,
"@"
)
).Value = XID
),
"SP_NAME",
"LX-24"
),
AddColumns(
Filter(
Leads2023,
Last(
Split(
TextInput1.Text,
"@"
)
).Value = XID
),
"SP_NAME",
"LX-23"
)
)

Was this reply helpful? Yes No
ZRK 12 on at

Like
a
(0)

Report
Copy link

Link copied!

ClearCollect(
ccss,
AddColumns(
Filter(
Leads2024,
Last(
Split(
TextInput1.Text,
"@"
)
).Value = XID
),
"SP_NAME",
"LX-24"
),
AddColumns(
Filter(
Leads2023,
Last(
Split(
TextInput1.Text,
"@"
)
).Value = XID
),
"SP_NAME",
"LX-23"
)
)

Was this reply helpful? Yes No
VishalJhaveri 1,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You need to manage multiple collection on the Onchange property of the elements of the Gallery and then you are ready to go with the solution.

Was this reply helpful? Yes No
ZRK 12 on at

Like
a
(0)

Report
Copy link

Link copied!

@VishalJhaveri That would increase the network calls

Was this reply helpful? Yes No
VishalJhaveri 1,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

To me, that seems the only possible outcome then.

Was this reply helpful? Yes No