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

Send email when MS List column is updated

Hello,

 

I`m trying to create a flow that will trigger an email to a client when one of the columns in MS List is updated. 

 

I created this flow:

01.JPG

is working when I update the specific column, however, if I also want to update other information in the different column for the same items I'm getting email too. not sure what I`m doing wrong. 

 

Thank you!

4 REPLIES 4
ccc333ab
Solution Sage
Solution Sage

I have no idea if this is the issue, but in the past whenever I used "When an item is created or modified" trigger, and then tried to "Get changes for an item or a file (properties only)", it would always raise an error (I just created a test and I still get an error.  In your Get changes for an item or a file (properties only) action, what are you putting in your "since" field? That is what flags the error for me. 

 

The only way I could get this to work properly was to use "Whan an item or a file is modified" trigger (no create). Odd that you aren't getting an error, but maybe try a test flow and change your trigger, and see if that works. 

Hi, 

 

Thank you for your reply. In the since field, I have "modified" when this item was last changed.

I changed the trigger to "Whan an item or a file is modified" but still I have the same issue. it works when I change my first column called 1st reminder that I added to the condition, however when I update column 2 for the same item called the second reminder I get the same email. 

 

I found a solution 🙂 so I´m sharing just in case you need it one day. In the since field, I use this expression:

 

sub(int(triggerOutputs()?['body/{VersionNumber}']),1) 
 
now the flow is looking if any change was made in the item. 
ccc333ab
Solution Sage
Solution Sage

When using "Get changes for an item or a file", there are two tokens from the trigger you can use to make this a lot easier for you. They are: Trigger Window Start Token and Trigger Window End Token.  

ccc333ab_0-1624890831432.png

 

So you can then use these in your Since/Until properties when you are looking for a change to a certain column. 

ccc333ab_1-1624890906689.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,304)