Unanswered

select Id column in variable when select name from dropdown

(0) Share

Report

Posted on by Community Power Pla...

I have two entity Chemical and Lab and have two dropdown. Chemical table have (Chemical_Id and Chemical Name) and Lab table have (Lab_Id and Lab_Name).

dropdown1 showing Chemical name and dropdown2 showing Lab_Name.

Here I want to set Chemical_Id into variable(varchemical) when I select Chemical_Name from dropdown1.

and I want to set LAB_Id into variable(varLab) when I select LAB_Name from dropdown2.e

and both variable will be send to Secondscreen on button click and both variable will be use to filter collection(chemicalorder).

Please suggest.

Regards,

Lalit Kadam

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

eka24 20,923 on at

Like (0)

Report

Here I want to set Chemical_Id into variable(varchemical) when I select Chemical_Name from dropdown1.
Set(varChemical_Id ,LookUp(Chemical,Chemical_Name=Dropdown.Selected.Value,Chemical_Id)
Then use the variable: varChemical_Id

I want to set LAB_Id into variable(varLab) when I select LAB_Name from dropdown2
Set(varLAB_Id ,LookUp(Lab,LAB_Name=Dropdown.Selected.Value,LAB_Id)
Then use the variable: varLAB_Id

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Hi @Anonymous,

set Dropdown1.Item: Chemical

set Dropdown2. Item: Lab

set Button.OnSelect: Set(varchemical, Dropdown1.Selected.Chemical_Id); Set(varLab, Dropdown2.Selected.LAB_Id)

Then you are able to apply both variables into Filter function.

Sik

Was this reply helpful? Yes No