Unanswered

cascading dropdowns does not save data to sharepoint lists

(0) Share

Report

Posted on by 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 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (1)

Gerard Simpson 2,987 Moderator on at

Like (0)

Report

Hi @Naji1 - Hello again! 😊

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

Was this reply helpful? Yes No
Naji1 46 on at

Like (0)

Report

Hi again @AmDev
Thanks again for reply 😀.
Produkttype:
Produkt:

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

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! ☘

Was this reply helpful? Yes No
Naji1 46 on at

Like (0)

Report

@AmDev Thank you for your reply😀
It gives an error.

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

Hi @Naji1

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

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?

Was this reply helpful? Yes No
Naji1 46 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Naji1 46 on at

Like (0)

Report

@AmDev You are welcome😀
It is single line of text column. please take a look of the picture below.

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Naji1 46 on at

Like (0)

Report

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

Was this reply helpful? Yes No