Cascading dropdowns against CDS

(0) Share

Report

Posted on by JohanF

Hi! I need help. I'm trying to setup a cascading dropdown against CDS.

I followed a guide and it workt against Sharepoint but not CDS:

https://www.youtube.com/watch?v=pkZG2boN7jQ

I have a list called Maskin and one called kund. All list i have are lookups through a list called tillverkning.

Items:

Distinct(Maskiner;Maskin)

Distinct(Filter(Tillverkning.Maskin.Maskin = ComboBox1.Selected.Result);Kunder.Kund)

What am i doing wrong? 🙂

See attached files.

Categories:

Microsoft Dataverse with Power Apps

powerapps 1.JPG

kund.JPG

maskiner.JPG

I have the same question (0)

All responses (7)

Answers (1)

Joel CustomerEffective 3,224 on at

Like (1)

Report

I misread your question in my original answer

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

Like (1)

Report
Hi @JohanF ,

Could you please try with this?

Distinct(Filter(AddColumns(Tillverkning;"NewKund"; Kund.Kund;"NewMaskin";Maskin.Maskin);NewMaskin = ComboBox1.Selected.Result);NewKund)

Hope this helps.

Sik

Was this reply helpful? Yes No
JohanF 17 on at

Like (0)

Report

Thank you for the replay.
I now can select the right value! thats great 🙂

But when selected the value in combobox1 (maskin) and the combobox2 (kund) and press the submitform button the data is only saved in maskin list.
i want it to save in the tillverkning list.
is that possible?

See attached file!

tillverkning valu...

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

Like (0)

Report
Hi @JohanF ,

What is the data source of Form?

What do you want to save to tillverkning list?

Could you please share some example?

If you means save the two combobox selections to a new record of tillverkning list, please try to apply this to OnSuccess property of Form.

Patch(Tillverkning, Defaults(Tillverkning),{Name:"Test", Kund: LookUp(Kund,Kund=ComboBox2.Selected.Result), Maskin: LookUp(Maskin, Maskin=ComboBox1.Selected.Result )})

Hope this helps.

Sik

Was this reply helpful? Yes No
JohanF 17 on at

Like (0)

Report

That was exactly what i was asking for 🙂
But when i add that to Onsuccess it doesen't work.

Error code:
unexpected sign. The character is used unexpectedly in the formula

Se attached file.
Thank you very mutch for the help so far 🙂

Best regards
Johan

tillverkning.jpg

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (0)

Report
Hi @JohanF ,

Please try this, the operator should fit your localization.

Patch(Tillverkning; Defaults(Tillverkning);{Name:"Test"; Kund: LookUp(Kund;Kund=ComboBox2.Selected.Result); Maskin: LookUp(Maskin; Maskin=ComboBox1.Selected.Result)})

Hope this helps.

Sik

Was this reply helpful? Yes No
JohanF 17 on at

Like (0)

Report

Hi again!
i tried that but it diden't work. 🙂

i changed back to the first setup we used were i can select the Maskin and then get the right value in kund.(but it doesn't save too tillverkning)
i tried adding a form and pointed that to tillverkning and after that change the items for Maskin and kund. (See pics)
But i get a error.

the value needs to be an entity post

Was this reply helpful? Yes No