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

Email a summary of all new entries

Hello,

 

Very new to Flow!

 

I am trying to build a flow that will email a list of all the new entries created today that were added to an active job list.

 

I have set the schedule up properly, but I am having trouble figuring out what to do from here.   I can set it up so it sends an email for each new entry, but I'd like to consolidate it to just one email with all the entries.

 

Here is the schema share point list I am trying to send info about:

 

ID - Created - Customer Name - Size - Quantity - Description - Agency.

 

This list has 50 or so entries, with about 6 new entries a day and then 6 come off. 

 

Just want to alert my people of the new entries.

 

Any help would be appreciated!

 

Thanks,

 

Andy

4 REPLIES 4
Community Support Team
Community Support Team

Re: Email a summary of all new entries

Hi @AndyOSB,

 

According to your scenario, it seems that you are trying to get items in a list that created today and send all the items within one email.


Please try to use the action “Create HTML table” in your flow.


This blog could be a reference for you:
https://flow.microsoft.com/en-us/blog/html-tables-csvs-computer-vision/


I have created a flow on my side to test this issue, the flow is configured likes below.


An action “Filter array” is used to get the items that created today.


In the action “Send an email”, please click the show advanced options and make sure select Yes for the Is HTML field.

3.PNG

4.PNG

 

Please have a try with it and feel free reply if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AndyOSB
Level: Powered On

Re: Email a summary of all new entries

I copied your instructions to a T and it ends up sending me an email for every job that is on the list wit hthe out put below.  In your apply to each box, it has send an email.  Don't I want to do a new action outside of that?  

 

I tried doing that but I am not sure how to reference the previous actions output  (the purple out put icon is not in the dynamic content expression box)

 

I must have done something wrong or there was an error in your instruction.

 

 

Customer:

PO#:

WO#:

Memo

Material:

Type:

Blast:

Media:

Paint:

Masking:

QC:

Agency:

Bid:

SqFt:

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  
AndyOSB
Level: Powered On

Re: Email a summary of all new entries

I tried your instructions but I end up getting an email for every entry on the entire job list.  Each email has the following with relevent info for that entry. 

 

I think the send email needs to be outside of the apply to each. I try that however and I dont get the dynamic content option like when I have the send an email within the apply to each action.

 

Customer:

PO#:

WO#:

Memo

Material:

Type:

Blast:

Media:

Paint:

Masking:

QC:

Agency:

Bid:

SqFt:

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

  

M-MISC

COD

111792

(??)26 - Tube Steel w/Plate on ends Safeway Services

Carbon Steel

Assembly

G40

G40

None

None

None

None

 
Community Support Team
Community Support Team

Re: Email a summary of all new entries

Hi @AndyOSB,

 

“Send an email” action should be configured within the apply to each under “Create HTML table” action. If you put it out of the apply to each, you won’t be able to get the dynamic content.


How did you configure the function for the Filter array action? The function I was used would filter the items that created today.


While seems that you are getting all the items in the list. If possible, please show me a screenshot of your flow configuration.


Best regards,
Mabel Mao

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 184 members 4,773 guests
Recent signins:
Please welcome our newest community members: