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.