0

I have a Choice column that I want to display if either of two conditions are true.

It's an Approver Response column that I want to hide if "Approver Notified" checkbox = false, and Status = "Pending".

So far I have: =if([$ApproverNotified] == false, 'false', 'true').

How would I modify this to Hide if either Approver Notified = false OR Status = "Pending"?

Status is a Choice column.

Improve this question
1
  • Try: =if([$ApproverNotified] == false || [$Status] == 'Pending', 'false', 'true'). Let me know if it works for you. Commented Apr 18, 2024 at 12:13

1 Answer 1

Reset to default
0

If you are trying to use OR condition, try using formula like:

=if([$ApproverNotified] == false || [$Status] == 'Pending', 'false', 'true')

Where [$ApproverNotified] and [$Status] is an internal name of your columns in SharePoint list in this format: [$InternalNameOfColumn].

You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?.

Documentation: Show or hide columns in a SharePoint list or library form

Improve this answer
11
  • Thank you for the reply. This unfortunately didn't quite work - This made the column visible at all times. When a new doc set is created, power automate updates ApproverNotified to true. Once a response has been given (radio button), power automate then updates the Status column to Pending. Commented Apr 18, 2024 at 12:33
  • Can you explain conditions to show/hide column from list/library from once again? As per the question, column should be visible when either "ApproverNotified" checkbox (Yes/No column) is unchecked OR "Status" column is equal to "Pending". Is this understanding correct? Commented Apr 18, 2024 at 12:36
  • Sure thing - yeah it's kind of confusing. So this is when I want The Approver Response column (the column I'm giving this formula to) to HIDE: If ApproverNotified (Y/N) = false OR Status (Choice) = "Pending". Commented Apr 18, 2024 at 12:43
  • In that case, the formula provided above should work. Are you using correct internal names for columns? Status column is single selection or multiple selection choice column? Commented Apr 18, 2024 at 12:48
  • Yeah the logic in your formula seems like it should work...so I don't know what I'm doing wrong here. This is the formula I applied (with the actual column names): =if([$Approver1Notified] == false || [$RI_x0020_Decision] == 'Pending', 'false', 'true') . When I open a new Doc Set form, that field is displaying (RI Decision, or Status, is = "New", and Approver Notified = false. Commented Apr 18, 2024 at 12:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.