Answered

Trying to filter based on a yes/no field

(1) Share

Report

Posted on by patricia_r

Hi everyone, I'm trying to filter dropdown items based on Yes/No field from dataverse, if the field is false then the item should not be available in the dropdown selection choices. I have a column template Id as the primary name column and the yes/no column name Is Active.

I have try this formula with no luck.

I am getting this error too:

Any idea how to go about this issue?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

timl 36,411 Super User 2025 Season 2 on at

Like (3)

Report
Hi @patricia_r

To filter by a yes/no column, you would set the items property of the dropdown to this:

Filter(YourTable, 'Is Active'= 'Is Active (YourTable)'.Yes)

If you want to display the 'template id' value in the dropdown, you can set the Value property of the dropdown to 'template id'.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

hello @patricia_r,

Try using this

Filter(AddColumns('Template markets',"hidenotactive",'Is Active'= 'Is Active (YourTable)'.Yes),hidenotactive).'Template ID'

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
mwal 20 on at

Like (0)

Report

Hi I'm looking to do the same thing but not all items I want to show have the yes / true value populated. So I'm basically just trying to figure out how to exclude all items that have a no value in the "Visible" column. Any ideas?

Was this reply helpful? Yes No