You’re offline. This is a read only version of the page.
I'm trying to create a Power Automate flow from an Excel file I have uploaded to an Excel file that is stored in my OneDrive.
I added conditional formatting so that when an employee's badge is 30 days away from expiring the cell turns red.
I would like to add a Power Automate flow that detects when a badge is 30 days from expiring and sends an email to management.
Is there anyone who can advise on a step by step process on how I can accomplish this?
Below is a screen shot (names blurred) of the columns I am working with.
Thanks for the reply.
It looks like this has mostly worked. I built the flow based on what you shared out, but I am getting a blank email. Do you have any tips on what might be going wrong?
Hi @brianhoops1 ,
I've made a test for your reference:
1\My Excel table
2\My flow
Filter Condition
Share
Report
All responses (
Answers (@and(
less(float(split(dateDifference(utcNow(), item()['Badge Expiration Date']), ':')[0]), 30),
greater(float(split(dateDifference(utcNow(), item()['Badge Expiration Date']), ':')[0]), 0)
)Result
Best Regards,
Bof
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
