cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BillYoung-arm
Helper III
Helper III

Dataverse for Teams - get User details

I'm new to Dataverse but Ive created a Dataverse for Teams table with an "employee" field which is a lookup to the User entity:

d4t1.png

In the Power App, I can display (say) the First Name, from the entity's "User Information":

d4t2.png

via: LookUp(Users,'Full Name'=ThisItem.employee.'Full Name').'First Name'
...but I can't work out how to get any of the Mailing Address information:

d4t3.png

Any suggestions?

Thanks

Bill

2 REPLIES 2
PavanKumar
Responsive Resident
Responsive Resident

Hi @BillYoung-arm ,

 

LookUp(Users,'Full Name'=ThisItem.employee.'Full Name') - That can give you user record with the matching filter criteria. With that you can get all columns in the user table.

 

e.g.

 

Collect(colSelectedUser,LookUp(Users,'Full Name'=ThisItem.employee.'Full Name'))

 

First(colSelectedUser).FirstName

First(colSelectedUser).Email1

 

Do let me know if you need any further help on this.

 

Regards

Pavan Kumar. G

Thanks Pavan
The "Mailing Address information" that I'm seeking is presumably attached via a lookup/relationship. It was specifically how to make this type of query that I was looking for
Cheers
Bill

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (59,488)