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

email notification when specific item is modified

Happy Holidays everyone,
I have a task to create a flow to send 3 email notification
When an item is created in a Custom SharePoint list used for Employee feedback.

1. First Email Notification. When a new item is created the flow has to send an email notification to a few users (managers).
This email will have the link to SharePoint Item. Now the users(managers) can click on the link to view the item.
(No problem with this I was able to do this )

 

2. There is a column/ filed where the manager can input his comments. or refer to his team member to reply an email
If the manager decides to response and adds his comments in the item. Email needs to be sent to the user who created the item.

3. In case if the Manager is busy or decides to delegate this task to someone. (Manager will still edit the item and fill in the assign to the column and select user from the people picker)
so there should be an email sent to the user who was selected by the manager to respond for the feedback.

Basically, an email needs to be triggered when two fields have been modified by.


Am not able to figure out how to set this condition or rule for step 2 and 3


If the manager decides to respond. And edits the filed “response” employee who created the item should get an email notification.
And if the manager decides to have someone else respond to the user from the people picker column, then the user who was selected should get an email notification.

Can some please help me out with this.
Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: email notification when specific item is modified

Hi @jean9681blr,

 

I have made a test on my side to create sharepoint list as below:

Capture.PNG

 

The response column is a single line of text type column.

The people picker column is a person type column.

 

 

You could refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

Capture.PNG

 

Please make sure:

1. When an item is created for response, the response column and the people picker column should be empty.

2. When the manager decides to have someone else respond, he must leave the response column empty, and choose a person in the People picker column.

 

 

 

Best regards,

Alice

 

 

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: email notification when specific item is modified

Hi @jean9681blr,

 

I have made a test on my side to create sharepoint list as below:

Capture.PNG

 

The response column is a single line of text type column.

The people picker column is a person type column.

 

 

You could refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

Capture.PNG

 

Please make sure:

1. When an item is created for response, the response column and the people picker column should be empty.

2. When the manager decides to have someone else respond, he must leave the response column empty, and choose a person in the People picker column.

 

 

 

Best regards,

Alice

 

 

View solution in original post

Highlighted
Frequent Visitor

Re: email notification when specific item is modified

Thank you so much for taking the time to test and it at your side.
I followed your screenshots and created the flow.

When Condition 1 is True, the email sent to the user
However when condition 1 is false and (Condition 2 or 3 is true), the flow runs successfully but it does not send out the email the action is skipped.

Message :
ActionConditionFailed. The execution of template action 'Condition_2' is skipped: the 'runAfter' condition for action 'Send_an_email_to_Managers' is not satisfied. Expected status values 'Succeeded' and actual value 'Skipped'.

The only difference is that my Response column is multiple line of text.


Any Suggestions? 

Flow Condition 2 and 3.PNGFlow Result when condition1 is flase.PNG

Highlighted
Community Support
Community Support

Re: email notification when specific item is modified

Hi @jean9681blr,

 

I see you have added the Condition 2 inside the If yes branch of the Condition, and it is wrong.

 

Please refer to my screenshot to add the Condition 2 under the Condition, and then add the Condition 3 under the Condition 2.

Capture.PNG

 

Please let me know if your problem could be solved.

 

 

Best regards,

Alice

 

Highlighted
Frequent Visitor

Re: email notification when specific item is modified

Much appreciated,
Thank you so much for your time and sharing knowledge. It worked as expected. 🙂 

 

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new 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
Top Kudoed Authors
Users online (12,066)