I have a SharePoint column that has about 8 Choice values in it (you can only select one). There's another
Based upon a previous selection in the Canvas form, I want to filter out 2 items if you pick one value from another Choice column (column B) and another item if you pick an alternate value from Column B.
This is what I have so far, which successfully filters the single item from my dropdown list, if I pick a specific value in Column B, in the Items field:
With(_items:Choices([@'splist here'},'Name of SP list')
},
If(DataCardValue9.Selected.Value = "Remote", Filter(_items,Value<>"In Office Issue"),_items
)
)
So that works for the 2nd half of my request. What I am thrown off on, is how I add a second "If" statement where the selected value = "something else" and filters out two other values from the dropdown list instead.
I tried a switch command based upon some other searches, but that didn't work. I also tried to work around using "<>", but that doesn't seem to be the issue either.
Most of my searches only turn up results for filtering a single item. If I search for multiple, it references "multiple choice" columns, which isn't what I'm dealing with here.
I'm assuming my approach to this is probably wrong, so any guidance would be appreciated. If I knew this form would have this much complexity, I would have pursued alternate designs for these columns of data, but am just trying to make it work.
