trying to filter 2 dropdowns in a gallery ?

(0) Share

Report

Posted on by Jamesyb213

Hi All,

I need some help.

I have created a powerapp and am looking to have two dropdowns filtering the gallery? I have one filter working but cant get them linked to work together .

Anyone able to assist ? one filter is company code ( free text ) second field is a choice field with the below choices.

The below works for the company code but can get them linking together

Filter('DATA','Company Code'=Dropdown1.Selected.Result)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Jamesyb213 You have to couple them with &&

Filter('DATA','Company Code'=Dropdown1.Selected.Result && 'Error Status'.Value=ErrorStatusDropdown.Selected.Result)

Please remember to give a 👍 and accept my solution as it will help others in the future.
Jamesyb213 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked! Thank you 🙂
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Jamesyb213

Glad to help!