I'm working on an app to track deliveries to restaurants. One of my columns is the name of the restaurant, which has duplicates, and the others are the items that are needed to be delivered to those restaurants.
My question is how can I remove the duplicates on my dropdown1 inside the editform? my second question is, how can I show specific items depending on the choice in the first column? Example:
If I select restaurant1 from dropdown1, populate specific items needed to be delivered that pertain to only that restaurant.
Wherever you're storing that information, I would bring it into a collection and then use a Gallery to display that collection. Use the Search function to display only items where your Restaurant column = dropdown Restaurant.
@notjthanks for your response. Maybe I didn't explain my situation correclty. This app would have three dropdowns.
dropdown1: select a restaurant (I need to be able to remove duplicates).
dropdown2: display the location of the restaurant
dropdown3: display the items for the two above selections.
This data will be displayed in a gallery.
Hi @_sourcecod3_ ,
1)Could you tell me the data type of restaurant field?
I suggest you try Distinct function, which is used to display no-duplicate data.
If it is a text type, try to set the drop down's Items:
Distinct(tablename,restaurant field) //please replace with your tablename, fieldname
2)Do you want to filter items in drop down 3 based on the selection of drop down 1 and drop down 2?
Could you tell me the data type of restaurant and location field?
I assume that they both are text type.
Then please set the drop down 3's Items:
Filter(tablename,restaurant field=drop down1.Selected.Result,location field=drop down2.Selected.Value)
Please note that :
1)the reason why I use drop down1.Seleccted.Result to represent the selection of drop down 1 is that Distinct function will return a column named Result.
2)if you set drop down2's Items to : tablename.location field name
I suggest you use drop down2.Selected.Value.
If you set drop down's Items to tablename, Value to location field name
I suggest you use down2.Selected.location field name
@v-yutliu-msftThe data type for restaurant and location are just single line of text.
These items are in an editform when a user is submitting an item. I want to be able to remove the duplicates from dropdown1, when an item is selected in dropdown1, filter items on dropdown2 (both Single Line of Text).
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