Unanswered

SharePoint PowerApps Cascading dropdown reset child dropdown items in EditForm not working

(0) Share

Report

Posted on by kagsch

I have a similar issue like his one but the accepted solution is for new items and my issue is with editing items:

https://powerusers.microsoft.com/t5/Building-Power-Apps/SharePoint-PowerApps-Cascading-dropdown-reset-child-dropdown/td-p/336319

In my sharepoint form I have dropdown 1 and the items in dropdown 2 are filtered depending on the selection in dropdown 1. Only one item can be selected.

I want to reset the selected item in dropdown 2 if the selected value in dropdown 1 changes. This works fine in the powerapps preview or when creating a new item: when I change the selection in the parent dropdown, the child dropdown is reset. But when editing an item, the child dropdown does not reset.

The onchange property in the parent dropdown is:

UpdateContext({ResetDropdown: true});

UpdateContext({ResetDropdown: false})

The Reset property in the child dropdown is: ResetDropdown

The default property of the Child datacard is: ThisItem.Sharepointcolumnname

Any suggestions are very welcome. Many thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kagsch ,

Have you tried resetting the drop-down directly?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
kagsch 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
I am new to powerapps - how do you mean reset the drop-down directly?

Was this reply helpful? Yes No
WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kagsch ,

Instead of

UpdateContext({ResetDropdown: true});

just put (replace with your DD name)

Reset(YourDropDownName)

and it will reset to its Default value.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
kagsch 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Unfortunately that also didn't work.
Could it be due to the Default property? It refers to the SharePoint column:

Was this reply helpful? Yes No
WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@kagsch ,

It does work - it is just that it is resetting the control to the SharePoint field, which is the Default (which is what your code probably does as well). Are you trying to clear the control? If so, keep the Variable, but instead of putting it on the Reset, put this in the Default

If( ResetDropdown, Blank(), ThisItem.PrimaryTopic )

then reset directly.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No