Answered

How to filter items from selected multiple ListBox values

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Mates,

we have requirement to apply filter with multiple values... example : from list box 1 select multiple item next list box 2 load and display values respective rows.

When selected(clicked) on Car Then filter and display in list box 2 with LA,Calif,SW, if selected/clicked car and Bus then has to load LA,Calif,SW,TR,TS but its not loading..

let say click/selected on Bus,bike then MM,TR,TS

As of now i have two list boxes(list box 1, list box 2)

list box 1 Property : Item: Distinct(Test,Travel)

list box 2 property : Item: Sort(Distinct(Filter(Test,Travel=list box 1.Selected Text. Value),Route),Result,Ascending)

here issue is i can not get values when selected multiple values, but i can get only for one item at a time

means as per table above

Also share your idea using list box is right way or if we have any simple/better way to filter by selecting multiple items.

Help would be highly appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

eka24 20,923 on at

Like (1)

Report
Copy link

Link copied!

Use
Sort(Distinct(Filter(Test,Travel in ListBox1.SelectedItems),Route),Result,Ascending)

Also try
Sort(Filter(Test,Travel in ListBox1.SelectedItems),Route)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24 ,
"Sort(Distinct(Filter(Test,Travel in ListBox1.SelectedItems),Route),Result,Ascending)"
Here it shows invalid arguments with sort and distinct.

"Sort(Filter(Test,Travel in ListBox1.SelectedItems),Route)"
here it is loading some thing, but not target column values, i really afraid here how its loading other field values with out specifying/referring that column.
means its loading other column but not target column.
Assist me how can load correct target field values only.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Can you show the items or the two listBoxes
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24
two list box:
first one formula : Distinct(table, TestField)
Second : Sort(Filter(table, TestField in lstb_MoleculeType.SelectedItems),SeconField)

First list box is loading few values.
Second list box is loading but not the target filed values, its loading another field values..
The movment when i click on first list box, items are adding in second list box but not the target field values.
second list box formula is there in the image.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

If the target column is MoleculeType, then put tblData.MoleculeType on the Items of the ListBox.
So it should be TableName.Column
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @eka24
list box 1 is loading MoleculeType values,
List box 2 is loading MoleculeSource field values,
even i tried as per recent update like TableName.Field but still no luck
Sort(Filter(testdata, MoleculeType in lstb_MoleculeType.SelectedItems),testdata.MoleculeSource)
here it shows error sort has invalid arguments.
Highly appreciate if you try from you end if possible, to close this issue.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Try
Sort(Filter(testdata, MoleculeType in lstb_MoleculeType.SelectedItems),MoleculeSource)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @eka24 ,
below formula it self working fine.
i just removed Order then its fine.
Sort(Distinct(Filter(Test,Travel in ListBox1.SelectedItems),Route),Result)
Really Thanks for your support and help(helping on sharing formula)

Was this reply helpful? Yes No