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

After select name in dropdown -> display email in different label

Hi,

 

This will be prolly the easies question asked here, but I don't know how to ask google.

 

I have dropdown (with table "name", "email" attached) -> you pick "name" in this dropdown

I would like to have "email" displayed in diferent textbox that is connected to the name I selected in dropdown.

 

I am trying to use Dropdown.Selected. - but here I can only use "name". How do I display e-mail?

 

Much thanks for help 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@PowerAppsUser4 

Assuming your 'Table' looks like this:

Name UserEmail
User1 user1@yourcompany.com
User2 user2@yourcompany.com
User3 user3@yourcompany.com

 

Using Table.Name in the Items property of the Dropdown will show these values.

 

  • User1
  • User2
  • User3

 

Then to make the email appear in a label put this code in the Text property

LookUp(Table, Name = Dropdown.Selected.Value, UserEmail)

 

 

---
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."

View solution in original post

4 REPLIES 4
mdevaney
Super User
Super User

@PowerAppsUser4 

What code have you used in the Items property of your Dropdown?

 

Also, I would typically suggest using a ComboBox here that is linked to a SharePoint Person column.  Any reason why you chose the Dropdown of a ComboBox?

 

---
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."

Hi,

 

My dropdown is connected to Sharepoint. 

 

In items I'm using "Table.Name". 

 

The reason i'm using dropdown is that I need exacly 1 name

eka24
Super User
Super User

You are very close:

1. On your dropdown items use: TableName.Email
2. Then on the default of the textbox: Dropdown.Selected.Email

@PowerAppsUser4 

Assuming your 'Table' looks like this:

Name UserEmail
User1 user1@yourcompany.com
User2 user2@yourcompany.com
User3 user3@yourcompany.com

 

Using Table.Name in the Items property of the Dropdown will show these values.

 

  • User1
  • User2
  • User3

 

Then to make the email appear in a label put this code in the Text property

LookUp(Table, Name = Dropdown.Selected.Value, UserEmail)

 

 

---
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."

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.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,835)