Setting up a formula in Excel to adjust the spreadsheet and trigger Power Automate

[Liz001]

I am interested in setting a formula to alter excel enough to trigger Power Automate when a date reaches its due date. The conditional formatting that I have tried so far only changes the color, which doesn’t trigger the email to be sent in Power Automate. (I have Power Automate set up currently to email me anytime the spreadsheet changes.)

I have a spreadsheet of training dates. A date more recent than 6/30/2022, or greater than, would be “current” and a date before 6/1/2022, or less than, would be “expired”.

 

[Automatrix]

Formulas won't execute if you don't open the workbook. But maybe you can have another Power Automate flow check regularly if the due date has been reached, and then change the workbook to trigger the email flow.

 

[Liz001]

Formulas won't execute if you don't open the workbook. But maybe you can have another Power Automate flow check regularly if the due date has been reached, and then change the workbook to trigger the email flow.

Oh, I didn't know that Power Automate can check due dates. (?)

 

[Automatrix]

Oh, I didn't know that Power Automate can check due dates. (?)

It should be able to open Excel, run through a series of cells and check whether any of them meet a particular condition. Thinking about it, maybe you only need one flow for this:
- open excel, check a particular cell
- if it's a due date that has been reached, send an email and make a note in Excel to avoid triggering the flow next time.
- go to next row

 

[Liz001]

It should be able to open Excel, run through a series of cells and check whether any of them meet a particular condition. Thinking about it, maybe you only need one flow for this:
- open excel, check a particular cell
- if it's a due date that has been reached, send an email and make a note in Excel to avoid triggering the flow next time.
- go to next row

Thank you!