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

Like (0) Share

Report

Posted on 20 Dec 2023 16:19:51 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!

I have the same question (0)

All responses (2)

Answers (1)

mvaladez 112 on 20 Dec 2023 at 21:13:52

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?

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,059 Moderator on 20 Dec 2023 at 21:04:05

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')), ';')

Was this reply helpful? Yes No