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,269
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.9k
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 ...
- 47.3k
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.9k
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.9k
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 ...
- 47.3k
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,661
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.6k
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,837
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,990
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,706
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,269
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 ...
- 47.3k
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,121
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,925
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()?['...
- 3,057
1
vote
Multiple if statements to calculate numbers
See the formula and as screenshot showing test results below. I have used S1, S2, .. for the status column names and H1, H2.. for the Hour column names. You would need to replace them with your actual ...
- 3,057
1
vote
Accepted
Conditional formatting based on number of days to due date
Please try the below and let me know
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
&...
- 3,057
1
vote
Automate recreate list item with new date
This should get you on the right track. What you are looking for is the addDays expression.
adddays(items('Apply_to_each')?['DueDate'],366)
- 507
1
vote
Accepted
Display different flow buttons in sharepoint list with time condition
Try changing visibility property in last code block to:
"visibility": "=if([$Status] == 'Planned' && [$DateEnd] <= (@now - 900000), 'visible', 'hidden')"
OR
"...
- 47.3k
1
vote
JSON - Conditional Formatting - SharePoint - Not Null
Just change your code to this:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"debugMode": true,
"elmType": ...
- 5,231
1
vote
JSON - Conditional Formatting - SharePoint - Not Null
You need to add a style parameter to apply styling and this can be conditional, as you see below. In style or class I have made certain changes which should work for you
{
"$schema": "...
- 2,885
1
vote
Accepted
Sharepoint workflows: Is it possible to conditionally execute steps within a stage?
If you just want to collect multiple actions in a step and use this step in the same stage, you can insert a step named "Get Manager Approval" as below:
If you want to pre-define a step and reuse this ...
- 3,976
1
vote
Sharepoint workflows: Is it possible to conditionally execute steps within a stage?
You can only transition to a single stage, but if your example is correct you should be able to solve this by moving the condition to the end of the Get Manager Approval stage ?
Stage: Manager ...
- 2,249
1
vote
Accepted
SharePoint List column validation related to another item
You can achieve this using list Validation settings. use below formula:
=IF(OR([report type]="A",[report type]="AB"),IF(ISBLANK([Type A due date]),FALSE,TRUE),TRUE)
Calculated Field Formulas.
- 47.3k
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",
"...
- 47.3k
1
vote
How to filter SharePoint list column with username of the current user
You can't do that out of the box, but it would be rather easy to write a javascript to take the logged in user from the _spPageContextInfo object and use that as a filter. But if you want non-code ...
- 1,230
Only top scored, non community-wiki answers of a minimum length are eligible