Skip to main content

Questions tagged [if-condition]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
34 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 ...
Ryan Moon's user avatar
0 votes
0 answers
165 views

Avoiding Duplicates in SharePoint List from Microsoft Accounts Using Power Automate

I've set up a flow in Power Automate to add the names, cities, and workplaces of my colleagues to a SharePoint list using their Microsoft accounts, and it's working well. However, I'm encountering a ...
Adouxi's user avatar
  • 1
0 votes
0 answers
42 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: &...
rabbitco's user avatar
  • 101
0 votes
0 answers
47 views

PowerApps Onstart navigation

I have a PowerApps customized SharePoint list form, and I'm trying to get it to open to different screens based on a Status text field. I have the main screen "Home Screen", and an approval ...
Chris's user avatar
  • 409
0 votes
1 answer
85 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 ...
user107708's user avatar
1 vote
0 answers
74 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 ...
Omar Osman's user avatar
0 votes
1 answer
255 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 ...
Chris's user avatar
  • 409
0 votes
1 answer
386 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 ...
Chris's user avatar
  • 409
1 vote
2 answers
734 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 ...
Kev Wheeldon's user avatar
0 votes
1 answer
838 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 ...
Vardenf's user avatar
  • 23
0 votes
1 answer
5k 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 ...
MAV's user avatar
  • 1
0 votes
1 answer
358 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 ...
Nicollum's user avatar
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 ...
HRY's user avatar
  • 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&...
HRY's user avatar
  • 79
0 votes
1 answer
26 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 ...
GunnerKT's user avatar
0 votes
1 answer
549 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 ...
HRY's user avatar
  • 79
1 vote
2 answers
847 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 ...
jltitus's user avatar
  • 183
0 votes
2 answers
661 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: ...
user3877505's user avatar
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: ...
Antonis Zoumpakis's user avatar
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 ...
SeriousBri's user avatar
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 ...
jmac's user avatar
  • 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. ...
Dianne's user avatar
  • 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 ...
user86348's user avatar
1 vote
0 answers
622 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 ...
taylort139's user avatar
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 ...
user85692's user avatar
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. ...
susan's user avatar
  • 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 ...
wahle509's user avatar
  • 371
1 vote
1 answer
463 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")
user81243's user avatar
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". ...
Ronald MacDonald's user avatar
1 vote
1 answer
1k 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 "...
Ruby Trustit's user avatar
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 ...
user79982's user avatar
2 votes
1 answer
367 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 ...
Biswa's user avatar
  • 193