Sent email when share point column changed

(0) Share

Report

Posted on by KT61

347

Hi, How can I setup that when a certain choice is selected in a certain column, the flow sends an email.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @KT61

For demo purposes, I have created a Choice field like below, which has 3 three options

Choice1, Choice2, Choice3

Now my requirement is whenever someones changes choice value to Choice 2 it should trigger the flow

So i have designed the flow like this below

First we will use trigger to start the flow when a item is modified.

Second we will use get changes in sharepoint to know what changes had happended in item since previous version like below

Here since field we are passing the previous version number by subtracting current version number of item by 1 using below expression
sub(int(trim(split(triggerOutputs()?['body/{VersionNumber}'],'.')?[0])),1)

Next we will use condition like this

This condition check whether the choice column has changed from its previous version and its current value is Choice2 using and operator.

If condition is True, in Yes branch we can add send email action to notify the change in Choices field column like below

Hope this helps

Mark it as solution if it resolves your query 🙂

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @KT61

Please add the following actions in your flow:

and additional set the following triggering condition to make the flow trigger when a particular value is modified in the choice field. Here have taken choice field as 'ChoiceCol' and value on which flow will trigger is 'Value1':

triggering condition:
@equals(triggerOutputs()?['body/ChoiceCol/Value'],'Value1')

Please let me know if you face any problem.
thanks
Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ManishSolanki

Does adding triggering condition when that column equal value works for all scenarios?

I think it would work only for scenarios when value of that column was changed at that point.

But when you have changed another column value and the ChoiceCol value is already set to required value before editing, the mail would be sent but this time ChoiceCol is not changed, some other column value has changed.

Hope i am right

Was this reply helpful? Yes No