cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Extracting email address from name in Microsoft Form

Hi there,

I am fairly new to Power Automate and I am seeking some help. 

I created a Microsoft Form, and one of the field allows the respondent to select a manager. In theory, the form should be sent to the manager for approval prior to put into the Sharepoint List. 

I tried to use Get User Profile (V2) but it is not working as the field is requesting email, not name. (see snippet below)

Is there any possible way to get extract the email? I notice Search for Users (V2) could return email address but I am not terrible sure. 

Many thanks in advance. 

 

werdnak_0-1593681245309.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Extracting email address from name in Microsoft Form

@werdnak 

If you using name in MS form try with Search for users(V2) action. Supply input as name from Get form details dynamic content.

Then use compose and pass dynamic content Email from Search for users. it will give you email.

 

Thanks

Hardesh

View solution in original post

4 REPLIES 4
Highlighted
Super User
Super User

Re: Extracting email address from name in Microsoft Form

@werdnak 

If you using name in MS form try with Search for users(V2) action. Supply input as name from Get form details dynamic content.

Then use compose and pass dynamic content Email from Search for users. it will give you email.

 

Thanks

Hardesh

View solution in original post

Highlighted
Helper I
Helper I

Re: Extracting email address from name in Microsoft Form

Thanks again @Hardesh15 . You are a gem!

Highlighted
Helper I
Helper I

Re: Extracting email address from name in Microsoft Form

Hi @Hardesh15 ,

 

I jumped the gun a little. I tried the following but it is returning [XXX@me.com] to Assigned to. How do I get rid of the bracket?

 

werdnak_0-1593749598941.pngwerdnak_1-1593749735181.png

 

Highlighted
Super User
Super User

Re: Extracting email address from name in Microsoft Form

@werdnak 

 

Use This in compose

1. Last(split(outputs('Compose'),'['))

2. split(outputs('Compose'),']')

 

mind the brackets.

 

Thanks

Hardesh

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,010)