Send a mail from a table

(0) Share

Report

Posted on by frixel

949

Hi,

I have a Flow that counts in an excel file on Sharepoint how much mail has been received in the inbox

Now I would like an email to be sent every day with the number of emails that were received yesterday.
I have tried the following but when I indicate in the flow that he should look at the date of yesterday (07-05-2019) then that is no longer correct with the day of tomorrow.

How should I change that?

Table 3

I have the same question (0)

All responses (7)

Answers (1)

v-bacao-msft on at

Like (1)

Report

Re: Send a mail from a table

Hi @frixel ,

I speculate that the configuration you have in Key Value should be the current date of the day the Flow runs.

If you want to use yesterday's date here, you could use addDays() function to get the date of yesterday.

Like:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
frixel 949 on at

Like (0)

Report

Re: Send a mail from a table

Hi @v-bacao-msft

This is perfect, but is it also posible te get more then 1 date?
Like this?
addDays(utcNow(),-1,-2,'dd/MM/yyyy')
Or like this?

When i do this the flow fails.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report
Re: Send a mail from a table

Hi @frixel ,

Please try this expression:

addDays(utcNow(),-2,'dd/MM/yyyy')

Image reference:

Best Regards,

Was this reply helpful? Yes No
frixel 949 on at

Like (0)

Report

Re: Send a mail from a table

Hi @v-bacao-msft

Excuse me for not being clear.
I mean to send two dates. So yesterday and the day before yesterday.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report
Re: Send a mail from a table

Then you need to add additional Get a row action to get the data of the day before yesterday.

Yesterday:

addDays(utcNow(),-1,'dd/MM/yyyy')

the day before yesterday:

addDays(utcNow(),-2,'dd/MM/yyyy')

Please try again.

Best Regards,

Was this reply helpful? Yes No
frixel 949 on at

Like (0)

Report

Re: Send a mail from a table

Hi @v-bacao-msft

Thanks again for your quick response.

Is it also possible to update the pivot table (where the table gets its data from) before the data is taken from the table?
So that I always have the current data in the table?

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Re: Send a mail from a table

Hi @frixel ,

There seems to be no suitable way to accomplish this through MS Flow.

Best Regards,

Was this reply helpful? Yes No