Skip to main content

Hi, 

 

I have a form with 4 panels with the following purposes;

 

1: New form panel

2: Edit form panel (when property of a dropdown field (User Status) is Active)

3: Edit from panel (when property of a dropdown field (User Status) is Inactive)

4: Display form panel

 

For panels 2 & 3, when the form is in edit mode, either 2 or 3 should display based on the selection of a 2 option dropdown (User Status), populated on new form.

 

I can progress the visibility of the panels on the simple mode logic;

 

1: not(Is New Mode) with hide ticked on formatting rule

2: not(Is Edit Mode) with hide ticked on formatting rule

3: not(Is Edit Mode) with hide ticked on formatting rule

4: not(Is Display Mode) with hide ticked on formatting rule

 

What I cannot progress is the logic to show either of the edit panels (2 or 3) based on the dropdown selection made on new form mode.

 

A few rule approaches which have not worked;

 

  • not(Is Edit Mode) && (User Status!='Active'||User Status!='**SelectValue**')
  • not(Is Edit Mode) && (User Status=='Active'||User Status=='**SelectValue**')
  • and(not(Is Edit Mode), not(equals(User Status, 'Inactive')))

 

Can anyone suggest what I can do to display the correct Edit panel based on the dropdown property?

 

 

Thanks in advance.

Use contains() instead ==


Does the below logic satisfy your requirement :

If User Status == Active or User Status == null , then hide the Inactive Panel

If User Status == Inactive , then hide the Active Panel .

If this is what you are trying to achieve then follow the below steps :

1. Rule 1 (It will apply to both the edit panel ) :

      not(Is Edit Mode)

2. Rule 2 ( Apply this to the Active Panel )

Is Edit Mode && ({ItemProperty:User_x0020_Status}== 'Inactive')

2. Rule 2 ( Apply this to the Inactive Panel )

Is Edit Mode && (({ItemProperty:User_x0020_Status} == 'Active') || (isNullOrEmpty({ItemProperty:User_x0020_Status})))


Saud,  

Thank you for taking the time to submit the detailed response.


I can confirm your advice resolved my situation, and I am very grateful.


I am glad to hear that.

Can you please mark it as the correct answer.


Reply