Distinct function

Question

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

Jose

Julie_MSFT · Accepted Answer · 2021-03-03 07:48:52Z

0

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.

answered Mar 3, 2021 at 7:48

Julie_MSFT

4,2671 gold badge5 silver badges11 bronze badges

Julie, thanks for your reply. What do XXX references to?
– Jose1978
Commented Mar 3, 2021 at 7:54
This is the column that you want to show in Distinct function, such as Distinct( CityPopulations, Country ) in Microsoft article:docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/…
– Julie_MSFT
Commented Mar 3, 2021 at 8:02
Thanks a million Julie! you are star! it worked
– Jose1978
Commented Mar 3, 2021 at 8:33

Add a comment |

1 Answer 1