
Announcements
Hello,
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.
Hi @salvar2020 ,
In my opinion, you may need to build a scheduled cloud flow and run it every hour. Check if a specific email has been received in the flow. If the email is not received, flow send email to you and change the Check-In Status field.
Best Regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.