Forum Discussion
Conditionally show/hide column based on 2 conditions
I have a Sharepoint list column which i'm trying to show based on two conditions.
e.g. if Column A is 1 OR Column A is 2, show,hide
It works with the one condition but not two. I've tried in both SharePoint and editing the form in Power apps but neither work. Does anyone have an example formula?
Tom Hamilton=if([$Number] == 1 || [$Number]==2, true, false)
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
3 Replies
Tom Hamilton=if([$Number] == 1 || [$Number]==2, true, false)
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- Has this formula stopped working? I am getting syntax error.
RehmanR I think you got the answer for your issue that you have to use the formula functions in small letters (like if) instead of using capital letters (like IF).
Reference: Show/hide columns based on 2 conditions
Please consider giving a Like if my post helped you in any way.
