I need to include Power App distinct function into this cascade dropdown formula. This is not to repeat same value results.

Column name is Domain_Item

Filter('APSYS Roadmap Master', Domain_1 = Dropdown1.Selected.Result)

could anyone help?

Thanks a million


1 Answer 1


With less information, it seems that you want to use filter funcation first, then use Distinct,if true, we suggest you use following syntax:

Distinct(Filter('APSYS Roadmap Master', Domain_1 = Dropdown1.Selected.Result),xxx)

Similar issue for your reference:


If this is not feasible for you, please provide moren information about your issue such as scrrenshot.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.