Remove dropdown duplicates on editform

(0) Share

Report

Posted on by _sourcecod3_

405

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

notj 782 on at

Like (0)

Report

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

Was this reply helpful? Yes No
_sourcecod3_ 405 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
notj 782 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (1)

Report
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,

Was this reply helpful? Yes No
_sourcecod3_ 405 on at

Like (0)

Report

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

Was this reply helpful? Yes No