cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Naji1
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:

Naji1_1-1638357787902.png

 

Produkttype:

Distinct( 'Data Source til Bestillingsliste',Produkttype)

Produkt:

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

 

Thanks in advance for help 🙂

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
AmDev
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 👍 

View solution in original post

18 REPLIES 18
AmDev
Super User
Super User

Hi @Naji1 - Hello again! 😊

 

Can you advise what the update property for both these datacards is?

Naji1
Helper I
Helper I

Hi again @AmDev 

Thanks again for reply 😀.

Produkttype:

Naji1_0-1638358343003.png

Produkt:

Naji1_1-1638358370445.png

 

 

 

AmDev
Super User
Super User

Hi @Naji1 

 

Try adding the following to the end of the respective updates:

 

DataCardValue.Selected5_2.Result

DataCardValue.Selected6_2.Produkt(Produkt0)

 

Hope this Helps - Good Luck! ☘

@AmDev Thank you for your reply😀

It gives an error.

 

Naji1_0-1638373075517.png

 

 

AmDev
Super User
Super User

Hi @Naji1 

 

I see from your screen grab earlier, it was refering to a different datacard 'DataCardValue5_2', 

 

AmDev_0-1638376341715.png

 

but the most recent one with the error is 'DataCardValue5_4'

 

Can you double check the control reference in the Produkttype datacard adn see if that helps?

 

 

Hi @AmDev 😀

That is because i have duplicated the screen.   I have deleted The one with 5_2 becuase of some error. This one is the exact same copy of the 5_2 but without errors. Please take a look of the pictures.

 

Naji1_0-1638377419316.png

 

Naji1_1-1638377445913.png

 

AmDev
Super User
Super User

Thanks for the clarification - I was just looking back at the other related post from this morning.

 

What type of column is your product type column? - is it a choice column?

@AmDev You are welcome😀

It is single line of text column. please take a look of the picture below. 

 

Naji1_0-1638380259114.png

 

AmDev
Super User
Super User

Hi @Naji1 

 

If that column is single line text, the items property for that control is Distinct(yourdatasource, Produkttype) and the Update is DataCardValue.Selected#_#.Result - that should work in the update.

 

The only other thing I notice is you have entered '.result' instead of '.Result' when you tried that. Can you check again with DataCardValue#_#.Selected.Result?

 

AmDev_0-1638384080993.png

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,337)