Hi!
I just made an app and I’m stuck, I dont want overlapping list. So, if an option has been selected by someone then the option that has been selected is blocked and the other person must select the remaining option. Anyone know how to do this?
this data column type is enum.
thanks in advance
Have a look at LIST() in the documentation and mull over this expression which could be in the Auto Compute section (Suggested Values) of your Enum field.
LIST("Monday","Tuesday","Wednesday","Thursday") - LIST(AlreadyChosen[Day])
Hope that gives you some pointers…
I think you are in need of expression which is going to be used in Valid If in table properties.
you can used intersect () function which gets similar or equal values in the list. then you can subtract it from the main list of days (monday, tuesday…etc).
select (tablename[column name] , [criteria] <> intersect ( list 1 , list 2))
case 2 if u have limited enum options then try this
list ( sunday , monday…) - intersect ([column name] , list ( sunday , monday…) )
intersect () function explain is in below link.