Hi all,
Could someone please advise how it would be possible to achieve such a scenario?
1. In the combo box which allows multiple selections, the user selects items A and B;
2. IF condition in the other fields recognizes that the selected items includes selected item B.
My current IF function looks like this:
IF(User().Email = Test.Selected.Email && LookUp(DocumentTypes.SelectedItems,Text(Value) = "B"), true, false)
the following error is shown here: Invalid argument type. Expected Boolean, Number, Text, OptionSetValue.
Also tried the function below, but get the error of invalid argument
If(User().Email = Test.Selected.Email && DocumentTypes.SelectedItems.Value = "B"
Many thanks!
Solved! Go to Solution.
Consider this:
If(User().Email = Test.Selected.Email && "B" in DocumentTypes.SelectedItems.Value ,true,false)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Consider this:
If(User().Email = Test.Selected.Email && "B" in DocumentTypes.SelectedItems.Value ,true,false)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Noted. Thank you very much!
User | Count |
---|---|
253 | |
122 | |
106 | |
54 | |
48 |