Answered

Filtering a List Box from two combo boxes

(0) Share

Report

Posted on by Amanda4

Hi,

I am having a few issues with filtering. I currently have an App that is leveraging from two sources, both SharePoint lists.

Most of my form is drawing from one of the SharePoint lists but for this element of the form, I have connected the second list to the Data Card to enable users to be able to search a database of available courses based on two dropdown lists:

1. Target Role (from Choice Column in SP)

2. Course Category (from Choice Column in SP)

This is then intended to filter the List Box (from Multi-line Column in SP) and drilldown to what available there are for the target role and selected course category.

(Pic below)

I have tried different combos of formula but not really sure what I am doing and thought best to seek help on this issue rather than waste more time guessing my way to a solution.

Thanks in advance for your help and guidance.

Thanks,

Amanda

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

v-zhoqian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Amanda4 ,

You could try the following formula:
Filter(ListName,'Target Role'.Value=Dropdown1.Selected.Value,'Course Category'.Value=Dropdown2.Selected.Value)

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.
Amanda4 50 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @v-zhoqian-msft ,

Thanks for your message.

I gave that one a go and it is giving me a delegation warning and the List Box is showing up completely blank. Before and after pictures below
Before updating code:

After updating code:

Any thoughts?

Thanks again for your help.

Cheers,
Amanda
v-zhoqian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Amanda4 ,

Is there a text column and two choice columns in the SharePoint list, the text column is used as the data source of the list box, and the two choice columns are used as the data source of the two dropdowns?
Amanda4 50 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-zhoqian-msft ,

Yes, that is correct.
Amanda4 50 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-zhoqian-msft ,

I have had a play with the advanced settings and I ended up removing the default settings in the List Box (Parent.Default). Once this was removed, it allowed for the filtering to occur. I haven't been able to incorporate both comboboxes to filter yet, but used part of the code that you suggested which works as intended.

Filter('Technical Capability and Learning','Course Category'.Value = ComboBox5.Selected.Value)

It isn't liking the target roles filter for some reason. I will keep plugging away to try and resolve that one too.

Thanks for your help.

Cheers,
Amanda