Smart Dropdown with Sharepoint - DD with update items

(0) Share

Report

Posted on by CanD

183

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi@CanD,
Based on the issue that you mentioned,do you want to create cascading dropdowns?
Could you please tell me that:
what is the column type of your columns, are they all Choice or Text?
if the Color is Choice type ,does it allow multi select?
do you use a Combo Box?
Regards,
Qi

Was this reply helpful? Yes No
CanD 183 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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
Best Regards,
Qi

Was this reply helpful? Yes No
CanD 183 on at

Like (0)

Report
Copy link

Link copied!

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 🙏

Was this reply helpful? Yes No