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.

 

Jebediah
Frequent Visitor

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,338)