Power Apps set a dropdown value based on variable

(0) Share

Report

Posted on by HM-22080408-0

Hi Members,

I have a requirement in Power Apps where I want to set a dropdown value based on a variable.

Scenario:

I have two SharePoint lists Company details and Employee Details. The company details list includes all departments. The employee details list will save all details of the employees with their department.

In Power Apps, there are Text input control, a search icon, and a Dropdown control.

If the user enters the Employee ID in the text input control and clicks on the search icon.

The employee ID will be fetched from the Employee details SharePoint list and displayed in their department in the dropdown control.

In the Search icon button, I have set a variable as

Set(varEmp,TextInput1)

Variable Error.jpg

Then in the Power Apps dropdown control, Items property, I have put the below code:

)
If(
 IsBlank(varEmp),
 Distinct(
 'Company Details',
 Name
 ),
 (LookUp(
 'Employee Details',
 TextInput1 = varEmp
 ).Department)
)

Variable Error2.jpg

But, I was facing an issue like, the dropdown control value was fetching only SharePoint list 1st value as IT.

For example, If I give the Employee ID = TS763 and click on the search icon the dropdown value will be fetched as IT only.

Variable Error3.jpg

But the Employee ID TS763, is belongs to the marketing department.

Variable Error4.jpg

I need the dropdown item should be selected based on the Employee ID.

Can anyone please suggest how I can resolve this? Thanks in advance!

Categories:

Connecting to Data

Connectors

Using Apps Using Formulas

I have the same question (0)

All responses (6)

Answers (0)

BrianS 2,407 Super User 2024 Season 1 on at

Like (1)

Report

Re: Power Apps set a dropdown value based on variable

You want the Items list to be the full list of Departments and the Default value for display is the ThisItem property. That way you will have the correct display, but be able to select others.

Was this reply helpful? Yes No
Hema123 7 on at

Like (0)

Report

Re: Power Apps set a dropdown value based on variable

No, I need my dropdown value should be selected based on the Employee ID.

I need to set the variable in the search button.

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

Re: Power Apps set a dropdown value based on variable

If you are returning only the single value for the Employee, why are you using a Drop-down control? If you only want one value a label will be all you need. It looks like your code returns a table for the True Value and a single test item for the False Value. Also your Lookup is probably returning the first record because your formula is true. Don't you want the Lookup to be Lookup('Employee Details', varEmp=EmployeeID).Department?

Was this reply helpful? Yes No
Hema123 7 on at

Like (0)

Report

Re: Power Apps set a dropdown value based on variable

Hi @BrianS Thanks for your reply. I think nearly there. Still getting below warning. How do we solve this please?
And the dropdown control doesn't show me any value

Was this reply helpful? Yes No
NPPlatform 606 Moderator on at

Like (0)

Report

Re: Power Apps set a dropdown value based on variable

@Hema123 The warning tells you that you are trying to compare a boolean (yes/no-field) with a text-field. Apparently varEmp can only be yes or no. If you want to use it in your lookup to compare with an ID, you'll have to change your variable to contain the ID.

___________________________

If this solved your problem, please consider marking it as the solution.

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

Re: Power Apps set a dropdown value based on variable

You may be using varEmp in another part of your app. There is a search function now on the left hand pane. You can search for all occurrences of the variable and fix one if it's a Boolean

Was this reply helpful? Yes No