LookUp AAD User AKA Microsoft entra identity table to auto fill with current user

(0) Share

Report

Posted on by KrishR

431

Hello Power Users,

I have a column created inside a data verse table a look up column from AAD User table. When I had it on power apps wanted to have that column value to auto fill with current logged in user details initially (Displayname) and can be editable to look up for any other user.

I came until "LookUp('AAD User',Mail = User().Email).Displayname" but throws an error "Expected record value".

Can anyone please help!

Thank you so much in advance 🙂

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

ivan_apps 2,187 Moderator on at

Like (0)

Report

It’s telling you that you need a record object, and you defined the display name (string). Simply remove the .Displayname and you have an object. There are other config properties to tell it what value within the object to display to the user.

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report

Hi @ivan_apps ,

Thanks for the quick jump in. I believe I'm missing something. Can you please help me with the right format/Syntax.

Where do I need to update the syntax? on Defaults or DefaultSelectedItems?

When I added "LookUp(AAD User,Mail = User().Email)". I can see the record values in the dropdown

Name Value
displayname aa-krish(example)
givenname AA
mail aa-krish@onmicorosoft.com

There are other name items like imaddresses, jobtitle, mobilephone.

Thank you so much again.

Was this reply helpful? Yes No