web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps [Urgent] Person or gro...

Power Apps

Answered

[Urgent] Person or group type datacard not showing people

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have this list that links a departement ('Title') to a person ('Référent') :

In power apps, a first dropdown ask for user to select his departement :

And I would like for a second dropdown to propose the corresponding persons ('Référent').

However, this formula doesn't show anything in y drop down. I think it is beacause of the type of the column (person or group) so I need to use something like Office365.Users ?

Thanks, Max

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

A Multi-Select person column will return 1 table record. We will have to use the Ungroup function in order to retrieve the individual users:

Ungroup( Filter( 'Département / Editeur responsable', Title = Dropdown3.SelectedText.Value ).r_x00e9_f_x00e9_rent, "r_x00e9_f_x00e9_rent" )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM Thank you very much !

One last question, do you know how to ave a better display of the different persons in the dropdown ?
Here it's not very legible.

Max

Was this reply helpful? Yes No

Join the conversation