
Hi Folks,
I am new to the power apps; I have a situation when a user selects a value from the drop-down list (name called Subcategory) that value won't be present again when the user selects the drop-down list.
I have a SharePoint list that includes Category, Subcategory, and other fields. The Category and Subcategory fields are used as a dropdown list, the cascading filter.
Below are the column details.
Before Selection,
| Category | Subcategory |
| A | AB |
| A | BA |
| B | CA |
| B | DA |
| C | EA |
After Selection,
| Category | Subcategory |
| A | BA |
| B | CA |
| B | DA |
| C | EA |
Can anyone help me on this.
Thanks in Advance