Form sends an email, but want to use a list instead

(0) Share

Report

Posted on by mvaladez

112

Hello,

I've created a form/automation when people call in or leave early for the day. This information is passed on to certain individuals in upper management. It's annoying when have to go back through the automation to update emails or remove old users. I thought there was a way to achieve the same effect, but using a SharePoint list of users to be notified. Any direction is greatly appreciated.

Thanks!

All responses (2)

Answers (1)

mvaladez 112 on at

Like (0)

Report

Re: Form sends an email, but want to use a list instead

Thank you for that! What if some of the users are external?
Verified answer

grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: Form sends an email, but want to use a list instead

The below flow should give you the details on how to retrieve users from a list and their emails to send an email.

For this example, I have the following list that has three users.

See full flow below. I'll go into each of the actions.

Get items retrieves the users from the list.

Select extracts out the Emails for each user.

Send an email uses the following expression to remove any duplicate emails and join each email with a semi-colon.

join(union(body('Select'), body('Select')), ';')