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

When Choice column updated in Sharepoint trigger email

Hello,

 

Need help with an Approval Flow

The sharepoint list referenced in this is Missing Volume request (headers in snippet below)

- list created here which generates an email sent to approver

- based on email, approver has 3 options to chose from choice column status (Approved, Acknowledged, Rejected) and based on approver selection 3 different emails sent out to requestor with 3 status responses

- if approved or rejected, that is the end of it

- the problem lies when the approver acknowledges the the request, and an email is sent, I want to send a follow up email to the requestor once the choice column is updated to Approved or Rejected. Can this be done as a conditional triggered event once column value is changed on sharepoint list?

 

t_shepz_0-1622208545564.png

 

Failed attempt

- below email that request has been acknowledged, added operation of "when an item or file is modified" & Get changes for an item or a file, and then added a condition "Has column title changed: status" = true to capture change made by approver from acknowledged to approved or rejected, and than send email with update status value, but when running the flow the flow just keeps running and does not finish for hours (constant loop?)

 

Followed this guide for failed attempt https://wonderlaura.com/2020/08/25/flow-when-a-sharepoint-column-is-updated/ 

 

Would really appreciate any help, thank you

 

t_shepz_1-1622208545567.png

 

 

1 REPLY 1
annajhaveri
Community Champion
Community Champion

@t_shepz  can you share the screenshot of your flow? are you updating the value of the status column from the flow, if yes then to what value? Also do you have trigger condition configured on your flow, if yes then can you please share the trigger condition that you have configured?

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,590)