cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jebediah
Frequent Visitor

Trying to load complex data into dropdown list

Hi you PowerApps legends, first post in here.

 

I am trying to run this exercise on a custom form of mine.
https://youtu.be/kLGglidmPxg?t=541


Trying to run the following on my dropdown on the Items property to get a list of the directors associated to any project :
Distinct(Projects, Project_x0020_Director)

 

I won't return anything, I tried every other field on the SharePoint list and they work fine, but this won't won't even load anything into the dropdown. That field seems to be connected to Active Directory to retrieve the user full name from it.


When checking over the Project_x0020_Director field I get this (see attachement)

Thanks for your help

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Jebediah ,

Not a good field type to work with at the best of times (I have a blog on this), but this should work

Distinct(
   AddColumns(
      Projects,
      "Director",
      Project_x0020_Director.DisplayName
   ),
   Director
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

View solution in original post

4 REPLIES 4
WarrenBelz
Super User
Super User

Hi @Jebediah ,

It shows the data type as Complex - is this  Person Field?

Yeah, it is a Person field.

Hi @Jebediah ,

Not a good field type to work with at the best of times (I have a blog on this), but this should work

Distinct(
   AddColumns(
      Projects,
      "Director",
      Project_x0020_Director.DisplayName
   ),
   Director
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

View solution in original post

Jebediah
Frequent Visitor

thanks for the help sir. Will make sure to check that blog.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,530)