cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Praful_Soni
Level: Powered On

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

I know that this may be a repetitive question. But this is something strange.

 

Issue: I have 2 dropdowns and i have make them cascading dropdown so i can filter child dropdown based on parent dropdown value. I can successfully filter out data in child dropdown and it is working fine in NewForm but in EditForm when i change the parent dropdown it not clearing the pre-selected data.

 

Implemented:

I have 2 custom lists. 1st list for "Product Categories" and 2nd for "Product Types". I have used "Product Categories" list's column in "Product Types" list to map the data.

 

List-1

1.jpg

 

List-2

2.jpg

 

Now, i have my main list called "Customers" and in this list i have 2 lookup columns, 1st called "Product Category" from "Product Categories" list and another lookup column (Allow multiple selection) for "Product Types" from "Product Types" list.  

I have customized powerapp form and successfully created cascading dropdown. So, when user select Product Category he can have multiple options to choose Product Types. Also, in NewForm when user change the "Product Category" i have reset the "Product Types" dropdown (onChange > Reset(ProductTypes)) and its working nice.

The issue is when i create a new item using NewForm its working fine but when i open the same item in EditForm and i change the "Product Category" it not clear the values in "Product Types". If i change the "Product Category" it showing options relatively but not clearing previous options.

 

Is there any way to solve this out? Please let me know because it is very  strange.

 

It would also be fine if i can achieve the functionality with another approach. Your suggestions are welcome.


Thanks a lot.

1 ACCEPTED SOLUTION

Accepted Solutions
chntnu
Level: Powered On

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

2 REPLIES 2
TopShelf-MSFT
Level 10

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

Bumping for visibility 

 

@TopShelf-MSFT 

chntnu
Level: Powered On

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,437)