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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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