Power Platform Community Forum Thread Details

Hi ,i need code to need to filter gallery by list box control

list box is added with items

example

on selecting 'a' in the listbox---the gallery should be filtered -where isacolumn =1

gallery is having table1

if the listbox is selected with a,b the gallery should be filtered -where isacolumn =1 and isbcolumn=1

table1 with below data

id isacolumn ,isbcolumn, isccolumn

id1 1 0 1

id2 0 1 1

Categories:

Building Power Apps

@padma

If the items in the list box are static, then you can create global or context variables in the On Change property of list box.

Set(varA, "a" in listbox.SelectedItems) // If a is selected in the listbox, then varA will be true

Set(varB, "b" in listbox.SelectedItems) // If b is selected in the listbox, then varB will be true

Set(varC, "c" in listbox.SelectedItems) // If c is selected in the listbox, then varC will be true

Now, in the Filter, you can write following logic:

Filter(table1, if(varA, isacolumn=1,true), if(varB, isbcolumn=1,true), if(varC, isccolumn=1,true))

I haven't executed above the above formula. Consider the approach and give a try.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.