Showing results for 
Search instead for 
Did you mean: 
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.


Accepted Solutions
Advocate I
Advocate I

Advocate I
Advocate I

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (2,215)