Create HTML table based on excel data

(0) Share

Report

Posted on by AM1974

105

I am brand new to this and need any help You could please.

I have an excel table with two date columns. I am trying to search the columns to find a date that equals todays date (1/3/23).

Then I want to email a html table to the email address on the row.

Therefore Smith would get an email like

Site Name

Site1

Site3

Site 7

because all these rows match todays date.

My flows is:

This isn't working.

1. I am getting an email for every date that equals today.

2. I am getting the full table in the emails including ones where the date does not equal today.

How do I get one email to be sent that just shows the correct lines that equal todays date please?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AM1974

I have made a test for your reference:

1.If you want to get today's date, you can use the utcNow function.
But the utcNow function returns the UTC time zone, which may be different from your time zone, you can use the addHours function.
I'm using addHours(utcNow(),8,'yyyy-MM-dd') here because I'm in UTC+8 timezone. ('yyyy-MM-dd' limited date format)

2.

union(body('Select'),body('Select'))

3.Use expressions in advanced mode of Filter array:

@and(equals(items('Apply_to_each'), item()?['Email']),or(equals(formatDateTime(item()?['Date2'], 'yyyy-MM-dd'), outputs('Compose')),equals(formatDateTime(item()?['Date1'], 'yyyy-MM-dd'), outputs('Compose'))))

4.

Best Regards,

Levi

Was this reply helpful? Yes No
AM1974 105 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help. I was getting the following error so I changed DateTime Format to ISO 8601 under List Rows Present in a table.

InvalidTemplate. The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@and(equals(items('Apply_to_each'), item()?['Email']),or(equals(formatDateTime(item()?['Date2'], 'yyyy/MM/dd'), outputs('Compose')),equals(formatDateTime(item()?['Date1'], 'yyyy/MM/dd'), outputs('Compose'))))' failed: 'In function 'formatDateTime', the value provided for date time string '44986' was not valid. The datetime string must match ISO 8601 format.'.

The flow then works but I just get a blank email with no html table. My flow is now:

@And(equals(items('Apply_to_each'), item()?['Email']),or(equals(formatDateTime(item()?['Date2'], 'yyyy/MM/dd'), outputs('Compose')),equals(formatDateTime(item()?['Date1'], 'yyyy/MM/dd'), outputs('Compose'))))

Any more help much appreciated.

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AM1974

According to your screenshot, you need to write the formula in Compose into the expression.

Best Regards,

Levi

Was this reply helpful? Yes No