Questions tagged [if-condition]
The if-condition tag has no usage guidance.
30 questions
0
votes
1
answer
98
views
Power Automate Deleting All Tasks
I have a SharePoint List that handles critical notifications. I have a Power Automate flow set up to notify via e-mail when a new task is added but now I would like to create an automation to delete ...
0
votes
0
answers
58
views
Conditionally show/hide field based on content of field in EXTENDED lookup column
Problem: I want to show/hide a field based on the content of a field in an EXTENDED lookup column.
I have the following two lists:
LIST 1: "*Opgaver*"
COLUMN: "*Opgave*"
COLUMN: &...
- 101
0
votes
1
answer
124
views
JSON formatting: using sharepoint list item into email body
I'm trying to include a list item in combination with plain text inside my email body. The body includes multiple if conditions to generate language dependent text. But I keep getting code back for my ...
1
vote
0
answers
105
views
How to create power automate flow where multi select question from MS Form is null/blank
I have an issue with my power automate flow, where I need to feed data from a MS form with mult select answers and feed it into a sharepoint list.
The null is working, when I don't select any of the ...
- 11
0
votes
1
answer
277
views
Power Automate Reminder Flow for SharePoint Library
I have a SharePoint Online Document Library that I'd like to send a reminder email 7 days after a file is uploaded. How can I set the flow to look at the 'Created' date, add 7 days, then send an ...
- 445
0
votes
1
answer
580
views
PowerApps - Hide fields from user who created the entry
I have a PowerApps form connected to a SharePoint list. In my form I'd like to have a bunch of fields that are visible to all, except the User who created the entry. I only want that user to see a ...
- 445
1
vote
2
answers
860
views
Multiple IFs and ORs
I'm new to SharePoint lists and prefer not to work with them, but my employer has decided to utilize it. The process/formula I have in excel works, but not in SharePoint lists.
We need a Calculated ...
- 13
0
votes
1
answer
1k
views
Create Flow condition: If column "End_date" is less than 7days from column "Start_Date", then
I have two "Date & Time" type columns:
Start_date
and
End_date
I would like to create a manual triggered Flow (already have button writen in JSON in place) that compares them and:
if ...
- 23
0
votes
1
answer
6k
views
Triggering an email from MS flow when a particular field of sharepoint list item is modified - Check below condition?
Original question:
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 ...
- 1
0
votes
1
answer
375
views
Count-if column between two list in SharePoint
I have 2 lists on one SharePoint site. One works as a query log (I used a custom list instead of issue tracking) and a second one is a master data list with a RAG status.
What I want to achieve is to ...
- 21
0
votes
2
answers
3k
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 ...
- 79
0
votes
1
answer
2k
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&...
- 79
0
votes
1
answer
27
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 ...
- 57
0
votes
1
answer
634
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 ...
- 79
1
vote
2
answers
981
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 ...
- 183
0
votes
2
answers
676
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
1
answer
2k
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
1
answer
2k
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 ...
- 65
0
votes
2
answers
16
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 ...
- 1
2
votes
2
answers
2k
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.
...
- 21
0
votes
1
answer
37
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 ...
- 25
1
vote
0
answers
645
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 ...
- 53
1
vote
1
answer
60
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 ...
- 13
1
vote
1
answer
106
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.
...
- 2,678
0
votes
1
answer
10k
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 ...
- 371
1
vote
1
answer
471
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")
- 11
0
votes
2
answers
68
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
1
answer
2k
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 "...
- 177
3
votes
1
answer
25
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 ...
- 31
2
votes
1
answer
377
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 ...
- 193