Questions tagged [conditional]
Questions related to conditional statements
120 questions
0
votes
0
answers
15
views
Automatic color scale conditional formatting for a column
I want to apply conditional formatting to a date column in a SharePoint list, similar to the color scale feature in Excel.
The formatting should automatically assign colors (e.g., shades of green) ...
- 113
0
votes
1
answer
21
views
Conditional Formatting Not applying
I have a choice column "Program" which includes four options. If option A is chosen then I need Office Location (choice column) to populate. However, when I do conditional formatting, it is ...
- 1
0
votes
0
answers
19
views
Lists default input form
I have added conditional formulas to my lists input form to hide fields on new input and it works great for my view. However when another user opens the form their view is without the customisation. ...
- 1
1
vote
1
answer
32
views
SP2019: Color Col-A value if Col-A value changes AND Modified By email equals one of four emails
In a SP2019 List, I need the [Status] column value background-color to be Amber based on two conditions:
1.) if the [Status] value changes AND
2.) if the [Modified By] email address equals one of four ...
- 167
0
votes
1
answer
263
views
Sharepoint JSON if else conditional on txtContent
I am trying to display different text in a multiline text field depending on the value in a separate single line text field. I can get the if statement to work with one condition but if I try to nest ...
- 25
0
votes
1
answer
503
views
Power Automate Trigger Condition - "OR" 3 Choice Values
I have a flow that I'm trying to set a trigger condition on. I'm trying to trigger this flow if an item is modified, and if any of three Choice fields = "Request Approval". This is what I'...
- 507
1
vote
1
answer
1k
views
Flow-How to use a string variable in Condition Expression?
I have a dynamic logic string: 1 and (2 or 3)
and conditions:
Region equals Japan
Owner equals Jim
Owner equals Mary
Because the conditions and the logic string are dynamic, I'm using Power Automate ...
- 11
0
votes
1
answer
19
views
Conditional formula to show/hide a column based on if two dates cross over a fiscal year
I don't know if it possible to do this in the base sharepoint form builder, but I am trying to get a column to show up if 2 supplied dates cross over the end of the fiscal year. I don't want to hard ...
- 1
0
votes
1
answer
30
views
Can you apply conditional formatting to a single word in a SharePoint Online List view
Is there JSON coding in Advanced mode (SharePoint Online) that will limit the field formatting to a single word and not the whole row?
The below code will make the whole row have red text, but I would ...
- 1
0
votes
1
answer
81
views
Trigger conditions to start approval process or notify on rejction
I have a SharePoint list with the following columns:
Approval Status
Sign-Off
The scenario is this:
The end-user is assigned a task. The end-user completed the task and right clicks, goes to the ...
1
vote
1
answer
570
views
SharePoint List column conditional formatting
New to this still on the learning road.
Situation. I have a SharePoint list that contains the following columns:
Name, DOB, Location, Comments.
I need to use a conditional formatting rule that in the ...
- 13
0
votes
1
answer
303
views
Modern/Online SharePoint Choice field not allowing update of choices
I was unable to update a choice field for a list in modern SharePoint (online). In addition to the bigger problem described below in the table (for anyone interested), I could not change the name of ...
- 13
1
vote
0
answers
153
views
PowerApps - Two Lookup Columns Issue
I have a canvas app connected to a SharePoint list that contains 2 Lookup columns: Name and Code. There are about 600 line items. In the app I have these two fields side by side, and basically want ...
- 507
0
votes
1
answer
11k
views
Power Automate flow to send a reminder if Due Date is passed
I'm working on a Power Automate flow based on a SharePoint list. I have a Date column (Due Date) and a Choice column (Status) that I need this flow to look at. Basically what i'm tryign to ...
- 507
1
vote
1
answer
217
views
MS List Conditional Formatting JSON with SharePoint 365
I've reviewed a lot of threads and none seem to quite fit my fact pattern.
I'm using the Modern MS Lists, in Office 365 Online.
We have a list of contracts that we want to color code rows based on ...
- 13