Hello,
I'm working on a flow in order to send an e-mail notification to contacts if their name is selected in a Form (Choice options question)
No problem with the Forms connectors and triggers.
For the moment, the process I'm using is :
1st Condition : the specified field in the Form contains the name "A"
Yes => send an e-mail to "A's e-mail address"
No =>go to 2nd Condition : the specified field in the Form contains the name "B"
Yes => send an e-mail to "B's e-mail address"
No => 3rd Condition ...
And so on.
It works fine, but the problem is that I have more than a dozen Names / E-mails to program, it's going to take a while...
Is there an easier way to proceed ?
Thanks
R Sygroves
(please forgive my english, I'm French)
Hi @RSygroves ,
I'm not an expert of Outlook, but as I know, there could be some settings make the URL be plain text:
You may try and send the Email to a test account and check the result.
Hope this helps.
hi @v-jefferni
thank you for this new answer.
Not sure to understand correctly, is it a seeting I can correct or does it depend on the recipient mailbox settings ?
Best,
@v-jefferni Problem apparently resolved.
I made some new tests, it seems now the process properly leads to the targetted recipient. Thanks a lot for your advice.
I noticed another issue : my e-mail contains an html link to a file on a sharepoint shared library.
When saving my flow, the link is OK, but when the message arrives only display texts remains (no more link)...
Any suggestion about that ?
Hi Jeffer,
I changed my flow's configuration using this "search for users".
It works fine, but strangely it sent e-mails to users whose name doesn't appear in the MS Form answer !
I missed the "Top : 1" setting, maybe it will help.
But I also wonder : after the "search users" connector, I use "send e-mail from a shared mailbox" (see below). Is it normal to have the Apply to each option activated ?
Hello Jeffer.
I'm going to try this connector.
Thanks for your help.
Best regards
Hi @RSygroves ,
As I mentioned above, the Office 365 User connector will be helpful to get the email address based on user name. No need to use Conditions. You can set the search term with the name coming from form response, and use the output from this action.
Hope this helps.
Hi thank you for your answer.
Actually I work with MS Forms, not an SP list.
I managed to find a solution, using conditions :
e.g. If the answer to one of the questions in the form contains person's 1 name, then an e-mail is sent to them.
If not, a new condition for person 2 and so on....
The problem is that it seems a muche more complicated process even if it actually works.
Hi @RSygroves ,
Could you please share more details about your scenario? What kind of Form are you using, the MS Forms or SharePoint list customize form? If it is the SP customize form, I think the persons are in a People type column? If so, you can easily get the respective email address to the selected user in the column, no matter in PowerApps or Flow.
So, for a people column, you can find the email address in dynamic contents:
If it is a Choice column (strongly doubt about that though), you can use Office 365 User connector and utilize the below action and get the users as well as their emails:
Hope this helps.
thank you for your answer.
Maybe my explainations aren't clear enough.
I tried to make a visual description of my desired process :
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1