web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Cascading dropdowns ag...
Power Apps
Unanswered

Cascading dropdowns against CDS

(0) ShareShare
ReportReport
Posted on by 17

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.

I have the same question (0)
  • Joel CustomerEffective Profile Picture
    3,224 on at

    I misread your question in my original answer

  • v-siky-msft Profile Picture
    on at

    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

  • JohanF Profile Picture
    17 on at

    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!

     

  • v-siky-msft Profile Picture
    on at

    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

  • JohanF Profile Picture
    17 on at

    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

  • Verified answer
    v-siky-msft Profile Picture
    on at

    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 

  • JohanF Profile Picture
    17 on at

    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

    F1.pngf2.pngf3.pngf4.png

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 802 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 273

Last 30 days Overall leaderboard