Radio button to filter dropdown choices

(0) Share

Report

Posted on by MooseBot88

168

I am new to designing an app and is building an app to monitor trailers moving from site to site.

I have a list of trailer names and then a column called status

Site A - Bay 1

Site A - Bay 2

Sita A- Bay 3

Site B - Bay 1

Site B - Bay 2

Site B - Bay 3

Site A - Yard

Site B - Yard

Transfer from Site A to B

In the drop down I can have either of these options but I have alot more sites and alot more transfer status's

What I want is a radio box to filter these choices for a combo box

My combobox currently recalls the current record, so if the trailer is already on Site A - Bay 1 is should remain that.

Also I need to ensure that if a trailer is on a bay then also another trailer can't be put on the same bay but for any Yard or transfer status's this is okay to have more than one.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @moosebot88

You have to use the Dependent dropdown concept. I recommend referring to MS Article
Make sure reset control when a dropdown changes

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report

So I have read the article, I am unable to split the status into two columns due to a status being "Transfer from Site A to Site B" status but could add another column called site in the table where the status's are held.

Could I then use a lookup to find all the status in column which match the site in another column.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

That's a good idea to have another column and will be used to filter data easily.

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report
I've set the first drop down box as
Distinct(tbStatus,site)
I just don't know how to reference the 2nd dropdown to see the first dropdown and lookup and also to load this as what is currently selected for the first dropdown.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @moosebot88

Set the 2nd Dropdown items property to
Filter(tbStatus, status = Dropdown1.Selected.Result).ColumnName

To understand better, I have taken the MS example which is location and department

Dropdown1 (LocationDropdown) items property to
Distinct(Locations,Location)

2nd Dropdown (DepartmentDropdwon) items property to
Filter(Locations, Location = LocationDropdown.Selected.Result).Department

Few other things based on my data source (Please update yours)
Set the Update property of the Datacard
Location --> LocationDropdown.Selected.Result
Department --> DepartmentDropdown.Selected.Department
AllowEmptySelection - True
Set OnChange property of Location to Reset(DepartmentDropdown)

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report
Hi,

The second dropdown doesn't populate any details

My second dropdown box items property currently is
Filter(tbStatus, status = Dropdown1.Selected.Result).status
my first dropdown box is called Dropbox1, the second one called DataCardValue16

it should populate the data from my tbStatus table which has two columns

status,site
site a bay 1, site a
site a bay 2, site a
site b bay 1, site b

This should then update my table called tbMain with a column also called status.

Probably confused myself aswell as you. Thank you for your help, I feel like I am nearly there.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @moosebot88

Need to filter Site
Filter(tbStatus, site = Dropdown1.Selected.Result).status

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report

I have it working except what would I put so it shows on the form what is currently selected?

I know I have to change the default property.

Thanks for your help

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @moosebot88

Set the default property of Dropdown to
Parent.Default

Make sure to set Update property Datacard for form save
Site -->
Dropdown1.Selected.Result
For Status
Dropdowns.Selected.status

Example (Showing Update property)

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report

I am only updating one datacard as only updating one field in my main table. So I think the issue is with the first dropdown box looking at site.

Was this reply helpful? Yes No