need help with a little snip of code... if sharepoint status of item is ALREADY set to CLOSED, ignore and do nothing.

(0) Share

Report

Posted on by cchan000

359

Problem:

I have a flow when an existing item in Sharepoint is set to status: Deal Closed, then an email is sent. Problem is if I edit any other field in that item in the future, for example, name, start date, etc, it sends an email.

I need to make it so if the status changes to Deal Closed, then send an email, BUT check to see if the status is ALREADY Deal Closed. If the status is already Deal Closed, do nothing.

Below is my existing code.

When an existing item is modified in Sharepoint.

//Compose - status value

//Equals - @equals(triggerBody()?['Status']?['Value'],'Deal Closed')

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

David- 1,254 on at

Like (0)

Report
Copy link

Link copied!

I would add a yes/no field to your list named "Notification Sent" (or whatever you want) and set the default value to false/no. Then add this to your trigger condition to only run if the status is Deal Closed and notification sent is false. Then after you send the e-mail, update the item to set the Notification Sent field to true/yes.

If you test this on existing items in your list, it will not work because the field will be null. You would need to update all your existing items in the list so the value is no/false.

Was this reply helpful? Yes No
cchan000 359 on at

Like (0)

Report
Copy link

Link copied!

hi @David- , thanks for this. can you help me write the code for it?

Was this reply helpful? Yes No
Verified answer

David- 1,254 on at

Like (1)

Report
Copy link

Link copied!

Your trigger conditions would look something like this from one of my flows where I am doing the same thing you want to achieve:
The first line is like what you already have for your status (@equals(triggerBody()?['Status']?['Value'],'Deal Closed')). Then the second line is the format for the true/false field. Just replace DRN with the internal name of the field you use for this.

Was this reply helpful? Yes No
cchan000 359 on at

Like (0)

Report
Copy link

Link copied!

thanks @David- ! I was able to also create another step that auto check boxed the item once the script ran. thanks!

Was this reply helpful? Yes No