cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Populate dropdown values based on id from excel

Hi,

 

I have two tables in excel,

ROTA

Employee Id and other columns

and 

Employees

Employee Id and Employee Name.

 

The Data Source for drop down is ROTA table and I would want to display Employee Name from Employees table based on the Employee Id column in ROTA table.

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks.

 

There is no gallery. I just have a drop down and the data source has to be ROTA. I just want to display Name instead of Id.

View solution in original post

3 REPLIES 3
Super User
Super User

So

Dropdown Items = ROTA.EmployeeID

Now i added a gallery below

and for items i will be using a filter

Filter(Employees,Employee Id = Dropdown2.Selected.EmployeeID)

And in Gallery column i can only select to display Employee Namee field

Thanks.

 

There is no gallery. I just have a drop down and the data source has to be ROTA. I just want to display Name instead of Id.

View solution in original post

Hi@rsanya,

Sorry for the late reply. Considering you have marked solved for the case you proposed, I still want to provide you with a solution that you can refer to as an alternative if it does not overlap with yours.

Allow me to confirm what you're trying to accomplish. Do you want to populate the Dropdown with Employee Name based on the Employee Id in ROTA?

Please check the following formula for reference.

AddColumns(
ROTA,
"Name",
LookUp(Employees, EmployeesId = ROTA[@EmployeeId], EmployeesName)
).Name

 

Best Regards,

Qi

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Check out the Power Apps Community Call for January 2021

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (4,197)