0

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 set to "YES".

I add the list item, the column stays as "NO", email doesn't send. Perfect.

Couple of hours later, I modify the list item, the column still stays as "NO", email doesn't send. Perfect.

Next day, I edit the list item again, change this particular column to "YES", the email sends. Perfect.

Like I say, it's working. My issue is STOPPING the email being sent again as soon as only one email has been sent. Once the column is set to "YES", it will never be set to "NO" again.

Because I would normally go in and out of the list item at various times, I need some way of stopping the email being sent if the value was already "YES" before modifying the list item.

I tried using trigger conditions in "when an item is created or modified" setting but it triggers mail even when that particular column is not being modified but was previously set to "Yes".

Kindly suggest how can this be achieved. Thank you!


Original Answer: You can overcome sending an email repeatedly by following logic :-

Create a new column(you can hide it from list view) as Choice column having choices 'Yes' and 'No', say it as IsEmailSent? (Set Default value = 'No')

Then in flow , check below condition before 'Send an Email' action -

If IsEmailSent == 'No' && YourChoiceColumn == 'Yes' .

Add your action to 'Send an email' .

Add action to update list item and set IsEmailSent= 'Yes'.

By this, email will send only once.


New question: Could you provide screen shots of how to input a check below condition before 'Send an Email' action (basic user)?

I'm not sure how or where to put: If IsEmailSent == 'No' && YourChoiceColumn == 'Yes'

Currently, I have a Condition (Send Email = yes), which automatically puts the yes/no options.

I have If yes, send a email.....

From your answer: I understand: Create a new column(you can hide it from list view) as Choice column having choices 'Yes' and 'No', say it as IsEmailSent? (Set Default value = 'No')

DO NOT UNDERSTAND:

Then in flow , check below condition before 'Send an Email' action -

If IsEmailSent == 'No' && YourChoiceColumn == 'Yes' .

Add your action to 'Send an email' .

Add action to update list item and set IsEmailSent= 'Yes'.

I'm hoping screen shots would help me. Thank you. @Diksha Poddar

0

See the screenshot below showing how to set this condition in Power Automate.

enter image description here

Detail 1

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.