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":-
Solved! Go to Solution.
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. |
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?
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. |
Check you if your formula returns a table value. If that's the case try:
First(Office365Users.ManagerV2(DataCardValue6.Selected.Email)).department
@Digitalsame error when i used :-
First(Office365Users.ManagerV2(DataCardValue6.Selected.Email)).department
@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..
@rsaikrishnayour formula worked for me:-
seems the SharePoint dropdown were missing some options.. thanks
Hi @johnjohn123
Set the Default Property of Department Dropdown to
Office365Users.ManagerV2(DataCardValue6.Selected.Email).department
User | Count |
---|---|
247 | |
106 | |
82 | |
51 | |
43 |