Send notitfication when due dates are within next 30 days

[diegoandre10]

Hi all

Im doing scheduled flow to notify a user of the items that are due within the next 30 days based on the column called Due date FSSC 22000

The formula in order to send the notification is:

In other words, if the due date - today() is less or equal to 30 days, then notify. If the due date is blank or due date - today() is over 30 days then do not notify.

The email (and expected result) I would like to have sent is:

So far my flow looks like this:

I attach the raw data.

https://1drv.ms/x/s!ApgeWwGTKtFdhkLV0H1zEptJNdxO?e=PUhePd

Can you please advise how to build the flow?

Thanks all.

[Jcook]

Hello @diegoandre10 

Try using the addDays() expression to todays date which can be used as utcNow() and than in your get items SharePoint , filter on the output of the addDays()

Example:

addDays(utcNow(),30,'dd/MM/yyyy')

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[diegoandre10]

Hi @Jcook 

Where should I include the column Due Date that will be the reference to subtract the 30 days?

And the email with the companies that meet the criteria?

Thanks. 

[v-bacao-msft]

Hi @diegoandre10 ,

Please try this configuration:

Hope this helps.

Best Regards,

[diegoandre10]

hi @v-bacao-msft 

Looks ok the condition of null and utc now. 

But for the for the company it should not be a "static value or equal to something" within the condition

The output should be:

Give me all the company's that meet the condition of being due within the next 30 days. So this will vary on a day by day.

So I was thinking of some sort of matrix that says on the output email:

"The following companys are overdue already or due within the next 30 days"

Company	Due date FSSC 22000
222	4/1/2020
444	4/1/2020
555	2/1/2020
666	3/1/2020
3108	1/1/2020
3663	4/1/2020
3885	8/1/2018
6216	3/1/2020
6327	3/1/2020
6438	1/1/2020
6771	12/18/2019
6882	1/1/2020

Can you please help me? Please have a look on the dataset that contains the sample I shared on my post.

Thanks.

[v-bacao-msft · Accepted solution]

Hi @diegoandre10 ,

Try to create HTML table and send by email:

Best Regards,

[diegoandre10 · Accepted solution]

Hi @v-bacao-msft 

I am getting closer to the solution. I received an email with the matrix of companies, however not all the ones that met the criteria were shown. Only 21 out of the 36 that met the criteria appeared on my email.

Here are the steps, let me know if there is something wrong:

I attach the dataset of total companies with the due date included. From 208 rows a total of 36 should meet the condition we defined.

https://1drv.ms/x/s!ApgeWwGTKtFdhkPdPd2wNt9-ORc_?e=TXBnPm

Thanks a lot!

[diegoandre10]

hi @v-bacao-msft 

I think i found part of the problem, when i run and test the flow: 

I see only 100 items:

Could this be part of the problem?

I have 208 records.

Thanks.

[diegoandre10]

For the record

I changed the threshold to 1000 and it worked!

[ScottShearer]

@diegoandre10 

Great catch!  Everyone should remember that, by default, the SharePoint Get Items action returns only 100 rows.  You can set it up to a maximum of 5000 (in most cases).  If you have more than 5000 items in your list, use OData filter queries to filter the data before you get it.

[diegoandre10]

Thank you @ScottShearer and @v-bacao-msft  !