Questions tagged [if-condition]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

Designer Workflow Condition Triggered by Designer File Name

I am creating a form that has 7 different versions of a new form. For the purpose of this question, my example would be something like NewDoc.aspx, NewForm.aspx, and NewRequest.aspx. The purpose for ...
0
votes
2answers
33 views

If and else if in sharepoint list calculated column giving syntax error

I have two date fields date1, date2 and stores in column name result . I need the difference of the two dates to be calculated and store no of days in the result. Problem here is with two cases: ...
0
votes
1answer
29 views

Use PowerApps If command to manage the text of a label

I'm trying to achieve something easy but I'm new to PowerApps and is way different than InfoPath. I want to configure a text label to show different text based of values of other field. For Example: ...
0
votes
1answer
22 views

How can I make a field visible depending on the content of another field?

I have a PowerApp which is working really well so far, it is based on a SharePoint list which holds the data. There is a date field (Paid Date) which defaults to 31/12/2001 for some reason, and I want ...
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 ...
2
votes
2answers
70 views

How to utilize “if” condition in a link using JSON column formatting in SharePoint?

I am trying to remove all of "AAA" links from a link column called "LinkList" using JSON column formatting. "AAA" is a link not text. I am in trouble to hide all of this kind of cells in that column. ...
0
votes
1answer
29 views

How to create a “Check if” function on SharePoint Designer?

I am working on a delegation workflow for approvals. Is there a 'check if' function on SharePoint for separate lists? For Example: Check if [ListA_Manager] matches/equal [ListB_Absent Staff] I ...
1
vote
0answers
195 views

SharePoint Column Conditional Formatting - Applying CSS classes to a date field using a nested IF statement

Apologies, I am relatively new to SharePoint/JSON, So forgive me if I am not seeing the obvious. I would be INCREDIBLY grateful if someone would help. I would like to apply conditional formatting to ...
1
vote
1answer
43 views

If Statement Giving Wrong Output Issue Calculated Column

I have this simple if statement where there are two columns. Column 1 = Score Column 2 = Test This is the If Statement Code: =IF([Score]>70,"A","F") If the score is greater than 70 it should ...
0
votes
0answers
17 views

Designer 2010 workflow to send multiple, different emails sends only the last email

I have a custom SharePoint 2010 workflow. (It is not a task or approval workflow.) I want it to send different emails to up to 13 organizational departments when they have been selected in a list's ...
1
vote
1answer
36 views

Sharepoint designer workflow 2013: send 7 different email notifications based on a field in item

Based on a list with approval. Conditions for workflow to fire the email is that item must be Approved and according to a choice value in the item (a, b, c, d ...) there is a different email to send. ...
0
votes
1answer
2k views

How to utilize if/else condition for JSON column formatting in SharePoint?

I am trying to format the color of a column based on the selection of another column in the same View. But, I am having trouble writing the JSON to check for multiple values in the other column. Here ...
1
vote
1answer
194 views

Microsoft Flow : Why is my condition to a column with Yes/No value is not working in if expression

Here is my expression which I want to incorporate in sending email action in flow: if(PM/SH Approval Status=TRUE,"Attending","Not Attending")
0
votes
2answers
38 views

Calculated Formula for Finding three diferent results

I am working on a calculated formula based on my [Tracking Number] column to get the following results: Find "Andrews" return the result "ANDREWS". Find "Bolling" return the result "BOLLING". ...
1
vote
1answer
157 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 "...
3
votes
1answer
24 views

Mutliple Workflos nsted for an Item?

I am currently stuck. I have a form library with multiple days equaling different values. All the columns that I'm using are extracting information from the submitted form. I'm trying to have an ...
2
votes
1answer
106 views

Using IF condition to send email in sharepoint designer workflow

I have created a ticket booking form. I'm using "FORM_STATUS" field to trigger the workflow. Once the form is saved it has "FORM_STATUS" = Blank hence the workflow doesn't get triggered. The main ...