Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

cascading dropdowns does not save data to sharepoint lists

Hi Everyone 🙂


I have made an app for ordering IT equipment for our employees But when i submit for every things works fine except the 2 cascaded dropdowns.  It does not save the data to sharepoint. 


I cascaded followoing 2:




Distinct( 'Data Source til Bestillingsliste',Produkttype)


Filter('Data Source til Bestillingsliste', Produkttype = DataCardValue5_2.Selected.Result)


Thanks in advance for help 🙂





God Morning @AmDev  😀

It still gives an error. please take a look of both pictures.


I think i am not able to give you the right info you need because compeletly new her.  Let me explain a little more. 

I have 2 lists:

First list where are all the items are and both column "Produkttype" and "Pordukt" ares single line text columns.

The second list where it saves all the data when employee submit a form is of a choice column(both "Produkttype" and "Produkt")

I don't know if it makes difference. 😀 












Super User
Super User

Hi @Naji1 - Good afternoon now 🙂


Yes that makes a difference - When you say it is a choice field are the choices being taken from your single line text columns in the first list (i.e. are these 'lookup' type columns to the first list) - or are they 'choice' columns with choices manually entered like this:




@AmDev Thanks for you reply and for your patience😀.

The first list is which i use to distinct item from.  Where i click on new button to add the new items.(picture please).



The second list where columns are of "Choices" are the same as you send me the picture.  Which is also my data source to save the data of the submitted form. (picture below please). 



Do i need to have items on the second list(where form saves the data) or it is enough to have data on only Distinct list?    If only distinct list is enough for items then should i make the column(Produkttype and Produkt) in the second list (data saving list) a single text entry instead of choieces?

Once again thanks 😀

Super User
Super User

Hi @Naji1 - no problem at all.


Can you try the following in your items property:


 - RenameColumns(Distinct('Data Source til Bestillingsliste',Produkttype), "Result", "Value")


And the following in your datacard update:


 - DataCardValue5_4.Selected


Let me know how you go

@AmDev  Thanks😀

Now produkttype  is saving data to sharepoint list but not "Produkt".  Do i need to do some changes in this as well?



Super User
Super User

Good stuff... can you send through the current code in the items property for the Produkt drop down?

Hi igen with good news @AmDev 😀

I have converted the Produkttype and produkt column from choice to single text and after wards used Distint and filter respectivly and it works now.  

I say thank you very much for all the help you provide.

Should i mark my reply as solution or one of you reply as solution?




Super User
Super User

Hi @Naji1 - Great work and Glad you got that working.


I'll leave it up to you to decide where to mark the solution 🙂


Important thing is you now have it working - well done 👍 

Thanks @AmDev 😀

I marked your reply as solution because it was you who pointed it out that choice column and single text column makes differences.  

Thanks Alot and see you with another😀

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,268)