Answered

How to filter a Dropdown box based on the value in a different column in the data source

(0) Share

Report

Posted on by danb_dt

I have an Excel data source and I am using the Column 'Surname' for my dropdown list. I have another column called 'Active' that contains Yes, No Values.

I would like my dropdown list to only display Surname's where the Active column row is Yes.

Many thanks for your assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

kbilakanti 315 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Use Filter(DataSource, Active="Yes").SurNames

Was this reply helpful? Yes No
danb_dt 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much, worked perfectly!

Was this reply helpful? Yes No
Geoff100 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I am trying to achieve a similar result, I have an excel table called "Bins" and a column in that table called "BinStatus" the status values are "Active" & "De-Activated". I would like only the bins with an active status
to appear in the dropdown. I put the following in the items property with luck
Any help is most appreciated
Thanks
Geoff

Was this reply helpful? Yes No