Questions tagged [conditional]
Questions related to conditional statements
111
questions
0
votes
1
answer
14
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 ...
- 1
1
vote
0
answers
37
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 ...
- 371
0
votes
1
answer
3k
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 ...
- 371
0
votes
0
answers
183
views
Using JSON AST to conditional format columns
I'm trying to make a sharepoint page for a company as user friendly as possible. Now I'm new to JSON and I just get the hang of it. The problem is that the sharepoint only works with JSON AST, which ...
- 101
0
votes
0
answers
77
views
Conditional Formatting IF/THEN in SharePoint Online
I need to set a field from another field.
If ""Response" is not blank then set "Has Response" to Yes"
Response is a rich text box. Has Response is a yes/no.
The "...
- 65
0
votes
1
answer
107
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 ...
- 3
0
votes
1
answer
602
views
How to write multiple conditional formula (39 conditions) for 7 columns in Sharepoint
first, I must thank you all for the tips for new people who want to learn more on SharePoint to optimize their business.
I'm trying to find a solution to write expanded conditional formula according ...
0
votes
2
answers
3k
views
Set value of column based on value of choice column - SP Modern List
I have a list in which the Project Manager column (text) needs to auto-populate based on the Project Name (choice) column. Essentially there are a small group of project managers, each assigned to a ...
- 371
2
votes
2
answers
2k
views
Power Apps change Image based on field value
I have built a weather app in Power Apps. I'm using the MSN weather connector to gather several basic criteria, namely "Precipitation". So I have several images I'd like to use for sunny, ...
- 371
1
vote
0
answers
172
views
Show/hide a column based on a selection from another column
I'm trying to format my SharePoint form to show/hide a column based on a selection from another column. If 'Other' is chosen from a column named 'Communication support', I'd like a free text column '...
- 41
0
votes
1
answer
52
views
Show/hide not working for choice fields if conditioned by calculated fields
In Sharepoint Online, in the New Item form I have a couple of choice fields that should be shown/hidden depending on the values of other fields.
If these fields are text fields, the conditions work ...
0
votes
1
answer
962
views
Conditional Item Display based on Tab Selection in PowerApp Gallery
Per this brilliant instructional video https://www.youtube.com/watch?v=1o2L0DADzKQ by Reza Dorrani I created collection colTabs to display different SharePoint List items in a PowerApps gallery. The ...
- 41
0
votes
1
answer
138
views
Conditional Duration Column in SharePoint Online
We have a SPO list with a metadata column named Status of type choice that contains the following values:
Opened
Closed
Re-opened
We want to create another column called Case Duration that will ...
0
votes
1
answer
235
views
Condition based on today's date in calcualted field
I have a calculated column inside a solution Table in Power Automate
but I need the condition to be check with a value now() - the current date, not a hardcoded value like this. However when I try to ...
- 11
0
votes
1
answer
35
views
hide a specific Sharepoint form field if the user is not the creator of the record
I would like to hide a specific Sharepoint form field if the user is not the creator of the record.
I'm trying to use conditional formatting without success.
Some one can help me?
Thank in advance
1
vote
1
answer
86
views
Conditional Calculated Date Column
I currently have a calculated column [Retention Date] that is only based on one value, the completion date.
This is for certain certificates so I can use them for styling in my DataTable. The issue ...
- 113
0
votes
1
answer
2k
views
Trigger condition when DateTime field is null
I have a flow that triggers on When an item or a file is modified in a document library.
To stop it re-triggering when the item is updated, I'm checking that a DateTime field called FlowModified isn't ...
- 103
1
vote
1
answer
618
views
JSON Failure: not found on the data object for SharePoint Online column formatting
I can't get SharePoint Online to recognize my field name. I know I could use @currentfield where I have [$2021_Q3] but I want to create a more complex formula and can't even get this basic one to ...
0
votes
1
answer
43
views
how to make sharpoint list fields visible for certain users
I have set up a sharepoint list I maintain myself with my manager.
There is a subset of fields that are needed to see and updated by the team.
For that I created a new view that only displays the ...
- 1
2
votes
1
answer
3k
views
How can I display a "View Comments" link on a list item only when comments exist?
My SharePoint list has a column for comments. It used to display a link to "View Comments" for every list item, though, even if there were no comments. Not helpful, since a user would have ...
- 136
1
vote
1
answer
398
views
Conditional format based on Time Range in Sharepoint list
is there a way to conditional format based on the time range or time value? i have a SPO list where employees have a daily task that is due at 5pm everyday. i wanted to conditional format the column ...
- 11
1
vote
1
answer
401
views
CONDITIONAL FORMATTING - Unable to format column
I have a SharePoint LIST that's being used to manage events. There are 6 participants for each event and each Participant has a column:
"Participant 1", "Participant 2", "...
- 33
0
votes
1
answer
223
views
Conditional Formatting with date comparison
I am using SharePoint 2016 on Premise in the classic mode.
I have a Custom List, and I want to apply conditional formatting to a date column, so that if the date is overdue from today's date it will ...
- 127
0
votes
1
answer
3k
views
How to hide a SharePoint list column if its own value is empty?
Is there a way with SharePoint online lists, to hide a column if the user did not fill in a value for it? If so, how can I setup this conditional logic for the column to check against itself?
I have ...
- 1,339
0
votes
1
answer
318
views
How to set up limited, web-only access for unmanaged devices BUT grant saving/printing for external shared files?
Community,
I need some help with different access controls for unmanaged devices in my company.
Users inside the company having limited, web-only access to SPO sites and content, if they are using ...
0
votes
1
answer
3k
views
JSON Sharepoint Calculated Columns
First time coding with JSON and need a little help...... I am attempting to make a calculated column with conditional formatting. So far i can get it to work but only partially. What i want is to have ...
0
votes
1
answer
134
views
SP2013: Disable text or number field once populated
I am looking for a jQuery script to conditionally disable two field types:
Disable a text field if it is not blank and
Disable a number field once it is non zero.
I see many posts on disabling ...
- 103
0
votes
1
answer
10k
views
Conditional table cell background color depending on value
I have a HTML table that I'm trying to change the cell background color to red depending on the value of the cell. Each cell will have a different threshold for when red is needed (one cell might be &...
0
votes
1
answer
29
views
Multiple if statements to calculate numbers
Need to calculate numbers from columns when status changes in other columns. Column one has the number of hour assigned for shift 1. Column two has status of completion, this repeats for 10 shifts. ...
- 1
1
vote
1
answer
6k
views
Conditional formatting based on number of days to due date
In SharePoint 0365, in the modern experience, I have a list of
contracts that have an expiration date.
I would like to use conditional formatting to create a status
column that shows me the contract ...
- 13
0
votes
2
answers
1k
views
How to make a conditional question in Sharepoint List/PowerApps?
I have a SharePoint List that I have customized with PowerApps. It has 3 questions that need to be answered only if the question before the 3 questions was answered.
So if the applicant gets to the ...
- 1
0
votes
1
answer
170
views
Automate recreate list item with new date
Wondering if someone can provide some input on this -- I am a super-novice to Microsoft Flow so was not able to find a way to accomplish, but I believe this is technically feasible.
I have a SP (...
- 1
2
votes
1
answer
780
views
Display different flow buttons in sharepoint list with time condition
I have a list where an item can have different statuses (Draft, Planned, Updated and finished)
I wanted 3 different flows to be able to run, so the buttons are:
When Draft: [Send item]
When Updated: [...
- 23
1
vote
2
answers
2k
views
JSON - Conditional Formatting - SharePoint - Not Null
New to JSON. Trying to write JSON when ever a free form text field is filled out, have this but don't know how to get it to highlight when anything is entered. I do not want highlights on blank items:
...
- 11
0
votes
1
answer
113
views
Sharepoint survey- drive questions from answers to earlier rating question
I have a survey of a product portfolio. The first question is the rating question covering all products in the portfolio. I then want subsequent question section for each of the product that had a ...
- 101
1
vote
1
answer
139
views
Sharepoint JSON conditional syntax help
I am trying to make the text say Expired or Current compared to a date column OR stay blank if the date column is blank. So far, I have:
"txtContent": "=if([$ExpiryDate]) == '', '' , ...
- 32
0
votes
1
answer
408
views
JSON Sharepoint - validating dates across several columns with boolean column
I'm beginner/intermediate when it comes to SharePoint JSON, and I've been trying all sorts of conditional logic to make an empty column txtContent show 'Yes' or 'No'.
There are 7 columns (all date ...
- 32
0
votes
1
answer
30
views
Lookup doc library column showing options based on List other column's value
I am currently setting up a document management system in our SP Online system. A column of the Doc Library is called "Project Name". I created a List ("Project List") containing the Project Name ...
- 1
1
vote
2
answers
47
views
Sharepoint workflows: Is it possible to conditionally execute steps within a stage?
EXAMPLE:
Stage: Get Approval
if (CurrentItem:Amount) < 100) then
Get Manager Approval
else
Get Manager Approval
Get Finance Approval
Q: Is it possible to make "Get Manager ...
- 117
2
votes
1
answer
61
views
SharePoint List column validation related to another item
I have a SP list with 3 fields:
"report type" (choose list "A", "B" or "AB")
"Type A due date"
"Type B due date".
I want to set-up column validation for the due date so that "Type A due date" is ...
- 33
1
vote
1
answer
36
views
Conditional formatting for a row that contains any information
I have a list that I am using for a library check out. When a person populates the check out date field I want my row to be grayed out. The condition would be if a field contains "any" information. ...
- 53
0
votes
2
answers
15
views
Can't get conditional syntax correct
Have [Tier] column with choice values of 0,1,2,3.
If [Tier] = 0 calculated column should = 0
If [Tier] = 1 calculated column should = 4
If [Tier] = 2 calculated column should = 24
If [Tier] = 3 ...
- 1
0
votes
1
answer
2k
views
SharePoint JSON tileProps breaks formatting
I am attempting to troubleshoot a formatting issue with JSON and actually found a Microsoft example that has the same problem for me. I developed a list using the same column names as the code below:
...
2
votes
2
answers
9k
views
SharePoint Column JSON formatting alignment
As mentioned in the Title I have some issues with trying to align my background color formatting as shown in the screenshot below:
What I hope to do is to get the BACKGROUND COLOR to align WITHOUT ...
- 25
0
votes
1
answer
1k
views
Value of the Yes/No Column
What is the values of the Yes/No Column in SharePoint?
1, 0
Yes, No
"Yes", "No"
True, False
Trying to use calculations:
=IF([Col1]=Yes, 1, 0)
So if it's true, put 1, else 2.
But not matter what, ...
- 307
0
votes
1
answer
943
views
Powershell script to update list column from another column Conditional
Any help is greatly appreciated. Here is the scenario:
I have a powershell script which I am using from another post on stackexchange.
I have two fields in a list, the script copies the value from ...
- 3
0
votes
1
answer
45
views
JSLink not modifying text
I am trying to get a super simple JS script to work on my SharePoint. I found this example here. This is what I am working with:
(function () {
var statusFieldCtx = {};
statusFieldCtx.Templates = {};
...
- 139
1
vote
2
answers
1k
views
Conditional formatting on list SharePoint 2013
I work for an organization that has crippled much of the functionality when using SharePoint 2013. Furthermore, I am still rather new to SharePoint.
I am seeking a way to apply conditional formatting ...
- 139
1
vote
1
answer
16
views
How do I create columns that evaluate other columns cumulatively?
Im very new to SharePoint as a whole so please bear with me.
Currently I am trying to create a checklist on SharePoint 2013 which features about 30 or so odd questions, each to be answered with Yes/...
0
votes
1
answer
2k
views
Is it possible to dynamically refresh a calculated field on the Edit form when a connected field is changed?
On the Edit form, I am trying to dynamically have a calculated field show updated values when the connected field is changed. The idea is to give the user more details on the selected week. Is this ...
- 437