Trying to filter based on a yes/no field

[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? 

[timl · Accepted solution]

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'.

[rampprakash]

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