cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamesbetteridge
Advocate I
Advocate I

Send an email with multiple items from a sharepoint list

Hi,

 

I'm relatively new to MS Flow and am by no means a developer but I am keen to learn so please bear with.

 

I have a sharepoint list (of customer related info) which has a number of columns but the important ones in this example are the customer name, date of next call and Account Manager fields.

 

In short, I want to build a Flow that, only a daily or weekly basis, sends an email to a member of staff which lists the accounts that they need to call that day/week. I have built a flow which does this for the most part however it sends a seperate email for every account rather than one email for all accounts that are due a call.

 

I tried the usual Google/YouTube searches and have found a couple of solutions but nothing I have put in works :-S

 

As per my opening statement, I'm pretty new to all this so if anyone would like to take pity on a Noob then please reach out 🙂

16 REPLIES 16
Pstork1
Multi Super User
Multi Super User

I assume that you have your send email inside an Apply to each loop.  That's why you are getting multiple emails.  The fix is to build an array of values inside the loop and then send the email once after the loop finishes.  You'll need to use the array to create an HTML table to put inside the email.

 

Also, you may need two loops, one to loop through each user and an inner loop to loop through all the customers for that user.  The email would then be outside the inner loop, but inside the out loop (user loop).



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

Hi @Pstork1 

 

Thanks for the quick reply, really appreciated. I'm afraid it looks like you might have to dumb it down a bit for me, sorry. I have tried to combine what you suggested (I think), with what I found from Google and YouTube and have (not sure how to add an image so hopefull this link will work) Flow 1 

 

Basically, I have a scheduled trigger, followed by an "Initialize Variable" with a name of ListItems and a type of String. After that I have a GetItems which references the sharepoint site and list name (Customer Record). GetItems is filter by the customers status equalling "Live". This then goes to an Apply to Each which has the value of the GetItems output but then passes to a condition that checks to see if a call is due and if "Yes" has an apply to each containing the "Append To String Variable" which has the columns I want to display, then sends an email. The body of the email now contains the ListItems Variable.

 

What is happening is that I get an email, with every customer thats due a call listed (partial win - still need to work on the second loop you were refering to in order to have one email per account manager) but I then start receiving further emails an each subsequent email adds the contents of the list the the last email so, email one has 387 items, email two 774, email three 1161, etc., etc.

Sorry, but the link didn't work.  You can post an image by clicking on the camera icon in the editing toolbar or by adding the image as an attachment using the Choose file button below your reply.  Please post a screenshot of your flow, particular the loop and I'll try to explain where to put things.



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

Hi, 

 

Please see screenshots below. I have been tinkering a little so it is not exactly as originally stated but it's not too far off. Hopefully this is now a little closer to what I need but still requires improvement. In this current state, I get 38 emails (no idea why 38) but each one has the list of 427 customer listed - which is good 🙂

 

Flow 1.pngFlow 2.pngFlow 3.png

1) you need to sort your Get Items by the person you want to email.  I assume that is DTNC.

2) Use an out Apply to Each Loop to process each unique value for DTNC in your Get Items.  I would do this using either an array or a list that I get using a different Get Items, but you want the loop to run once for each person.

3) Inside that loop do another Apply to Each Loop to build your string of values.  

4) When you exit the inner loop send the email and reset the string to empty.  Then let the outer loop process the next person.



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

I am struggling at step one i'm afraid. There are fields I need to work with, Account Reference, Customer Name, Date of Next Call and Account Manager. The Account Manager is selected from a dropdown with a power app and so the sharepoint list's column is a choice field. When I try to sort by a choice field in the initial GetItems I get an error and the flow fails :-S.

 

 

I was wondering, I can create a View of the Sharepoint List that has the data I want, in the order I want. Is there a way to get Flow to reference a view rather than the list as a whole?

 

Views in Power Automate limit the number of columns to the ones in the view, but don't filter the number of records.  YOu have to recreate the view filter in the Get Items action.  You should be able to filter using the dropdown.  One of the things that people usually get wrong is not using the text value from the dropdown.  The dropdown provides an object, but you need to drill down to filter based on the value in the object.  Can you show the statement you are using for filtering



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

Yeah Sure, but i've been tinkering again and think I might be getting somewhere - maybe :-S. So, this is my flow currently...Flow.png 

The output of which is.....

email.png

 

So, I am getting the Account Reference at the beginning, but then all of the odata stuff, rather than just the Account Managers Name (at the end). Is there an easy way to tell the GetItems part to only pull back the value rather than all of the odata stuff?

 

As I now have the data I want all in one email, after this formatting issue, it'll just be a case of emailing each account manager their own list but i'll tackle that bridge when I get to it

Take another look at your dynamic content.  YOu are grabbing the account manager object.  There should be one that is something like 'Sage Ref. Name'.  That will have just the name in it rather than the whole object.



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

Hi @Pstork1 

 

Well that was more simple than I expected it to be! Thank you! I guess next time I should look through the whole list rather than just selecting the first item that looks like what i am after lol - leasson learnt.

 

OK, so, thanks to you I am almost there I think. I now have a list of Customer that are due. The last two things I am still struggling to comprehend are:

 

1 - The "Date of Next Call" field is coming through as "2021-03-03T00:00:00Z", is there a way to make this a friendlier date?

2 - I can't get my head around how to group the list item by account manager then send an email for each person?

 

I appreciate I have taken up a lot of your time already but would really appreciate any further guidance you can offer.

 

Cheers

James

OK so I have sussed the date formatting problem out so now all I need help with, is sending one email to each account manager that includes there list of calls to make!

 

Nearly there and thank you so much for all your help thus far!

 

To do one email per manager you want to put most of what you built inside an Apply to Each Loop.  Each loop would be for one account manager and then you filter the inner loop to collect information for just that account manager.



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

OK, I will have a play with this over the next few days. My current flow (one email with all info) worked but when I added an extra field to the email (Contact Name) it now times out. I've removed the field again and it still times out so I think i'm going to have to start from a fresh flow as what I am doing surely cant be maxing out any resource limits - it's a fairly standard sort of thing they I imagine a lot of people will be doing?

Would you be able to tell me exactly how to create the loop that sends an email for each account manager? I've had a look and it's beyond my skill set at the moment

 

Hi @Pstork1 

 

Sorry it's been so long in replying but I am back to this project now and must confess to being a little embarrased that I still cannot get this to work. I think I am going to need more specific help. The screenshot below is where I am. This gives me one email with every "Primary Owner"'s calls. What I now want to achieve is for the flow to send each Primary Owner a list of there own. This project is soooo close to being done that its frustrating the heck out of me! 🙂

 

Flow.png

Pstork1
Multi Super User
Multi Super User

 

@jamesbetteridge I'm tied up on something else right now.  But give me a day or two and I'll put together a sample of what it should look like in general.

 



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

Helpful resources

Announcements

Power Platform Connections - Episode 6 | March 23, 2023

Episode Six of Power Platform Connections sees David Warner and Hugo Bernier talk to talk to Business Applications MVP Shane Young, alongside the latest news, product updates, and community blogs.    Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show!        Show schedule in this episode:  0:00 Cold Open 00:24 Show Intro 01:02 Shane Young Interview 22:00 Blogs & Articles 22:20 Integrate FullCalendar.io with Power Pages 23:50 Text Data 25:15 Zero to Hero Power Apps Saga 25:44 Parent Hub Association 26:33 Using Custom Values for OneNote Power Automate References​ 28:04 ​Dynamics Power Israel 28:44 Create Beautiful Canvas Apps in Dataverse for Teams ​ 30:36 Outro & Bloopers  Check out the blogs and articles featured in this week’s episode:   https://francomusso.com/integrate-fullcalendar-io-with-power-pages-from-json-basics-to-advanced-outp... @crmbizcoach https://yerawizardcat.com/text/ @YerAWizardCat www.fromzerotoheroes.com/mentorship ​ @thevictordantas https://www.expiscornovus.com/2023/03/16/parent-hub-association/ ​ @Expiscornovus https://lindsaytshelton.com/2023/03/15/the-painful-process-of-custom-values-for-onenote-power-automa... @lshelton_Tech https://never-stop-learning.de/create-beautiful-canvas-apps-in-dataverse-for-teams/ @MMe2K    Action requested: Feel free to provide feedback on how we can make our community more inclusive and diverse.  This episode premiered live on our YouTube at 12pm PST on Thursday 23rd March 2023.  Video series available at Power Platform Community YouTube channel.    Upcoming events:  Business Applications Launch – April 4th – Free and Virtual! M365 Conference - May 1-5th - Las Vegas Power Apps Developers Summit – May 19-20th - London European Power Platform conference – Jun. 20-22nd - Dublin Microsoft Power Platform Conference – Oct. 3-5th - Las Vegas  Join our Communities:  Power Apps Community Power Automate Community Power Virtual Agents Community Power Pages Community  If you’d like to hear from a specific community member in an upcoming recording and/or have specific questions for the Power Platform Connections team, please let us know. We will do our best to address all your requests or questions.   

Announcing | Super Users - 2023 Season 1

Super Users – 2023 Season 1    We are excited to kick off the Power Users Super User Program for 2023 - Season 1.  The Power Platform Super Users have done an amazing job in keeping the Power Platform communities helpful, accurate and responsive. We would like to send these amazing folks a big THANK YOU for their efforts.      Super User Season 1 | Contributions July 1, 2022 – December 31, 2022  Super User Season 2 | Contributions January 1, 2023 – June 30, 2023    Curious what a Super User is? Super Users are especially active community members who are eager to help others with their community questions. There are 2 Super User seasons in a year, and we monitor the community for new potential Super Users at the end of each season. Super Users are recognized in the community with both a rank name and icon next to their username, and a seasonal badge on their profile.    Power Apps  Power Automate  Power Virtual Agents  Power Pages  Pstork1*  Pstork1*  Pstork1*  OliverRodrigues  BCBuizer  Expiscornovus*  Expiscornovus*  ragavanrajan  AhmedSalih  grantjenkins  renatoromao    Mira_Ghaly*  Mira_Ghaly*      Sundeep_Malik*  Sundeep_Malik*      SudeepGhatakNZ*  SudeepGhatakNZ*      StretchFredrik*  StretchFredrik*      365-Assist*  365-Assist*      cha_cha  ekarim2020      timl  Hardesh15      iAm_ManCat  annajhaveri      SebS  Rhiassuring      LaurensM  abm      TheRobRush  Ankesh_49      WiZey  lbendlin      Nogueira1306  Kaif_Siddique      victorcp  RobElliott      dpoggemann  srduval      SBax  CFernandes      Roverandom  schwibach      Akser  CraigStewart      PowerRanger  MichaelAnnis      subsguts  David_MA      EricRegnier  edgonzales      zmansuri  GeorgiosG      ChrisPiasecki  ryule      AmDev  fchopo      phipps0218  tom_riha      theapurva  takolota     Akash17  momlo     BCLS776  Shuvam-rpa     rampprakash   ScottShearer     Rusk   ChristianAbata     cchannon   Koen5     a33ik        AaronKnox        Matren        Alex_10        Jeff_Thorpe        poweractivate        Ramole        DianaBirkelbach        DavidZoon        AJ_Z        PriyankaGeethik        BrianS        StalinPonnusamy        HamidBee        CNT        Anonymous_Hippo        Anchov        KeithAtherton        alaabitar        Tolu_Victor        KRider        sperry1625        IPC_ahaas      zuurg     rubin_boer     cwebb365       If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. Please note this is not the final list, as we are pending a few acceptances.  Once they are received the list will be updated. 

Microsoft Power Platform | March 2023 Newsletter

Welcome to our March 2023 Newsletter, where we'll be highlighting the great work of our members within our Biz Apps communities, alongside the latest news, video releases, and upcoming events. If you're new to the community, be sure to subscribe to the News & Announcements and stay up to date with the latest news from our ever-growing membership network who find real "Power in the Community".        LATEST NEWS Power Platform Connections Check out Episode Five of Power Platform Connections, as David Warner II and Hugo Bernier chat with #PowerAutomate Vice President, Stephen Siciliano, alongside reviewing out the great work of Vesa Juvonen, Waldek Mastykarz, Maximilian Müller, Kristine Kolodziejski, Danish Naglekar, Cat Schneider, Victor Dantas, and many more.       Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show!   Did you miss an episode?  Catch up now in the Community Connections Galleries Power Apps, Power Automate, Power Virtual Agents, Power Pages     Power Platform leading a new era of AI-generated low-code development.   **HOT OFF THE PRESS** Fantastic piece here by Charles Lamanna on how we're reinventing software development with Copilot in Power Platform to help you can build apps, flows, and bots with just a simple description! Click here to see the Product Blog         Copilot for Power Apps - Power CAT Live To follow on from Charles' blog, check out #PowerCATLive as Phil Topness gives Clay Wesener Wesner a tour of the capabilities of Copilot in Power Apps.           UPCOMING EVENTS   Modern Workplace Conference Check out the Power Platform and Microsoft 365 Modern Workplace Conference that returns face-to-face at the Espace St Martin in Paris on 27-28th March. The #MWCP23 will feature a wide range of expert speakers, including Nadia Yahiaoui, Amanda Sterner, Pierre-Henri, Chirag Patel, Chris Hoard, Edyta Gorzoń, Erika Beaumier, Estelle Auberix, Femke Cornelissen, Frank POIREAU, Gaëlle Moreau, Gilles Pommier, Ilya Fainberg, Julie Ecolivet, Mai-Lynn Lien, Marijn Somers, Merethe Stave, Nikki Chapple, Patrick Guimonet, Penda Sow, Pieter Op De Beéck, Rémi Riche, Robin Doudoux, Stéphanie Delcroix, Yves Habersaat and many more.  Click here to find out more and register today!     Business Applications Launch 2023 Join us on Tuesday 4th April 2023 for an in-depth look into the latest updates across Microsoft Power Platform and Microsoft Dynamics 365 that are helping businesses overcome their biggest challenges today. Find out about new features, capabilities, and best practices for connecting data to deliver exceptional customer experiences, collaborating and creating using AI-powered capabilities, driving productivity with automation, and building future growth with today’s leading technology. Click Here to Register Today!       Power Platform Conference 2023 We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5th, 2023! But first, let's take a look below at some fun moments from MPPC 2022 in Orlando Florida. 2023 sees guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, and many more taking part, so why not click the link below to register for the #PowerPlatformConf today! Vegas, baby! Click Here to Register Today!      COMMUNITY HIGHLIGHTS Check out our top Super and Community Users reaching new levels!  These hardworking members are posting, answering questions, kudos, and providing top solutions in their communities.   Power Apps:  Super Users:  @WarrenBelz  |  @iAm_ManCat  Community Users: @LaurensM | @Rusk | @RJM07    Power Automate:   Super Users: @abm  | @Expiscornovus | @RobElliott  Community Users:  @grantjenkins | @Chriddle    Power Virtual Agents:   Super Users: @Expiscornovus | @Pstork1  Community Users: @MisterBates | @Jupyter123 | Kunal K   Power Pages: Super Users:  @OliverRodriguesOliverRodrigues | @Mira_Ghaly  Community Users: @FubarFubar | @ianwukianwuk  LATEST PRODUCT BLOG ARTICLES  Power Apps Community Blog  Power Automate Community Blog  Power Virtual Agents Community Blog  Power Pages Community Blog  Check out 'Using the Community' for more helpful tips and information:  Power Apps, Power Automate, Power Virtual Agents, Power Pages 

Register now for the Business Applications Launch Event | Tuesday, April 4, 2023

Join us for an in-depth look into the latest updates across Microsoft Dynamics 365 and Microsoft Power Platform that are helping businesses overcome their biggest challenges today.   Find out about new features, capabilities, and best practices for connecting data to deliver exceptional customer experiences, collaborating, and creating using AI-powered capabilities, driving productivity with automation—and building towards future growth with today’s leading technology.   Microsoft leaders and experts will guide you through the full 2023 release wave 1 and how these advancements will help you: Expand visibility, reduce time, and enhance creativity in your departments and teams with unified, AI-powered capabilities.Empower your employees to focus on revenue-generating tasks while automating repetitive tasks.Connect people, data, and processes across your organization with modern collaboration tools.Innovate without limits using the latest in low-code development, including new GPT-powered capabilities.    Click Here to Register Today!    

Check out the new Power Platform Communities Front Door Experience!

We are excited to share the ‘Power Platform Communities Front Door’ experience with you!   Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes ForumsUser GroupsEventsCommunity highlightsCommunity by numbersLinks to all communities Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. Additionally, they can filter to individual products as well.   Users can filter and browse the user group events from all power platform products with feature parity to existing community user group experience and added filtering capabilities.     Users can now explore user groups on the Power Platform Front Door landing page with capability to view all products in Power Platform.      Explore Power Platform Communities Front Door today. Visit Power Platform Community Front door to easily navigate to the different product communities, view a roll up of user groups, events and forums.

Microsoft Power Platform Conference | Registration Open | Oct. 3-5 2023

We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! But first, let's take a look back at some fun moments and the best community in tech from MPPC 2022 in Orlando, Florida.   Featuring guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, Stephen Siciliano, Hugo Bernier and many more.   Register today: https://www.powerplatformconf.com/   

Top Solution Authors
Users online (1,972)