cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DarkLord22
Level: Powered On

Get Full name from Email address.

Thank you all in advance for your help.

 

I have a sharepoint database that has 3 columns, supervisor_email,RO_email, BA_email.

I run a powerapp that poppulates the sharepoint with the appopriate email.

My problem is that i want to get from inside the microsoft flow their full name from their email.

This way i can update my sharepoint database and use it for future approval emails.

I am not sure if there is possibility to do that.

 

Kind regards.

1 ACCEPTED SOLUTION

Accepted Solutions
SamPo
Level 8

Re: Get Full name from Email address.

@DarkLord22 You can still perform one update to the sharepoint list without using a loop for the get 365 users.

Just add the get 365 3 times then add one update item with the values from each 'get 365'.

 

2019-04-17_1052.png

10 REPLIES 10
SamPo
Level 8

Re: Get Full name from Email address.

@DarkLord22 Do all the users have a 365 or Azure AD account in your organisation?

If yes then you can use either the 365 user connector or the Azure AD connected to get the full details of the user.

 

For example you can use the following connecter for 365 users:

2019-04-16_1624.png

DarkLord22
Level: Powered On

Re: Get Full name from Email address.

They all have 365 emails can you explain in more detail how i can do it?

 

Bellow picture of what i am trying to do.

 

So  should i place another update item after the get user?

 

Thanks!

 

flow.JPG

 

SamPo
Level 8

Re: Get Full name from Email address.

@DarkLord22 You can put the 365 action before the update then update the item in sharepoint in one action. Use the dynamic content from PowerApps for the email field and the dynamic content from 365 for the name field.

 

For example:

2019-04-16_1719.png

 

Obvioulsy my list fields aren't exactly the same as yours, this just happens to be a list I have that includes email and full name.

 

Hope this helps,

Sam

 

Super User
Super User

Re: Get Full name from Email address.

@DarkLord22 the way you have your flow configured, although you are getting the user profile you aren't doing anything with it. You need to move the Get user profile BEFORE the update item action then use the Display name to populate the column in SharePoint. Although my image below is using Forms as the trigger the principle is the same.

Rob
Los Gallardos

getUserProfile3.png

DarkLord22
Level: Powered On

Re: Get Full name from Email address.

Thanks you all let me test it!

 

How i can do that with 3 different emails?

 

I want to store the 3 different full names to different sharepoint columns.

 

Thank you!

SamPo
Level 8

Re: Get Full name from Email address.

@DarkLord22 You will need to add the 'get user profile' 3 times seperately in your flow and each time use the relevant input from PowerApps. I advise renaming each of them so its obvious which is which.

 

It can be done in a loop with an array which would be a more elegant solution but the above should work just fine.

DarkLord22
Level: Powered On

Re: Get Full name from Email address.

Can you explain more how i can do it with a loop.

 

Since i have another flow that trigers when i do a change at the sharepoint database thus it will run 3 times if i do it 1 by 1, resulting in spam of emails...

 

Thank you all

SamPo
Level 8

Re: Get Full name from Email address.

@DarkLord22 You can still perform one update to the sharepoint list without using a loop for the get 365 users.

Just add the get 365 3 times then add one update item with the values from each 'get 365'.

 

2019-04-17_1052.png

DarkLord22
Level: Powered On

Re: Get Full name from Email address.

i get the bellow error from some reason....

 

flowerror.JPG

Highlighted
SamPo
Level 8

Re: Get Full name from Email address.

@DarkLord22 This is a known issue with Flow. Try copying your whole flow by using the 'save as' feature to a new flow then run it again.

 

2019-04-17_1512.png

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 220 members 5,426 guests
Please welcome our newest community members: