Unanswered

Building a flow that track expiry date and sending an notification.

(0) Share

Report

Posted on by elijahlee86

Hi, I am new to power automate. Could you help to build a flow (scheduled everyday to run) that enable me to track due date of all the formulations in an excel sheet and notify me (via my own email) when it hit the due date?

Formulation	A	B	C
Start Date	20-Dec-22	20-Dec-22	20-Dec-22
1 week stability due date	27-Dec-22	27-Dec-22	27-Dec-22
2 week stability due date	3-Jan-23	3-Jan-23	3-Jan-23
4 week stability due date	17-Jan-23	17-Jan-23	17-Jan-23

Thanks & Best Regards,

Elijah Lee

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @elijahlee86 ,

I have a test for your reference.

int(split(dateDifference(formatDateTime(utcNow(),'MM/dd/yyyy'),formatDateTime(items('Apply_to_each')?['1 week stability due date'],'MM/dd/yyyy')),'.')[0])

Best Regards,
Dezhi

Was this reply helpful? Yes No

elijahlee86

23 on at

Like (0)

Report

Copy link

Link copied!

Hi, Thanks for the reply. Is it possible for it to send an notification when the date hit the expiry date based on column? usually my experiment will be listed in column form. An example as shown below.

Formulation	A	B	C
Phase A	Gums	Gums	Gums
water	water	water
Phase B	Glycerin	Glycerin	Glycerin
Salt	Salt	Salt
Total weight	100%	100%	100%
Start Date	20-Dec-22	20-Dec-22	20-Dec-22
1 week stability due date	27-Dec-22	27-Dec-22	27-Dec-22
2 week stability due date	3-Jan-23	3-Jan-23	3-Jan-23
4 week stability due date	17-Jan-23	17-Jan-23	17-Jan-23

Thanks

Was this reply helpful? Yes No

elijahlee86 23 on at

Like (0)

Report
Copy link

Link copied!

Hi. I have tried the following steps. there are some error when I tried it based on this format. I only test the column based on 1 week.
step 1 and 2:
step 3:
code used for 1wk:
int(split(dateDifference(formatDateTime(utcNow(),'MM/dd/yyyy'),formatDateTime(items('Apply_to_each')?['1wk'],'MM/dd/yyyy')),'.')[0])

Error occured->

Do you have any advise on how to solve this? Thank you.

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

Like (0)

Report
Copy link

Link copied!

Hi @elijahlee86 ,

Could you please split(dateDifference(formatDateTime(utcNow(),'MM/dd/yyyy'),formatDateTime(items('Apply_to_each')?['1wk'],'MM/dd/yyyy')),' .')[0], put it in Compose action and show the output for me?

Best Regards,
Dezhi

Was this reply helpful? Yes No
elijahlee86 23 on at

Like (0)

Report
Copy link

Link copied!

Hi, Will you be able to show the process and the code if date(e.g. 1wk) hit the actual date/expiry date itself?

Was this reply helpful? Yes No