SOLVED

Conditionally show/hide column based on 2 conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-3070004%22%20slang%3D%22en-US%22%3EConditionally%20show%2Fhide%20column%20based%20on%202%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3070004%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Sharepoint%20list%20column%20which%20i'm%20trying%20to%20show%20based%20on%20two%20conditions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ee.g.%20if%20Column%20A%20is%201%20OR%20Column%20A%20is%202%2C%20show%2Chide%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20works%20with%20the%20one%20condition%20but%20not%20two.%20I've%20tried%20in%20both%20SharePoint%20and%20editing%20the%20form%20in%20Power%20apps%20but%20neither%20work.%20Does%20anyone%20have%20an%20example%20formula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3070004%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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?

3 Replies
best response confirmed by Tom Hamilton (Occasional Contributor)
Solution

@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).

ReferenceShow/hide columns based on 2 conditions 


Please consider giving a Like if my post helped you in any way.