Answered

Drop Down Menu

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Guys,

I have an table called DimCostCenter. This table include 3 columns see attachment. In my PowerApps as you can see i have a Drop Down Menu which is included the CostCenter column.

My Question is how can i achieve for example if i choose 1100~~Pre Sales that only the number 1100 will be insert in my employee table. So each item i choose only the column CostCenterID will be inserted instead of column CostCenter.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

SanchezITM 153 on at

Like (0)

Report
Copy link

Link copied!

LookkUp(DimCostCenter;CostCenter=DropDownMenuName.Selected.Value;CostCenterId)

Was this reply helpful? Yes No
BenFetters on at

Like (0)

Report
Copy link

Link copied!

Hello,
If all of your ID's are only 4 digits and are at the beginning, you could use the left function to get the first four numbers of the drop down's selected value.

Does that make sense?
Hope that helps!

Ben

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @BenFetters @SanchezCSG ,

Thank you guys! I solved my problem with this formula. The Item property of Drop Down Menu is: ShowColumns('[isl].[DimCostcenter]',"CostCenter","CostCenterId")

And the Update property of the card is: Dropdown5_6.Selected.CostCenterId

Was this reply helpful? Yes No