Share
ReportHello,
I currently have a successful flow that logs the information of templated check-in emails I receive from multiple trips around the US (shown below).
The flow captures the name and location of the check in and logs it into an online excel sheet. While the flow I created is alright for capturing data, it is not alright for monitoring daily check-ins while a trip is occurring.
I would like to create a flow that automatically notifies me when an expected check-in is past 24 hours. For example, I have a SharePoint list of active and upcoming trips within the US.
I would like the Power Automate flow to look through my outlook inbox and tell me if a check-in email from one of the Trip POC has not been received in the past 24 hours while the trip is active (between the start date and end date). Ideally, the list would also update by highlighting in red the trip that is late on a check in with the string “OVERDUE” in the Check-In Status column.
I have been working on this for some time and have not been able to figure this out. Any help or guidance would be very helpful.
All responses (
Answers (
497
