Getting the User's department using Office365Users.ManagerV2(DataCardValue6.Selected.Email).department and set it as the default value for dropdown will raise this error "Expected Record Value"

[johnjohn123]

I have a dropdown list which contains all the departments inside our AD, then inside our form, i disable the department dropdown and i want to auto populate it with the Office365Users.ManagerV2(DataCardValue6.Selected.Email).department, but when i tried the below i got an error "Expected Record Value":-

[happyume]

The syntax of Office365Users.ManagerV2("abc@domain.com").department is correct and will give you a single line of text.

Can you just select DataCardValue6.Selected.Email and confirm that you are getting the email address as expected?

[rsaikrishna · Accepted solution]

@johnjohn123 

What is the Items property value for Department dropdown? This is collection of values.

Office365Users.ManagerV2(DataCardValue6.Selected.Email).department is a single value. You are trying to place a text value into a table of values. Due to that, you see the error.

Give a try with following:

LookUp(<Drop down items property formula>,Value=Office365Users.ManagerV2(DataCardValue6.Selected.Email).department)

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[Digital]

Check you if your  formula returns a table value. If that's the case try:

First(Office365Users.ManagerV2(DataCardValue6.Selected.Email)).department

[johnjohn123]

@rsaikrishna  the items are:-

[johnjohn123]

@Digitalsame error when i used :-

First(Office365Users.ManagerV2(DataCardValue6.Selected.Email)).department

[johnjohn123]

@rsaikrishna  i tried this but got an error "Name is not valid":-

[johnjohn123]

@rsaikrishnanow i tried this also:-

where i did not get any error... but at the same time no dropdown option will get selected, it will stay blank..

[johnjohn123]

@rsaikrishnayour formula worked for me:-

seems the SharePoint dropdown were missing some options.. thanks

[StalinPonnusamy]

Hi @johnjohn123

Set the Default Property of Department Dropdown to

Office365Users.ManagerV2(DataCardValue6.Selected.Email).department