I am attempting to get to grips with PowerApps, and this is to be my first app.
I have a DropDown (DataCardValue9) that has the following items:-
Further down my form I have another dropdown and I want this to be populated with manufacturer names based on the value in DataCardValue9.
I have a connection to a SharePoint list called Hardware, which contains just two colums - Manufacturer and Category. It contains the following data:-
Dell Desktop Computer
Dell Laptop Computer
Dell Tablet Computer
Lenovo Desktop Computer
Lenovo Laptop Computer
Samsung Mobile Phone
CAT Mobile Phone
Suppose I choose "Mobile Phone" from the dropdown DataCardValue9, then I want my new dropdown to show just Samsung and CAT as the possible selections. Likewise if I choose "Laptop Computer", then my new dropdown should show just Dell and Lenovo.
How can I achieve this?
We could use the dropdown1 selected value as a filter of the datasource (items property) in your second dropdown.
Just use the data you shared here as an example, assuming we have a table (named table1) with two columns, one for Manufacturer, and another is Category,
The first dropdown is used to select the Category,
Under the items property of the first dropdown, use this formula:
Which would return single Category value for each,
Then under the Items property of your second dropdown, use the formula below:
Further, would you please share more details about the form type you used here?
Follow the article below and see if you need to update any form property:
Post back if you need any further assistance.
Sorry for the confusion, not a normal drop down, but the drop down that comes within the Edit Form. The DataCard does not include an 'Items'. It has DataSource, DataField, Default. There is no Items.
Check it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand