cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gilbertr14
Level: Powered On

Get Flow to email the last entry once it is entered

I have created a flow where a form is completed with multiple options. This then is entered into a SharePoint list. This then needs to email the entered data. Get it all done up to the email portion. What seems to be happening is that I am getting an email for every field entered. As some fields have multiple entries I end up getting 50 - 100 emails for a single request.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: Get Flow to email the last entry once it is entered

Hey @Gilbertr14 

SharePoint choice columns contain an array which is why the 'Apply to each' loop is auto added.

You need to update your Flow similar to this example, which performs the following steps:

For each SharePoint choice column:

1. Create a variable

2. Iterate the SharePoint columns choice array value and append to the associated columns variable.

and finally... send the email.

The SharePoint list columns:

4.pngThe Flow:

3.png

 Example run:

1.png

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

View solution in original post

Super User
Super User

Re: Get Flow to email the last entry once it is entered

Hi @Gilbertr14 

Just append either whitespace or the <br> tag (Newline) to the end of the 'Append to String Variable' actions:

1.png

HTH

Jay

View solution in original post

15 REPLIES 15
Super User
Super User

Re: Get Flow to email the last entry once it is entered

Hey @Gilbertr14 

Are you able to share a screen shot of your flow configuration?

I'm assuming you're processing the addition of the data in an 'Apply to Each' loop? in which case you need to make sure the send email action is not in the loop, but after it.

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

 

Gilbertr14
Level: Powered On

Re: Get Flow to email the last entry once it is entered

Annotation 2020-01-07 142417.pngAnnotation 2020-01-07 142418.png

Super User
Super User

Re: Get Flow to email the last entry once it is entered

Hi @Gilbertr14 

If I've understood your requirements, you need to on submission of a new form (data entered into an SP List):

  1. Respond to the 'New Item' event
  2. Send an email containing data from the newly created list item

If that's the case I'm not sure why you're using the 'Get Items' action to retrieve further data as you should have access to the new items data from the trigger action, for example you should just need to do this:

1.pngIf there is a reason for obtaining further data using the 'Get Items' action you should only have a single 'Apply to each' loop.

HTH

Jay

Gilbertr14
Level: Powered On

Re: Get Flow to email the last entry once it is entered

Hello Jay

 

The moment I add any of the fields I require, it adds the for each group automatically. I don't seem to be able to get around that.

Super User
Super User

Re: Get Flow to email the last entry once it is entered

Hi @Gilbertr14 

But you don;t actually need to use 'Get Items' to get the data of the new item.

Why are you using the 'Get Items' action?

Thanks J

Gilbertr14
Level: Powered On

Re: Get Flow to email the last entry once it is entered

I'm doing it straight form the  when new item is created.

 

Annotation 2020-01-07 153747.png

Super User
Super User

Re: Get Flow to email the last entry once it is entered

@Gilbertr14 

Can you remove all of 'Apply to Each' loop and the contained email action then just add a new 'Send Email' action underneath the 'Get Profile' action then re-add the data?

If this re-adds the loops can you confirm the type of SharePoint list columns your using?

Jay

Gilbertr14
Level: Powered On

Re: Get Flow to email the last entry once it is entered

It still does it. What I can confirm is that it does it on the columns that have Checkboxes (allow multiple selections) enabled.

 

Annotation 2020-01-07 154919.png

Super User
Super User

Re: Get Flow to email the last entry once it is entered

Give me 5, I'll mock something up for you

Highlighted
Super User
Super User

Re: Get Flow to email the last entry once it is entered

Hey @Gilbertr14 

SharePoint choice columns contain an array which is why the 'Apply to each' loop is auto added.

You need to update your Flow similar to this example, which performs the following steps:

For each SharePoint choice column:

1. Create a variable

2. Iterate the SharePoint columns choice array value and append to the associated columns variable.

and finally... send the email.

The SharePoint list columns:

4.pngThe Flow:

3.png

 Example run:

1.png

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

View solution in original post

Gilbertr14
Level: Powered On

Re: Get Flow to email the last entry once it is entered

Thank you very much this is working as required. I appreciate all the help. Our company is diving into electronic forms in a big manner, and this is one of many I have been charged to do. There also doesn't seem to be much learning material apart from the default MS docs which I am ploughing through.

 

Lastly, I have one last question pertaining to this. 

When it sends the mail it formats the variables as follows;

RedBlueGreen

 

Is there a way for it to either Format it as per the example below or alternatively put on a new line?

Red, Blue, Green, 

Super User
Super User

Re: Get Flow to email the last entry once it is entered

Hi @Gilbertr14 

Just append either whitespace or the <br> tag (Newline) to the end of the 'Append to String Variable' actions:

1.png

HTH

Jay

View solution in original post

Gilbertr14
Level: Powered On

Re: Get Flow to email the last entry once it is entered

Awesome Thank you.

Gilbertr14
Level: Powered On

Re: Get Flow to email the last entry once it is entered

So, we want this flow to run after approval. I have changed the flow to look like the attachment but I keep getting the error in the second picture. It doesn't matter what order I do these in the first one always give me the error.

Capture.PNGCapture2.PNG

 

Super User
Super User

Re: Get Flow to email the last entry once it is entered

Hi @Gilbertr14 

Always best to raise new issues in new threads to they don't get missed 🙂

Try this:

1.png

 HTH

Jay

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,486)