Answered

Using a Dropdown to Filter Selections Available From Another Dropdown Within a Form

(0) Share

Report

Posted on by Holland_Joshua

Hello everyone!

I currently have a form which features a dropdown for a selection of building numbers and a later dropdown to select a device tag.

My hopes is to have that once a building number is selected, the device tags within this building will be the only ones that appear in the later device tag dropdown.

The dropdown box for the Building Number selection is DataCardValue14

The dropdown box for the Device Tag selection is DataCardValue6

A building example value is "B01"

Device tags for this building all start with "23-" (the rest is 3 digit numbers that vary)

This pattern continues so that "B03" tags start with "22-" (3 digit numbers which vary)

The building and beginning of tags don't correlate although I know which building has which tag beginning

Could anyone please offer assistance, any help would be incredibly appreciated. Thank you very much.

Kind regards,

Joshua.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

MJ84 263 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi - try creating a collection I've made one that runs onstart of the app

Then you can set your collection as the item property for your building drop down as below (selecting "building" as the value in properties on right hand side)

Editted sorry made a mistake -Finally in the items property for the device tag drop down use the following to filter

Was this reply helpful? Yes No
Holland_Joshua 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello MJ84.

Thank you so much for your quick response and seemingly excellent solution.
I am having an issue you could possibly help me with though?

My device tag is prompting me to select the building number again, like so:

Here are my code lines:

App On Start

Building Dropdown Items

Device Tag Dropdown

Thank you once again.

Was this reply helpful? Yes No
MJ84 263 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi - in the properties for the device tag dropdown set the Value to DeviceTag

Hopefully this should do it 🙂

Was this reply helpful? Yes No
Holland_Joshua 77 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello.

Apologies for the delay in response. This has worked perfectly. Thank you very much.

Was this reply helpful? Yes No
MJ84 263 on at

Like
a
(0)

Report
Copy link

Link copied!

No problem 🙂 good luck!

Was this reply helpful? Yes No
Holland_Joshua 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi MJ.

With this method is it possible to have multiple DeviceTags per Building. I've tried this there with comma separated values under device tag although to no avail.

Many thanks.

Was this reply helpful? Yes No
MJ84 263 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello below is the syntax you need for the onstart.

If you look at the collection after doing the above you will see this.

BUT I'll pre-empt the next issue! If you now go to your building drop down you will have two different B01's to select which is a bit annoying.... To get around this you can use the Distinct function in the building drop down items property ----- So change the items property in your building dropdown from ColBuilding to

This will break you device tag dropdown so you will need to change the item property of the device tag dropdown to

Hope this helps

Was this reply helpful? Yes No
Holland_Joshua 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello MJ and All.

Unfortunately I think the scale of my device tags is too large. I've read that PowerApps collections can only contain up to 2000 rows. There are 4000 Devices all in. These tags do exist in a choice field in my Microsoft List. Would it be possible in my form to have it so that If dropdownBuilding = example building, limit dropdownDecviceTag to example sample of tags? I'd expect to write a few if statements if this were the case but that's okay. I really appreciate the on going support. Thank you

Was this reply helpful? Yes No
MJ84 263 on at

Like
a
(0)

Report
Copy link

Link copied!

When you say microsoft list do you mean Sharepoint list?

Was this reply helpful? Yes No
Holland_Joshua 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No