cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DarkLord22
Helper III
Helper III

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
Power Participant
Power Participant

@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

View solution in original post

10 REPLIES 10
SamPo
Power Participant
Power Participant

@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

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
Power Participant
Power Participant

@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

 

@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

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
Power Participant
Power Participant

@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.

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
Power Participant
Power Participant

@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

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

 

flowerror.JPG

SamPo
Power Participant
Power Participant

@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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,079)