On Call SMS Flow

Like (1) Share

Report

Posted on 9 Sep 2024 17:09:05 by DT-29080300-0

We have a team of about 10 people who rotate the on call responsibilities weekly. 1 Person is on call per week. We received after hour emails and I would like to build a flow that triggers when those after hours emails are received and to send a SMS to the person who is on call for the weekend. I can get the trigger action of when email is received, but I cannot figure out how to query for the person who is on call and their cell number so that I can use that to send the SMS. I am using Twilio to send the SMS. Any ideas on how I could get the on call persons cell phone number in here?

Categories:

Business Process Flows

All responses (2)

Answers (0)

DT-29080300-0 4 on 10 Sep 2024 at 15:33:57

Like (0)

Report

On Call SMS Flow

My source would be a Excel sheet stored on OneDrive, the data within that sheet is coming from a MS Form that collects On call persons name, Cell phone number and a start and end date of when they are on call.
Suggested answer

Michael E. Gernaey 42,466 Super User 2025 Season 1 on 09 Sep 2024 at 22:49:28

Like (1)

Report

On Call SMS Flow

Query..... it.... from.... where......

Ok here query it from here

Select * people from Unnamed Source, where Crystal Ball knows all.

Should have no problem, now.