Send email notification when a field is modified

[Tatyana]

Hello everyone,

I need to create a flow for a SharePoint list with following requirements: 

Field A gets modified and is not null -> triggers email notification A

Field B gets modified and is not null -> triggers email notification B

Field C gets modified and is not null -> triggers email notification C

These fields can be modified all at the same time and can be modified at random times. If they are all modified at the same time, email notifications A, B, and C should be send. What I am struggling with is if only Field B gets modified and fields A and C values stay the same, I only want notification B to be send.  

Any advice is greatly appreciated. 

[ScottShearer]

@Tatyana 

The ability to check for a change in a SharePoint column is not an "out of the box" feature in Power Automate. 

There are really just 2 ways you can accomplish your Goal:

1. Create hidden duplicate columns for each of the columns that you want to monitor.  When the item is created, use Flow to sync the columns.  When the item changes, check to see if the columns are the same or different.  Take action as appropriate and then sync the columns.
   1. If you go this route, you'll likely have a problem with an infinite loop.  Here is a link to a blog post that I wrote that shows how to avoid the infinite loop.
2. Another option is to make an HTTP call to SharePoint and check the values of the columns in the previous versions (you have to turn on versioning.  Here is a link to another post that I wrote describing how to do this.

[abm]

Hi @Tatyana 

For your requirement you need three flows. You can't capture from single flow which field user is updated.

See below

Click on the three dots and select Settings. Under the trigger condition you need to select your trigger condition expression. See below I am checking whether name is modified or not?

Do the same for other two flows as well.

You don't need to check whether Field B is modified and other values are same or not. Because you have three flows with independent triggers it will keep it as separate trigger only.

Of course you can add all three triggers under the trigger conditions in one flow but the issue is you don't get any control over which field is user modified. I believe you need three separate flow here with unique triggers.

Thanks

[Tatyana]

Hello @abm 

Thank you for your quick response and suggestion. I attempted it and got the following syntax error. I tried various things, but wasn't very successful. Any suggestions on how to fix it?

[ScottShearer]

@Tatyana 

Try putting an @ at the beginning of the expression.

[Tatyana]

Thank you @ScottShearer , that fixed my syntax error.

However, the method doesn't seem to meet my requirements. With 3 different flows set up, I'm still getting all 3 notifications when only 1 field gets modified. 

I will try one of your @ScottShearer solutions tomorrow and will keep you posted. 

Tatyana

[v-alzhan-msft · Accepted solution]

Hi @Tatyana ,

Since the function to check for the column update is not supported in Microsoft flow currently, we could only check for the item update currently, you could only take a try with @ScottShearer 's suggestion to have a copy field.

And you could take a try to create the flow, feel free to ask here if you have any problems.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.