Automate an email on list item Status set to 'Complete'

Like (0) Share

Report

Posted on 3 Jan 2023 01:38:00 by Jimmyqwe

Hello

Am looking to build a flow to automate an email once an items Status field is changed to 'Completed'. Only way I currently know how to is with trigger 'when item is modified', however, this means any modifications to an item once assigned to Completed will send the email.

There could be instances where the item needs to be edited once completed, and I don't want to send an email every time. Just one email when it is initially set to Completed.

Thank you

All responses (3)

Answers (1)

Verified answer

v-chengfen-msft on 03 Jan 2023 at 07:14:05

Like (0)

Report

Re: Automate an email on list item Status set to 'Complete'

Hi @Jimmyqwe ,
Yes, you can set trigger conditions, when the Status field is 'Completed' it will not trigger. Modify the Status field for the first time, as long as the Status field is not 'Completed' before modification.

Here is a link about setting trigger conditions for your reference:
Trigger Conditions in Power Automate - EnjoySharePoint

Best Regards
Cheng Feng
Jimmyqwe 8 on 03 Jan 2023 at 07:01:27

Like (0)

Report

Re: Automate an email on list item Status set to 'Complete'

When the Status is first changed to Completed, I need the flow to run though.
v-chengfen-msft on 03 Jan 2023 at 02:59:35

Like (0)

Report

Re: Automate an email on list item Status set to 'Complete'

Hi @Jimmyqwe ,
Do you want that when the Status field is 'Completed', no matter how you modify it, the flow will not be triggered?
Please set the [When an item or a file is modified]'s trigger condition to avoid circular triggering.

Here is a link about setting trigger conditions for your reference:
Trigger Conditions in Power Automate - EnjoySharePoint

Best Regards
Cheng Feng