Answered

Dropdown autoselects value from another collumn of the same sharepoint item based on another dropdown value

(0) Share

Report

Posted on by uraganas

I am building an inventory request list where users can submit a request to provide a new laptop. Available laptop models are based on the department.

I made sharepoint list and creating a custom form with power apps. There are 3 dropdowns:

Department - users select department they work for
Laptop type - user friendly model eg "14' Dell, 16GB RAM"
Model - exact model name

These are cascading dropdowns based on Inventory list that has 3 columns: Department, Friendly-name, Exact Model.

Department in custom form just filters all distinct departments:

Items = Distinct('Inventory', Department.Value)

Laptop type menu is based on the selected department:

Items = Filter('Inventory', Department.Value = DataCardValue5.Selected.Value)

This all works fine the way I wanted. But I cannot figure out how to make Model dropdown autoselect the "Exact Model" value of the same sharepoint item. Eg if user selects "15' Lenovo, 32GB RAM" in Laptop type, the Model dropdown below autoselects the value "LASDF465465" (made it up) from Model field of the same sharepoint item that Laptop type is selected. All Laptop types and models are unique.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @uraganas ,

I am assuming that Laptop column and Model column are all text type, please try this:
Model drop down Items:Distinct('Inventory',Model) Default:LookUp('Inventory',Department.Value=DataCardValue5.Selected.Value&&Laptop=LaptopDropDown.Selected.Laptop,Model)

Best regards,
Rimmon

Was this reply helpful? Yes No
uraganas 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, both columns in sharepoint are single line text type. However, Lookup formula you have offered to use in Default property does not seem to work. It says that LookUp expects record type while "there is an error in your formula says "Data type: text"

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @uraganas ,

Are you using combo box?
Please modify default code and put it on DefaultSelectedItems property:
{Value:LookUp('Inventory',Department.Value=DataCardValue5.Selected.Value&&Laptop=LaptopDropDown.Selected.Laptop,Model)}

Was this reply helpful? Yes No
uraganas 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, this has helped. I did not know the difference between combo box and simple drop down menu, sorry for misleading.

Was this reply helpful? Yes No