cascading dropdowns does not save data to sharepoint lists

[Naji1]

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:

Produkttype:

Distinct( 'Data Source til Bestillingsliste',Produkttype)

Produkt:

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

Thanks in advance for help 🙂

[Naji1]

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. 😀 

[AmDev]

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:

Thanks

[Naji1]

@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 😀

[AmDev]

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

[Naji1]

@AmDev  Thanks😀

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

Regards😀

[AmDev]

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

[Naji1]

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?

regards

naji

[AmDev · Accepted solution]

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 👍 

[Naji1]

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😀