3
votes
Failed on Start (Workflow was canceled by System Account.)
In case it might be helpful for someone:
I had a similar problem with a client today in a SP 2013 environment, but in my case turned out that it was a .Net security update that caused it.
The ...
- 63
3
votes
Accepted
Sharepoint 2013 - issue with using java script to format columns
Add the following code into script editor web part in list view page.
<script type="text/javascript">
(function () {
// Create object that have the context information about the field ...
- 6,249
3
votes
Accepted
Power Apps change Image based on field value
You have to nest the If statements. What that does is, if the criteria for the first condition evaluates to false, instead of having a value for a false result, you have another If statement to ...
- 12.8k
2
votes
Conditional fields - basic IF validation
You can't do that with validations. All you can do is have a formula that returns true or false, as to whether that field is valid or not. You can't affect other fields.
If I had to do this, I would ...
- 999
2
votes
Accepted
Can conditional mandatory field be made in SharePoint forms?
There is no OOTB function which is handle your situation.
But you can have presaveaction function in sharepoint 2013, so you can check your condition using JavaScript in page and return false to this ...
- 2,223
2
votes
How to filter SharePoint list column with username of the current user
The List View filter value for the people or group field it takes [Me]. It works for Created By in your screenshot. If the PoC field is a text field there is no way you can pass the current user name.
...
- 4,979
2
votes
Conditional formatting in item view (display form) using CSR / JS / CSS - is it doable?
In SharePoint Online, you should be aware of the JavaScript/CSS customization is not allowed for the Modern Experience list and libraries. Meanwhile, it's allowed for Classic Experience.
In case, you ...
- 45.4k
2
votes
Accepted
Value of the Yes/No Column
Try Using:
=IF([Col1], 1, 0)
Or
=IF([Col1]=TRUE, 1, 0)
Return the calculated field as Number.
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something ...
- 46.4k
2
votes
Accepted
JSLink not modifying text
I would double check that "Location" is truly the internal name of the field. Sometimes the display name can change, and to register the CSR override you need to use the internal name.
The easiest ...
- 12.8k
2
votes
Conditional formatting on list SharePoint 2013
This article should help you out. Find the column on which you would like to customize and use this article to format it using JSON. You will see the JSON editor within the column's settings.
...
- 165
2
votes
Accepted
Conditional formatting on list SharePoint 2013
This sounds like it might be a situation where you can use Client Side Rendering.
If you are unfamiliar with CSR, I highly recommend reading this article to get an understanding of what you can do ...
- 12.8k
2
votes
Is it possible to dynamically refresh a calculated field on the Edit form when a connected field is changed?
Yes it is possible with infopath but you need to use text field and make the calculations using info-path functions. The build in calculated field will recalculate only when you submit the form. With ...
- 3,540
2
votes
Calculated Columns with Conditions
You can use VALUE function to convert text to number.
VALUE function Converts a text string that represents a number to a number.
Syntax:
VALUE(text)
text is the text enclosed in quotation marks or a ...
- 46.4k
2
votes
Accepted
How can i nest column validation in SharePoint
Here is the nested validation formula:
IF(
OR(
[Position]="Ground Support Equipment - Ramp Equipment Operator (GSE-REO)",
[Position]="Ramp Equipment Operator (REO)", [Position]="...
- 6,631
2
votes
Accepted
Use conditions in calculated column in sharepoint 2013
The following should work:
=IF(LEN(Column1)>0,IF(LEN(Column2)>0,IF(LEN(Column3)>0,"Approved",""),""),"")
- 14.5k
2
votes
Accepted
SharePoint Online - Conditional Formulas For Columns
As James said, a Validation Formula is intended to prevent the save of an item.
Two options for what you are describing:
Create a Calculated Column that "corrects" the cost. (Maybe name this column ...
- 6,827
2
votes
Accepted
How to check in a workflow 2010 condition if an element is exist or not?
follow the below steps:
Create a local workflow variable of type string, say dateAsString.
Use command Set workflow variable. In variable select the newly create i.e. dateAsString. In value select fx ...
- 2,980
2
votes
Using Nested OR/AND In Designer 2010 Workflow Conditions
You could add a stop workflow at the end of each set of actions so it won't further evaluate.
For example:
If A and B then Action 1 then Stop workflow
If B or C then Action 1 then Stop workflow
...
- 550
2
votes
Accepted
Conditional formatting for a row that contains any information
Try changing your code to this:
<script type="text/javascript">
SP.SOD.executeFunc("clienttemplates.js", "SPClientTemplates", function() {
SPClientTemplates.TemplateManager....
- 3,666
2
votes
Accepted
SharePoint JSON tileProps breaks formatting
This view formatting only works in the Tiles view.
The format expects the Title field
The format expects a text column with an internal name of Feedback
The format expects a person column with an ...
- 6,249
2
votes
Accepted
Sharepoint JSON conditional syntax help
You can use Number(DateTimeColumn) == 0 to check if the date column is blank or not. This is the major hint, rest you can build the JSON code around it according to your other conditions.
So, try ...
- 46.4k
2
votes
Accepted
How can I display a "View Comments" link on a list item only when comments exist?
Your format posted above is invalid. You must have an elmType and if you want to show a value you'll need to either provide it in txtContent or by adding children to your root element. For instance, ...
- 6,051
2
votes
Accepted
Conditional Calculated Date Column
According to my understanding of your question, you want to calculate the retention date based on different time intervals.
Please follow the steps:
1.Create the below columns in the list
[Completion ...
- 2,895
2
votes
Accepted
Power Automate Trigger Condition - "OR" 3 Choice Values
Maybe because you didn't put the comparing value for the 3rd equals()
Try this:
@or(
equals(triggerOutputs()?['body/Architecture_x0020_Review_x0020_1'], 'Request Approval'),
equals(triggerOutputs()?['...
- 2,742
1
vote
Accepted
SharePoint Column JSON formatting alignment
If you want the div with full width then try adding "width": "100%" to the style attribute, like:
{
"elmType": "div",
"txtContent": "=if([$FlowStatus] == 'Expired', 'Expired', @currentField",
"...
- 46.4k
1
vote
Is it possible require an attachment when a specific drop down option is selected?
You can add this code to your NewForm.aspx and EditForm.aspx to check the attachment table rows - this requires an attachment all the time - you can add in the code to only check it whenever a certain ...
- 2,071
1
vote
SPO Conditional Formatting - Color Column views
The JSLink script below for your reference:
(function () {
(window.jQuery || document.write('<script src="//ajax.aspnetcdn.com/ajax/jquery/jquery-1.10.0.min.js"><\/script>'));
var ...
- 6,249
1
vote
SPO Conditional Formatting - Color Column views
I had this problem before and after a lot of searching I learned that you can't modify multiline text fields style. You can use a single line text field instead but it will limit your comments to 255 ...
- 41
1
vote
Accepted
SharePoint Designer 2013 - And/Or priority in if statements
Try this:
If ContentType equals Apple and Color equals Red
or
ContentType equals Apple and Color equals Green
Log to history "Good fruit!"
If you have more IF statements, you can use ...
- 2,889
1
vote
Accepted
Condition: if value contains multiple strings
About a quarter of the way down this article I found the answer. It uses logical or (||) and logical and (&&)
Only top scored, non community-wiki answers of a minimum length are eligible