Questions tagged [conditional]
Questions related to conditional statements
82
questions
0
votes
2answers
23 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 ...
0
votes
1answer
39 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 (...
2
votes
1answer
29 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: [...
1
vote
2answers
56 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:
...
0
votes
1answer
15 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 ...
0
votes
1answer
23 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]) == '', '' , ...
0
votes
1answer
45 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 ...
0
votes
1answer
19 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
vote
2answers
28 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 ...
2
votes
1answer
41 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 ...
1
vote
1answer
24 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. ...
0
votes
0answers
11 views
Conditionally formatting (hiding or revealing) rows in a custom form in SharePoint Designer 2010
I am trying to conditionally reveal/hide rows in a custom edit form in SharePoint Designer 2010. I am using xsl's starts-with test, but I am not managing to have it work. It only hides the row, even ...
0
votes
2answers
13 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 ...
0
votes
1answer
983 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
2answers
1k 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 ...
0
votes
1answer
72 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, ...
0
votes
1answer
162 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 ...
0
votes
1answer
36 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 = {};
...
1
vote
2answers
599 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 ...
1
vote
1answer
13 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
1answer
741 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 ...
0
votes
1answer
310 views
Calculated Columns with Conditions
I have found plenty of posts that mentioned how to add multiple conditions to calculated column but my formula is not working. The action is pretty simple that is why I feel like silly that it has ...
0
votes
0answers
25 views
If any value equals any value condition doesn't accept two words
I am creating a workflow in SharePoint Designer and am using the "If any value equals any value" condition.
I want to check if the current item is in a particular folder. The folder has two words to ...
1
vote
1answer
284 views
SharePoint Designer 2013 - And/Or priority in if statements
Using SharePoint Designer 2013, I'm actually doing some if statements in a workflow with or and and in the condition. But I'm confused as what priority is given for these...
Is the and joining the ...
0
votes
2answers
726 views
Condition: if value contains multiple strings
I'm not too great at the string builder or lookup fx's.
I'm dealing with folders and want an approval process to go to User A if the folder is named "ABC" or "DEF".
I'm using the condition: if any ...
1
vote
2answers
824 views
PowerApps Conditional formatting
Looking for advice on how to implement a conditional formatting based on several factors. I'm still working on my Raw Materials Inspection app:
We have 2 factors to consider: Probation and Time.
If ...
0
votes
1answer
4k views
PowerApps: Compound IF statement?
On my screen I have two fields called InspectionDueFreq and InspectionDueProb.
The former represents the frequency of inspections (in days). If, for example, a part is to be inspected every 30 days ...
1
vote
1answer
418 views
Powershell “Canot index into a null aray”
I have a powershell script which works but at the same time it throws this error.
Cannot index into a null array.
At D:\PowerShell\Items\Update_a_Field.ps1:10 char:69
+ if($list.BaseType -eq "...
1
vote
1answer
340 views
Sharepoint 2013 - Conditional validation on mutiple choice lookup column
Scenario:
Sharepoint form created in infopath with multiple views. One multiple choice lookup column needs to be "Cannot be blank" for only one of the views.
I have removed the ribbon save button and ...
1
vote
0answers
27 views
Multiple values in list
I am using SharePoint from Office365.
Two lists are given:
List 1:
1 | Person1
2 | Person2
3 | Person3
...
List 2:
1 | Activity1 | Person1;Person3
2 | Activity2 | Person2
3 | Activity3 | Person1;...
1
vote
1answer
225 views
Sharepoint 2013 - issue with using java script to format columns
I found a few tutorials to do this, many of them point to using the jslink or content editor. I tried following the instructions in this site: CSR code samples #1 (Task Priority color) but it's not ...
0
votes
1answer
33 views
How can i nest column validation in SharePoint
How can I nest column validation
=IF(OR(
[Position]="Ground Support Equipment - Ramp Equipment Operator (GSE-REO)",
[Position]="Ramp Equipment Operator (REO)",
[Position]="Cargo Checker",
...
1
vote
1answer
2k views
Birthday & Anniversary Webpart (Slider)
I would like to create an share point web part (slider) on wiki page to display today's birthday and anniversaries with picture and description (like Date of birth, name, year in company etc).
Since,...
2
votes
1answer
37 views
Use conditions in calculated column in sharepoint 2013
I want to make a formula in my calculated column in this meaning please:
if (Column1 !=null && Column2 !=null && Column3 !=null)
Display Approved else let it empty
1
vote
2answers
188 views
SharePoint Online - Conditional Formulas For Columns
I've finally convinced management to let me build some decent apps with SharePoint Online. I am trying out the stock issue tracker and I have a question about Column Validation.
We have a column ...
0
votes
0answers
24 views
Conditaionl Formating of row when field is not displayed
Seems simple, but I cant figure it out. I want to highlight a row based on text being entered in a field, but the field is NOT displayed.
It shows up the way I want if the field is showing up in the ...
0
votes
1answer
228 views
Sharepoint Conditional Formatting or Add Flag?
OK, so I'm trying to basically add an indicator of any kind in one field based on another field having data entered v no data entered. Ideally would like to display a red flag, or some kind of icon, ...
1
vote
2answers
2k views
SPO Conditional Formatting - Color Column views
I have 2 columns namely:
"Status", Choice column with Red,Yellow,Green as values
"Comment", Multiple Lines of text column
Now, I want to set the background of "Comment" column using the color ...
2
votes
1answer
106 views
How to check in a workflow 2010 condition if an element is exist or not?
The users can create items in a custom list. One element of the item is the "date of warning". If the user add a date he/she ll recive an e-mail on that date if the "status" is not "finished" yet. The ...
2
votes
1answer
1k views
Using Nested OR/AND In Designer 2010 Workflow Conditions
A series of actions in an SPD 2010 workflow I'm working in needs to run when quite a few conditions, arranged in an "If this AND that are true, OR if something AND another thing are true, OR (etc)" ...
1
vote
0answers
59 views
Conditionally Filtered Autocomplete Script based on another Column in a Form (SPO)
I am using the script below to autopopulate a text column called 'RelatedPeople' (Both Internal and External Column Name). The script pulls from the 'Title' Column of the 'People' List. I was ...
0
votes
1answer
19 views
Conditional formatting for email lists?
I am new to SharePoint coding and am wondering if there is any type of conditional formatting which will allow there to be an email sent to a specific group when a certain drop-down is selected. For ...
1
vote
1answer
874 views
Is it possible require an attachment when a specific drop down option is selected?
I have created a SharePoint list that automatically sends an email upon submission of a list item. One of the features I've added is a flag indicator '[*]' at the beginning of the email subject line ...
0
votes
2answers
1k views
Conditional formatting in item view (display form) using CSR / JS / CSS - is it doable?
Is it possible to apply conditional formatting to an item view [Display-Form] just like in the list?
I use SharePoint Online, Cisar and SharePoint extensions for Chrome.
0
votes
2answers
94 views
Sending multiple emails (possibly any multiple steps?) inside an if block
Trying to send two emails to two different groups once a certain test passes. If emails should be sent, send to group one - if a second test passes, send to second group.
I have it set up like so:
...
0
votes
1answer
261 views
Is it possible to apply condition on Choice column in SharePoint Library?
There is one library having choice column as(Morning/Afternoon/Night).
So requirement is that
Allow user to choose morning only in morning time frame only. same for other Afternoon/Night.
So how can ...
3
votes
1answer
83 views
Conditional Formatting for UK (non-US) dates in custom list
I work in a compliance office and I convinced my boss to start using SharePoint services and part of my job is to build a compliance tracker with dates etc.
I found a good solution here and after ...
1
vote
1answer
1k views
SharePoint Conditional Formatting Date Column
I've been trying to create a Conditional Color column for dates that are expired.
The expired dates should be red and the dates that are not should be clear.
I tried to use the code from http://www....
1
vote
2answers
26k views
How to filter SharePoint list column with username of the current user
I need to pass the current user name in the filter for Contains condition - Whenever passing [Me] it gives error: Filter value is not a valid text string.
2
votes
1answer
3k views
InfoPath form: How to display value in a text box based on selection in previous drop down field
I have a form with a field in it called TypeOfCare. users can select five values from this menu:
'Residential'
'Residential EMI'
'Nursing'
'Nursing EMI'
'Care At Home'
Depending on what user ...
