web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps filter a column using ...

Power Apps

Answered

filter a column using a choice value from a different column within a same table

(0) Share

Report

Report

Posted on by bblatnjak

65

Hello!

I am trying to get a result in a dropdown field by filtering two columns within a same Dataverse table.

Dropdown should should show me values in "Expense category" column that are in the same row as "Expense type".Miscellaneous

The end result from my table would be that the dropdown shows only: Taxi, Travel and ProjExp

Please take a look at the image attached, if my explanation is vague, apologies for that!

expense category.png

expense category.png

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@bblatnjak

Please try the following (change names as required),

Distinct(Filter(yourTable, 'Expense Type'='Expense Type Choices'.Miscellaneous), 'Expense Category')

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

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help, much appreciated!
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bblatnjak

Glad to help!

Join the conversation