cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
_sourcecod3_
Level: Powered On

Remove dropdown duplicates on editform

Hi,

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.

 

Thanks.

 

5 REPLIES 5
notj
Level: Powered On

Re: Remove dropdown duplicates on editform

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. 
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

_sourcecod3_
Level: Powered On

Re: Remove dropdown duplicates on editform

@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.

 

Thanks

 

notj
Level: Powered On

Re: Remove dropdown duplicates on editform

My response was specifically to your second question regarding showing only options based off a selection.

Community Support Team
Community Support Team

Re: Remove dropdown duplicates on editform

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

 

 

Best regards,

 

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
_sourcecod3_
Level: Powered On

Re: Remove dropdown duplicates on editform

@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).

 

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,273)