cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CanD
Helper IV
Helper IV

Smart Dropdown with Sharepoint - DD with update items

Hello Community,

 

to raise my powerapps skills i created an app, where users can book cars. I created a Sharepoint list with colums like Brand, color and licence plate. In that list i also created some cars. In the app i have a screen with 3 dropdowns.

Now to my question: I want to have 3 smart dropdowns, for example if i choose Audi at brand then in color only the colors (not all-only unique once) of the audi cars should be able to choose. Therefore it have to look at the sharepoint list which car we have. If i choose Audi-black then only the licence plates of my black Audis should be able to choose.

 

I am trying it now for too long, so i hope someone can help me.

 

Thank you really much.

 

Best regards,

CanD

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi@CanD,

Do you want the three Dropdowns options to depend on each other?

Since you have all the three Text columns, I think there is no need to create collections.

Here is a workaround that you can follow.

Add three Dropdowns named "BrandDD","ColorDD","LicensePlateDD".

Set the Items property of the BrandDD as below:

Distinct(Cars,Brand)

Set the Items property of the ColorDD as below:

Filter(Cars,Brand=BrandDD.Selected.Result).Color

Set the Items property of the LicensePlateDD as below:

Filter(Cars,Brand=BrandDD.Selected.Result && Color=ColorDD.Selected.Color).LicencePlate

2020122301Gif.gif

Best Regards,

Qi

 

Best Regards,
Qi

View solution in original post

4 REPLIES 4
v-qiaqi-msft
Community Support
Community Support

Hi@CanD,

Based on the issue that you mentioned,do you want to create cascading dropdowns?

Could you please tell me that:

  1. what is the column type of your columns, are they all Choice or Text?
  2. if the Color is Choice type ,does it allow multi select?
  3. do you use a Combo Box?

Regards,

Qi

Best Regards,
Qi

Hi @v-qiaqi-msft ,

thanks a lot for the answer. The columns are all Text. I don't use combo box. At the moment i only have one list on sharepoint, where all my cars are in it. In the app, i created some collection for example colColor, colCar and so on. I take the informations out of the list with:  "  ClearCollect(ColColor;ColAllCars_SP.Color);;   ". It worked so far, but it shows me everytime all colors. For example. i have one red Audi. If i choose Audi in brand  it only should show me the color red in the dropdowns. If it doesn't work with Text, i could switch to Choice. 

 

Thank you very much for the help.

 

Best regards,

cd

v-qiaqi-msft
Community Support
Community Support

Hi@CanD,

Do you want the three Dropdowns options to depend on each other?

Since you have all the three Text columns, I think there is no need to create collections.

Here is a workaround that you can follow.

Add three Dropdowns named "BrandDD","ColorDD","LicensePlateDD".

Set the Items property of the BrandDD as below:

Distinct(Cars,Brand)

Set the Items property of the ColorDD as below:

Filter(Cars,Brand=BrandDD.Selected.Result).Color

Set the Items property of the LicensePlateDD as below:

Filter(Cars,Brand=BrandDD.Selected.Result && Color=ColorDD.Selected.Color).LicencePlate

2020122301Gif.gif

Best Regards,

Qi

 

Best Regards,
Qi

Hi @v-qiaqi-msft 

sorry for responsing so late. I did not have access to my accounts during christmas. I tested it and it worked more then perfect. Thank you soooo so much for your help 🙏

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,741)