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
List-2
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.
