cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KJN1000
Regular Visitor

Power Automate to generate email one time to customer

Hi All,

 

I have built a flow whereby our customer should get notified of an survey date being booked when the item is modified with the condition "has column changed: Survey Date" however my flow seems to run every time any item is changed.  Can someone advise me where I am going wrong on this?

 

Please see below my flow:

 

KJN1000_0-1638300342622.pngKJN1000_1-1638300363535.png

KJN1000_2-1638300391724.png

Thanks in advance

Katie

3 REPLIES 3
NiloferA
Solution Supplier
Solution Supplier

Hello @KJN1000 ,

 

When you work on a Flow which triggers on item modified, you get a warning saying that there is a possibility of the Flow being running in an infinite loop.

 

Below are some of the options you can implement to prevent this

  1. Maintain a Flag in the List, lets assume it's initial value as blank. When you update the item from flow, update this flag to 'Yes' and add either a Trigger Condition or a condition in your Flow to check for the Flag and run only if it's not equal to 'Yes'
  2. If you are using a specific service account for Creating your Flows, you can add a trigger condition to run the Flows only when Modified By is not equal to the service account

Let me know how it goes for you with these options.

Please hit Kudo or Mark this Reply as a Solution if it helped resolve your problem. Thanks!

Hi NiloferA, 

Thanks for getting back to me.

 

When you say flag do you mean a yes/no check box in the list?

 

Thanks

Katie

 

 

NiloferA
Solution Supplier
Solution Supplier

Hello Katie,

 

You can either add Yes/No field or a Single Line of Text, both of these will work. Something to keep in mind, Yes/No column is a Boolean field internally so in the Flow you will have to compare true/false values and if you are using a Single Line of Text field then you can simply compare with Yes string.

 

 

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,715)