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?
Solved! Go to 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'.
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'.
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
22 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
24 | |
8 | |
6 | |
5 | |
5 |