I have a Canvas app with a combo box drop down that's fed by a SP List "choices" column. I want to filter out one item from the list, to prevent it from being displayed.
This is not a gallery, just a combo box in a form. I'm having trouble figuring out the formula to just hide this one value out of about 13 or so entries in the column.
This won't be conditional in this circumstance. We just need to create the new value now without it being available to select/view in this app and then it will be displayed in a future date. Another app uses this same SP List column as a data source and needs the value added there, where it will be displayed.
I'm convinced I'm overthinking this and missing a simple method, but all the information I look up is related to galleries and doesn't seem to apply to this circumstance.
The "choices" column is for only selecting one value (not multiple) and again, I only want to filter one specific value from the entire "choices" column.
Filter(Choices('MyChoice2 (TableAS)'), Value <> 'MyChoice2 (TableAS)'.'1')
You can also And more together
Filter(Choices('MyChoice2 (TableAS)'), Value <> 'MyChoice2 (TableAS)'.'1' And Value <> 'MyChoice2 (TableAS)'.'2')
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
6
Share
Report
All responses (
Answers (
