cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Check for value changes in one column to send email

Hello,

I have a sharepoint list which have a lot of columns and i need to send a mail when a specific column change.
And i have a problem because every time i update a field, even if the field is not the one i look for the mail is send.

 

example : i got 3 columns and i want to check changes on the second one but every time i update an item the mail is send even if i modify the 1st and the 3rd one.

 

I got like 12/14 columns and i want to check changes on only one of them to send the mail if the value of this column change.

Anyone got an idea ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Check for value changes in one column to send email

Hi @Manu_Lanikeu,

 

Please adjust the structure of the Flow, you can parse JSON after get the array instead before get it:

Annotation 2019-12-13 155846.png

 

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

View solution in original post

4 REPLIES 4
Highlighted
Dual Super User
Dual Super User

Re: Check for value changes in one column to send email

@Manu_Lanikeu 

As far as I know, this is not an "out of the box" Flow feature.

But, we are very lucky to have community members like @ScottShearer THis post from him is an excellent workaround.

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Frequent Visitor

Re: Check for value changes in one column to send email

Thanks !

I saw this one the problem is, i dont understand where i done a mistake but at the step "initialize variable to hold value to be compared"

I got an error i dont know how to resolve it

 

sc1.PNGsc2.PNGi dont know what to do at this point i tryed a lot of solutions and the deadline is coming T-T

Highlighted
Dual Super User
Dual Super User

Re: Check for value changes in one column to send email

@Manu_Lanikeu 

Can you remove the step that is currently failing, execute the flow and inspect the output of Analyser JSON action block?

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Community Support
Community Support

Re: Check for value changes in one column to send email

Hi @Manu_Lanikeu,

 

Please adjust the structure of the Flow, you can parse JSON after get the array instead before get it:

Annotation 2019-12-13 155846.png

 

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

View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,465)