Hi,
Iโm trying to show a column based on what value user selected in a Enum List (shopCategory). I tired putting the show if of the column as [shopCategory] = โSelected Optionโ but Iโm getting the following error:
Cannot compare List with Text in ([shopCategory] = โSelected Optionโ)
Solved! Go to Solution.
Thank you. Could you please try in show if following
IN(โOption Aโ, [ShopCatgeory])
Do you wish toshow that column based on any specific value in enumlist column [ShopCategory] or for any and all categories in the enumlist column, meaning when it is non-blank?
Enumlist as the name suggests will select more than one option.
For specific values, e.g, if user selected โOption Aโ from EnumList, I want to display a column relevant to that specific selected option.
Thank you. Could you please try in show if following
IN(โOption Aโ, [ShopCatgeory])
@Suvrutt_Gurjar Thanks.
And I assume there is a different expression for ENUM?
Nvm, I figured it out. Itโs as simple as [shopCategory] = โOption Selectedโ
Correct. Since Enum returns a single value always , one can simply compare with that value such as [ShopCategory]=โOption Aโ
Enumlist returns a list, so we need the list based compare expression.
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |