cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Praful_Soni
New Member

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
Anonymous
Not applicable
2 REPLIES 2
Anonymous
Not applicable

Bumping for visibility 

 

@Anonymous 

Anonymous
Not applicable

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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.

Users online (4,876)