I have a dropdown that needs to change the selected item based on a series of checkboxes. So far most checkboxes work perfectly, except one. The options for the dropdown are, among other ["RO", "Published", "Product Cancelled"....]. I define the current selected item by using a variable called "currentStatus", and use this on the dropdown to select it:
DefaultSelectedItems: Filter(Choices([@'Publications Log'].Status), Value in currentStatus)The issue I'm having is between the values "RO", and "Product Cancelled". I imagine the issue is that both items contain "ro" on them.
The checkbox OnCheck is:
OnCheck: Set(currentStatus, "Product Cancelled");As I said, all checkboxes work fine except this one. Every time I check it, the dropdown selects "RO", instead of "Product Cancelled"
How can I fix this?

Report
All responses (
Answers (