Remove dropdown duplicates on editform

Like (0) Share

Report

Posted on 30 Oct 2019 20:49:35 by _sourcecod3_

401

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.

Categories:

General Questions

All responses (5)

Answers (0)

_sourcecod3_ 401 on 31 Oct 2019 at 17:17:34

Like (0)

Report

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).
v-yutliu-msft on 31 Oct 2019 at 09:32:39

Like (1)

Report
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,
notj 780 on 30 Oct 2019 at 21:13:33

Like (0)

Report

Re: Remove dropdown duplicates on editform

My response was specifically to your second question regarding showing only options based off a selection.
_sourcecod3_ 401 on 30 Oct 2019 at 21:09:36

Like (0)

Report

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 780 on 30 Oct 2019 at 20:58:42

Like (0)

Report

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