cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
keepinupwkaren
Advocate I
Advocate I

E-mail the person on-call when a SharePoint item is created

We have a PowerApp that populates a SharePoint List. We have an on-call schedule in Excel that resides in the SharePoint Library. We are attempting to build a flow that will alert the person on-call when a new item is created in the SharePoint List.

 

The on-call schedule has the following column headings:

 

Start Date | End Date | Team Member on Call | E-mail | Mobile phone

(on-call rotates every 7 days beginning on Sunday)

 

The flow is triggered when a new item is created. We are trying to have the flow pull the detail for the current person on call (e-mail, name, we'd eventually like to send a message to their mobile phone as well). Once the person on call is identified, an email would be sent with a link to the SharePoint item that was recently created.

 

Any assistance with the flow would be appreciated. TIA.

1 ACCEPTED SOLUTION

Accepted Solutions
keepinupwkaren
Advocate I
Advocate I

1 REPLY 1
keepinupwkaren
Advocate I
Advocate I

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,394)