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

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

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

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
Jay-Encodian
Community Champion
Community Champion

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

 

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

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

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.

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

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

 

Annotation 2020-01-07 153747.png

@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

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

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

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

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, 

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

Awesome Thank you.

Gilbertr14
Frequent Visitor

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

 

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,517)