cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anabananei
Resolver I
Resolver I

All send email actions trigger when item is modified

Hello Guys,

 

I'm just new to Sharepoint and Flow and honestly, I have zero background in excel codings, logic, formulas, etc. (I'm not an IT guy). But I have been interested with automation which enhances processes and handoffs in the nature of my work.

 

So I created a list in sharepoint and I used the "When a new item is created or modified"

 

My list contains the following column:

Name: Single line of text, required field

Request Type: Single line of text, required field

Assinged to: Choice

Date Started: Date

Date Completed: Date

Status: Choice

 

So what I did with my workflow is, when a new item is created, it automatically sends an email to admin and fill up the status field to For Acceptance. Then the recepeint of the email edits the list and assigns to appropriate user and triggers the flow updates the item field status to Accepted and sends a new email informing that the request has been assigned. Once the task has been assigned, assigned user edits the date started then flow updates the status to In Progress. Once the user is done, he/she populates the Date completed and flow will trigger to update the status to Completed and send an email to the requestor that the request has been completed.

 

Problem:

Everytime the list item is modified, it triggers all the email actions, meaning if I enter data in Date completed, it sends email 1, 2, and 3. What more is that sometimes I receive 40+ emails. Im quessing because the action "Update an item", I have to populate the required fields which could have triggered "send an email" action multiple times (my original list has 6 required fields and 3 "update an item" action). 

 

I have attached my sample list I created and the its behaviour whenever I update an item. Sorry, I'm not in the office yet and I do not have access to the site in my personal computer. Kindly help me on this one.

 

Thank you,

anabananei

 

 

Screen Shot 2018-06-04 at 8.32.29 PM.png

 

 

 

 

 

  

1 ACCEPTED SOLUTION

Accepted Solutions
anabananei
Resolver I
Resolver I

Workaround that I did as I don't have a concrete solution as of now. The only way to do it is to triger the flow manually by using "For a selected item". I achieved this on a SharePoint list. I have a button that when I click it, it does lots of things including sending of email. ANd the good news is that, whoever ticked the button, he/she will be the sender of email. Just make sure to include the persons you want to be as a flow owner. There is also a way to include a button in SharePoint Library. I haven't tried it but I'm planning to.

 

Here is the reference link for the buttons in SharePoint: https://wonderlaura.com/2018/07/18/button-in-sharepoint-list-to-trigger-microsoft-flow/

 

I tweaked several codes there so I could replace buttons everytime I click a certain button to perform a certain task. My SharePoint list has three buttons, each with different assigned flows that are placed in the same column. After I ticked the first button, the first flow will trigger and once certain conditions are met, it will dissappear and is repalced by the 2nd button which have a different flow until it gets to my third button. (My buttons include Assign, Start, Submit).

 

Let me know if you need any help.

 

Thanks!

View solution in original post

10 REPLIES 10
ScottShearer
Super User
Super User

Can you post a screen shot of your Flow?  That will make it much easier to assist.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Hi Scott,

 

Thank you very much for your reply. Below is the flow I made. I know something is wrong but I just can't figure it out. And since I am using the "When an item is created or modified" the triggers for item created might also trigger when the item is modified. Is there a way to stop a certain action when condition is met. I tried using a switch case but I cannot figure out how to enter the value for the Case especially if the value I will be using is a choice or a date. 

 

Flow should be:

New item created in list > Auto update status to For Acceptance > Send email notification to admin > admin edit list and assigns it to a user > Auto update Status to accepted > assigned user edit list and enter Date started > Auto updates the status to In Progress > assigned user edit list and enter date completed > auto update status to completed and send completion email to requestor.

 

 

 

Flow OverviewFlow OverviewPart 2.jpgPart 3.jpgPart 4.jpg

To stop the Flow from from running when the item is modified, immediately after the trigger, have an if statement that compares the created and modified columns,  If they are not the same, exit the Flow with a control terminate action.

 

Can you be more specific about what isn't working properly?

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Actually, every all email actions are triggered when I update a certain item. Maybe because I'm lacking the terminate control. The problem is that I don't know how to do it yet, and also how to formulate my If statement. If you could give me an example, I could figure it out.

 

Also, by looking at my flow, is it okay to have 3 consecutive decisions? I tried using switch case but I have trouble populating the "Case equals" value since my "Switch On" value is a Dynamic content choice. Is there a way to fill this field by using the Dynamic content "Assigned to Value"?

 

Ana

part 5.jpg

v-xida-msft
Community Support
Community Support

Hi @anabananei,

 

I think your issue is related to the trigger of your flow. The "When an item is created or modified" trigger would be fired when a new item is created or an existing item is modified. The "Update item" actions within your flow would fire the trigger again. So your flow would be trapped into a infinite loop.

 

I have made a test on my side, please take a try with the following workaround:

  • Add a "When an item is created" trigger, specify Site Address and List Name.
  • Add a "Update item" action, Status Value field set to For Acceptance.
  • Add a "Send an email" action, To field set to Created By Email dynamic content of the trigger. 
  • Add a "Do Until" action, click "Edit in advanced mode", type the following formula:
@not(empty(body('Get_item')?['Assigned_x0020_to']))

The Count property set to empty and Timeout property set to P30D.

 

Within "Do Until" action, add a "Get item" action, specify Site Address and List Name, Id field set to ID dynamic content of the trigger.

 

  • Under "Do Until" action, add a "Update item 2" action, Status Value field set to Accepted.
  • Add a "Send an email 2" action, To field set to email address of the Assigned user. 
  • Add a "Do Until 2" action, click "Edit in advanced mode", type the following formula:
@not(empty(body('Get_item_2')?['Date_x0020_Started']))

The Count property set to empty and Timeout property set to P30D.

 

Within "Do Until 2" action, add a "Get item 2" action, specify Site Address and List Name, Id field set to ID dynamic content of the trigger.

 

  • Under "Do Until 2" action, add a "Update item 3" action, Status Value field set to In Progress.
  • Add a "Do Until 3" action, click "Edit in advanced mode", type the following formula:
@not(empty(body('Get_item_3')?['Date_x0020_Completed']))

The Count property set to empty and Timeout property set to P30D.

 

Within "Do Until 3" action, add a "Get item 3" action, specify Site Address and List Name, Id field set to ID dynamic content of the trigger.

 

  • Under "Do Until 3" action, add a "Update item 4" action, Status Value field set to Completed.
  • Add a "Send an email 3" action (Completed notification email), To field set to Created By Email dynamic content of the trigger.

Image reference:15.JPG

 

16.JPG

 

17.JPG

 

18.JPG

 

19.JPG

 

20.JPG

The flow works successfully as below:21.JPG

 

 

 

Best regards,

Kris

 

 

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

Hi Kris,

 

Thank you for your suggestion. I tried to recreate your flow and I received an error when I left the value for Count as blank. The error are as follow:

WorkflowRunActionUntilLimitInvalid. The provided 'until' limit count value '0' is not valid. The count must be a positive integer no larger than '5000'.

 6-6-2018 12-42-10 PM.jpg

 

 

When I changed the Count value to "1", the flow ran successfuly. However, it went straight to the last action even though I just created an item (not yet updating the Assigned to, Date Started, Date Completed). Is it possible to add an if function and add a control terminate action just as @ScottShearer mentioned above? The Email 2 and Email 3 should only be triggered once I have updated the "Assigned to" and Date "Completed" respectively.

 

If it isn't a bother, can you also explain what is the meaning of Count and Timeout property means? And what values should I consider when populating values on it? And I was thinking if the column name that I should input in the Do until action is the internal column name from the address bar. Please confirm. I very much appreciate your help.

 

6-6-2018 1-01-16 PM.jpg

 

Thank you,

Ana

Posting another response. My first response suddenly dissappeared.

 

Hi Kris,

 

Thank you for providing your insights. It was helpful. I tried to recreate the flow you created but I got an error message when I left the Count Property blank.  6-6-2018 12-42-10 PM.jpg

 

When I changed the value of Count  to "1", the flow ran successfully. However, When I tried creating an actual new item in the list, but all actions were triggered and were performed from start to finish--Sending Email 2 and Email 3; Updating item 1-4. The problem is Send an Email 2 and Update item 2 should only be triggered when "Assigned to" has been modified. And Send an Email 3 and Update Item 4 will be triggered when "Date Completed" has been modified. Is it possible to add a condition or switch case for it so that the Send an Email actions won't be triggered at the same time?

 

Also, is it true that the value for column name in the Do until action should be the internal column name? If so, is the column name found in the address bar in the list settings the correct one to use? See below:

6-6-2018 1-01-16 PM.jpg

 

And if its not a bother, is there a guide on how to populate the Count and Time Out in the Do until action?

 

Thank you,

Ana

 

Hi @v-xida-msft,

 

I tried your flow again and it worked! The only problem is that, actions will  not be triggered when a new item is created and the existing ones are not yet done completed. Example: When I input value to "Date Completed" it should trigger the "Send an email" action. However, if I have yet to input the value to "Date Completed", and I added a new item in the list, the flow of the previous item will stop and a new flow will be initated for the new item that I just entered. 

 

I saw a response form @v-yamao-msft to add a condition to send an email whenever a certain tem is modified. But I don't know exactly how to do it. The link is at: https://powerusers.microsoft.com/t5/Building-Flows/Flow-update-to-SharePoint-list-item-fields-trigge...

 

Also, I read a post of a workaround for  "When an item is created or modified". It prevents the flow to be on a loop but instead the actions will only trigger twice. But I don't really want that to happen on my flow. My flow involves of sending multiple email messages and I don't want to spam the affected users by trigerring the actions twice. Are there any other ways to address the issue?

 

I saw one of your posts here: https://powerusers.microsoft.com/t5/General-Flow-Discussion/Flow-running-thousands-of-times-on-SP-qu...

 

I hope you could help me on this one.

 

Many thanks!

Ana

anabananei
Resolver I
Resolver I

Workaround that I did as I don't have a concrete solution as of now. The only way to do it is to triger the flow manually by using "For a selected item". I achieved this on a SharePoint list. I have a button that when I click it, it does lots of things including sending of email. ANd the good news is that, whoever ticked the button, he/she will be the sender of email. Just make sure to include the persons you want to be as a flow owner. There is also a way to include a button in SharePoint Library. I haven't tried it but I'm planning to.

 

Here is the reference link for the buttons in SharePoint: https://wonderlaura.com/2018/07/18/button-in-sharepoint-list-to-trigger-microsoft-flow/

 

I tweaked several codes there so I could replace buttons everytime I click a certain button to perform a certain task. My SharePoint list has three buttons, each with different assigned flows that are placed in the same column. After I ticked the first button, the first flow will trigger and once certain conditions are met, it will dissappear and is repalced by the 2nd button which have a different flow until it gets to my third button. (My buttons include Assign, Start, Submit).

 

Let me know if you need any help.

 

Thanks!

Hi!

 

I tried replicating this. The first flow successfully ran, but when i tried inserting a condition and replicated the same flow under "If No" condition, it's giving me the error below:

 

Learenann_0-1611680927641.png

 

Helpful resources

Announcements

Exclusive LIVE Community Event: Power Apps Copilot Coffee Chat with Copilot Studio Product Team

It's time for the SECOND Power Apps Copilot Coffee Chat featuring the Copilot Studio product team, which will be held LIVE on April 3, 2024 at 9:30 AM Pacific Daylight Time (PDT).     This is an incredible opportunity to connect with members of the Copilot Studio product team and ask them anything about Copilot Studio. We'll share our special guests with you shortly--but we want to encourage to mark your calendars now because you will not want to miss the conversation.   This live event will give you the unique opportunity to learn more about Copilot Studio plans, where we’ll focus, and get insight into upcoming features. We’re looking forward to hearing from the community, so bring your questions!   TO GET ACCESS TO THIS EXCLUSIVE AMA: Kudo this post to reserve your spot! Reserve your spot now by kudoing this post.  Reservations will be prioritized on when your kudo for the post comes through, so don't wait! Click that "kudo button" today.   Invitations will be sent on April 2nd.Users posting Kudos after April 2nd at 9AM PDT may not receive an invitation but will be able to view the session online after conclusion of the event. Give your "kudo" today and mark your calendars for April 3, 2024 at 9:30 AM PDT and join us for an engaging and informative session!

Tuesday Tip: Unlocking Community Achievements and Earning Badges

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!     THIS WEEK'S TIP: Unlocking Achievements and Earning BadgesAcross the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. These badges each signify a different achievement--and all of those achievements are available to any Community member! If you're a seasoned pro or just getting started, you too can earn badges for the great work you do. Check out some details on Community badges below--and find out more in the detailed link at the end of the article!       A Diverse Range of Badges to Collect The badges you can earn in the Community cover a wide array of activities, including: Kudos Received: Acknowledges the number of times a user’s post has been appreciated with a “Kudo.”Kudos Given: Highlights the user’s generosity in recognizing others’ contributions.Topics Created: Tracks the number of discussions initiated by a user.Solutions Provided: Celebrates the instances where a user’s response is marked as the correct solution.Reply: Counts the number of times a user has engaged with community discussions.Blog Contributor: Honors those who contribute valuable content and are invited to write for the community blog.       A Community Evolving Together Badges are not only a great way to recognize outstanding contributions of our amazing Community members--they are also a way to continue fostering a collaborative and supportive environment. As you continue to share your knowledge and assist each other these badges serve as a visual representation of your valuable contributions.   Find out more about badges in these Community Support pages in each Community: All About Community Badges - Power Apps CommunityAll About Community Badges - Power Automate CommunityAll About Community Badges - Copilot Studio CommunityAll About Community Badges - Power Pages Community

Tuesday Tips: Powering Up Your Community Profile

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!   This Week's Tip: Power Up Your Profile!  🚀 It's where every Community member gets their start, and it's essential that you keep it updated! Your Community User Profile is how you're able to get messages, post solutions, ask questions--and as you rank up, it's where your badges will appear and how you'll be known when you start blogging in the Community Blog. Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile.     Password Puzzles? No Problem! Find out how to sync your Azure AD password with your community account, ensuring a seamless sign-in. No separate passwords to remember! Job Jumps & Email Swaps Changed jobs? Got a new email? Fear not! You'll find out how to link your shiny new email to your existing community account, keeping your contributions and connections intact. Username Uncertainties Unraveled Picking the perfect username is crucial--and sometimes the original choice you signed up with doesn't fit as well as you may have thought. There's a quick way to request an update here--but remember, your username is your community identity, so choose wisely. "Need Admin Approval" Warning Window? If you see this error message while using the community, don't worry. A simple process will help you get where you need to go. If you still need assistance, find out how to contact your Community Support team. Whatever you're looking for, when it comes to your profile, the Community Account Support Knowledge Base article is your treasure trove of tips as you navigate the nuances of your Community Profile. It’s the ultimate resource for keeping your digital identity in tip-top shape while engaging with the Power Platform Community. So, dive in and power up your profile today!  💪🚀   Community Account Support | Power Apps Community Account Support | Power AutomateCommunity Account Support | Copilot Studio  Community Account Support | Power Pages

Super User of the Month | Chris Piasecki

In our 2nd installment of this new ongoing feature in the Community, we're thrilled to announce that Chris Piasecki is our Super User of the Month for March 2024. If you've been in the Community for a while, we're sure you've seen a comment or marked one of Chris' helpful tips as a solution--he's been a Super User for SEVEN consecutive seasons!   Since authoring his first reply in April 2020 to his most recent achievement organizing the Canadian Power Platform Summit this month, Chris has helped countless Community members with his insights and expertise. In addition to being a Super User, Chris is also a User Group leader, Microsoft MVP, and a featured speaker at the Microsoft Power Platform Conference. His contributions to the new SUIT program, along with his joyous personality and willingness to jump in and help so many members has made Chris a fixture in the Power Platform Community.   When Chris isn't authoring solutions or organizing events, he's actively leading Piasecki Consulting, specializing in solution architecture, integration, DevOps, and more--helping clients discover how to strategize and implement Microsoft's technology platforms. We are grateful for Chris' insightful help in the Community and look forward to even more amazing milestones as he continues to assist so many with his great tips, solutions--always with a smile and a great sense of humor.You can find Chris in the Community and on LinkedIn. Thanks for being such a SUPER user, Chris! 💪 🌠  

Find Out What Makes Super Users So Super

We know many of you visit the Power Platform Communities to ask questions and receive answers. But do you know that many of our best answers and solutions come from Community members who are super active, helping anyone who needs a little help getting unstuck with Business Applications products? We call these dedicated Community members Super Users because they are the real heroes in the Community, willing to jump in whenever they can to help! Maybe you've encountered them yourself and they've solved some of your biggest questions. Have you ever wondered, "Why?"We interviewed several of our Super Users to understand what drives them to help in the Community--and discover the difference it has made in their lives as well! Take a look in our gallery today: What Motivates a Super User? - Power Platform Community (microsoft.com)

March User Group Update: New Groups and Upcoming Events!

  Welcome to this month’s celebration of our Community User Groups and exciting User Group events. We’re thrilled to introduce some brand-new user groups that have recently joined our vibrant community. Plus, we’ve got a lineup of engaging events you won’t want to miss. Let’s jump right in: New User Groups   Sacramento Power Platform GroupANZ Power Platform COE User GroupPower Platform MongoliaPower Platform User Group OmanPower Platform User Group Delta StateMid Michigan Power Platform Upcoming Events  DUG4MFG - Quarterly Meetup - Microsoft Demand PlanningDate: 19 Mar 2024 | 10:30 AM to 12:30 PM Central America Standard TimeDescription: Dive into the world of manufacturing with a focus on Demand Planning. Learn from industry experts and share your insights. Dynamics User Group HoustonDate: 07 Mar 2024 | 11:00 AM to 01:00 PM Central America Standard TimeDescription: Houston, get ready for an immersive session on Dynamics 365 and the Power Platform. Connect with fellow professionals and expand your knowledge. Reading Dynamics 365 & Power Platform User Group (Q1)Date: 05 Mar 2024 | 06:00 PM to 09:00 PM GMT Standard TimeDescription: Join our virtual meetup for insightful discussions, demos, and community updates. Let’s kick off Q1 with a bang! Leaders, Create Your Events!  Leaders of existing User Groups, don’t forget to create your events within the Community platform. By doing so, you’ll enable us to share them in future posts and newsletters. Let’s spread the word and make these gatherings even more impactful! Stay tuned for more updates, inspiring stories, and collaborative opportunities from and for our Community User Groups.   P.S. Have an event or success story to share? Reach out to us – we’d love to feature you!

Users online (6,043)