web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / show column person in ...
Power Apps
Unanswered

show column person in text label depending in dropdown menu selection

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello Friends,

 

I have a dropdown menu with activities and I need to show in a text label the email address of each person assign to that activity, I tried this formula but is not working:

LookUp(Sp_List, DataCardValue147.Selected.ActivityDescription)
also
Concat(
LookUp(Sp_List, DataCardValue147.Selected.ActivityDescription).ActivityDescription,,";")

 

And still not working, any idea how I can see those emails in the text label? 

 
 
 
ss pa.png
Categories:
  • mdevaney Profile Picture
    29,993 Moderator on at

    @Anonymous 

    That looks like a ComboBox, not a Dropdown, correct?  There's a big difference in how they behave.

     

    Your picture is blurred out making it impossible to see what's going on in the form.  In general, if "AssignedPerson" is a people type column in your Activity list you could put this in the Text property of a label.

     

    Concat(ComboBox_Activity.Selected, AssignedPerson.mail &" ") 

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    no, it is a dropdown, let me try 

  • eka24 Profile Picture
    20,925 on at

    Try this: LookUp(Sp_List, DataCardValue147.Selected.ActivityDescription,EmailColumnName)&";"

    if the name of the Dropdown is DataCardValue147

     

    The information provided is a little bit limited. For instance what is the name of your Dropdown (is it DataCardValue147?) If not and your are placing the value in DataCardValue147, then use this: LookUp(Sp_List, DropdownName.Selected.ActivityDescription,EmailColumnName)&";"

    Or LookUp(Sp_List, DropdownName.Selected.ActivityDescription)

     

    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Eka,

     

    Thank you for that information. What I need to do is depending on the activity selected in the datacardvalue147, show me the next column that is group 1, like filter the group depending on the activity description. Based on the information that I have in my Share Point List 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Eka, 

    I need to show the emails of the column filter group, that is under the activity that I selected in the dropdown. I tried this:

    filter group.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 190 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard