Show Data in email from todays date from Excel table: Huge Newbie alert

[Bradyhed10]

Stuck beyond stuck with a flow that I have combined from multiple resources online. 

The apply to each compares current date to dates from excel "list rows present in a table" and if it is today then the option goes to yes and sends an email. If I have multiple entries with todays date I want it all in one email that I can schedule daily at 5.

When I add create an html table before send an email it does not go through the apply to each and just sends all data with all dates through the email. Please help me

[ManishSolanki]

Hi @Bradyhed10 

Could you pls share all the name of the columns in input excel sheet?

Thanks

[Bradyhed10]

Hello @ManishSolanki 

Columns are as follows 'Sales Manager', 'Date', 'Account Name', Name of the Person you Spoke To', 'Type of Meeting', 'What was discussed.'

Appreciate your help

[ManishSolanki · Accepted solution]

Hi @Bradyhed10 

Thanks for sharing the details of the columns.

Here sample data & the flow:

Sample data in Input excel sheet:

Flow steps or actions:

1. Create a scheduled cloud flow and set up the schedule as shown below:

2. Next, get all the records from excel sheet using "List rows present in a table" action:

3. Now, add a "Filter array" action to filter the records based on the date. Click 'Edit in advanced mode' to write the filter query as shown below:

@equals(formatDateTime(item()?['Date'], 'yyyy-MM-dd'), utcNow('yyyy-MM-dd'))

4. Add "Create HTML table" action, pass the body of filter array in "From" parameter. Select "Custom" in 'Columns' parameter. For each header, we will write fx expression to get the value. Expression needs to be entered in the expression box as shown below: 

Header	Value
Sales Manager	item()?['Sales Manager']
Account Name	item()?['Account Name']
Name of the Person you Spoke To	item()?['Name of the Person you Spoke To']
Type of Meeting	item()?['Type of Meeting']
What was discussed	item()?['What was discussed']

5. Finally, add "Send an email" action, in the email body to give border to html table an expression is written:

replace (body ('Create_HTML_table'),'<table>','<table border="1">')

Output of the flow:

I hope this will help you in designing the flow you are looking for.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[Bradyhed10]

Amazing! worked great I appreciate it.