
I have combo box drop down for "section" which has values from 1 to 9.
I have excel file where the these values are getting submitted.
*I am trying to remove(hide) the values in "section" drop down if its already there in "Rack" column. I tried using countrows and lookup value commands but no luck. Can you guys please guide me in this.
Thanks.
hi @man329 with your rack info as 2-3-5- consider adding this to the dropdown
Items = Filter(ForAll(Sections,If(Not(YourColumnValue in Split("2-3-5-","-")),YourColumnValue)),YourColumnValue <> Blank())
This is what will be returned
Hope this will help.