Set Default Value of Dropdown based on Dataverse Lookup

(0) Share

Report

Posted on by RiccoHipp1903

284

Hello guys,

I have three tables in Dataverse for Teams

1. New Employee with Lookup to Department

2. Department with a Lookup to 'AAD Users'

3. The AAD Users

Now I want, that the Default Value of a Dropdown is set based on the DropDown of the Department.

Example

If the users Select Department HR the Value of the Dropdown Manager should Display the Default Value John Doe

If the users Select Department Research the Value of the Dropdown Manager should Display the Default value Jane Doe

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Sunil-Narnaware 681 on at

Like
a
(0)

Report
Copy link

Link copied!

Set the Items property of Manager Dropdown as Filter('AAD Users', 'AAD user id' = Dropdown1.Selected.'AAD User'.'AAD user id'). Dropdown1 points to 'Department' dropdown.. check if this is helpful.. share if there are some additional complexities..

Was this reply helpful? Yes No
RiccoHipp1903 284 on at

Like
a
(0)

Report
Copy link

Link copied!

Not bad, it could be correct, but I didn't gave you enough details. Thats why it is not working for me.

Hope this one makes it clearer.

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like
a
(0)

Report
Copy link

Link copied!

@RiccoHipp1903 .. I have similar data model in place.. and it is working for me.. can you please share the error that you are seeing on Manager dropdown?

Was this reply helpful? Yes No
RiccoHipp1903 284 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Sunil-Narnaware ,

the following errror are there:

Expected record value
invalid use of '.'

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like
a
(0)

Report
Copy link

Link copied!

@RiccoHipp1903
Here is my department dropdown properties..
And here is my manager dropdown properties..

Can you please share your details so I can look into it..?

Was this reply helpful? Yes No
RiccoHipp1903 284 on at

Like
a
(0)

Report
Copy link

Link copied!

I found it, why it doesnt work.....
Because of the Combobox im unsing...FFs i forget it isnt a dropdown....

Was this reply helpful? Yes No