0

I have Sharepoint list and made a canvas powerapp of it. In powerapps i automaticaly fill the e-mailadress of the user in a texttabel by using ThisItem.Medewerker.Email

But now i would like to also get his or her Jobtitle. However, when I use ThisItem.Medewerker.JobTitle it does not work. I get a notification This Formula uses a range that is currently not supported for evaluation. What am i doing wrong here.

3
  • Is Medewerker column of person or group type? – Ganesh Sanap Mar 31 '20 at 11:12
  • Yes, Medewerker is a person or group type. – Mirte Apr 1 '20 at 17:24
  • You can get all details of users from Office365Users connection. check this documentation. – Ganesh Sanap Apr 1 '20 at 17:53
1

You can get the Job Title of user by using Office365Users Connection like below:

Office365Users.UserProfile(ThisItem.Medewerker.Email).JobTitle

For more information check below documentation:

Connect to Office 365 Users connection from Power Apps

4
  • Hi, that does not seem to work. It looks like it expects dutch. There is no Office365User, but i keeps suggesting Office365-gebruikers. – Mirte Apr 2 '20 at 17:43
  • There supposed to be Office365Users connection as given in official Microsoft documentation. I don't know why you are not able to see it (maybe the default language set to your tenant/profile). If you are seeing Office365-gebruikers connection then I would suggest you to check the methods in this connection and use the one which matches with the example given in my answer. – Ganesh Sanap Apr 2 '20 at 18:09
  • Found it: 'Office365-gebruikers'.MyProfile().JobTitle Thanks – Mirte Apr 2 '20 at 18:26
  • Great. Glad it worked for you. Please Upvote and accept it as an answer as it helped you. – Ganesh Sanap Apr 2 '20 at 19:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.