Questions tagged [if-condition]

The tag has no usage guidance.

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

Difference calculation in SharePoint list - Calculated column with condition

I am working on a leave approval request that calculates company offs too. As per my logic, the first comp off should get subtracted from 12 which is the total number of comp off for this year going ...
0
votes
2answers
47 views

Microsoft flow to trigger email when condition is met

I am working on a microsoft flow where it is supposed to trigger email when the fields of a sharepoint list item - If 'Mail to be sent to Maths' is 'Yes' and 'IsmailsentMaths' is 'No' then trigger ...
0
votes
1answer
49 views

triggering an email from MS flow when a particular field of sharepoint list item is modified

I am trying to build a flow to trigger a custom email sent once a SharePoint list item is created or modified, condition is to only send it if a choice value in a certain column is set to "YES&...
0
votes
1answer
19 views

SPD approval workflow one IF condition is not available

I'm an new for sharepoint. Recently I created an approval workflow with SPD. There are multiple filter condition in the worklfow to filter the application to use the right approval process. But when I ...
0
votes
1answer
27 views

Microsoft flow condition to trigger an email when a user selects Yes from a dropdown list in the sharepoint list item

I am building a microsoft flow to trigger an email when an item is created or modified.I have a field "Mail to be sent" which is a dropdown list - Yes/No in the sharepoint list. I want the mail to be ...
1
vote
1answer
25 views

Microsoft Flow: Why is my multiple condition not working

I am using modern SharePoint and have set my flow to trigger when an item is created or modified. Where I'm getting stuck is the conditioning as I have two conditions that need to be met: 1) The Y/N ...
0
votes
0answers
15 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
46 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
133 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
32 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
261 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
32 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
269 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
44 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 ...
1
vote
1answer
38 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
3k 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
252 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
45 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
344 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
153 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 ...