Power Apps question:

Input: Our SharePoint list:

Team InvoiceNumber
Microsoft 2002
Microsoft 2002
Google 2003
Google 2003

There could be few records in the table related to 'InvoiceNumber'.

1st of all, what I already did, so you could see the whole picture. On startup screen I use function: Sort(Distinct(Table01,Team),Result,Ascending).

Result is:


Then, there is a arrow button with: Set(VariableTeam, ThisItem.Result); Navigate(Screen1)

On 'Screen1' a gallery:

Filter(Table1, Team = VariableTeam)

Result is (if we make transition from Microsoft):



How to combine Distinct function with my filter to see "InvoiceNumber" as unique entry in App?

1 Answer 1


Use this formula in Power apps:

Distinct(Filter(Table1, Team = VariableTeam), InvoiceNumber)

Documentation: Distinct function in Power Apps

  • 1
    Damn, I didn't expect it's going to be that simple, cuz I started to combine two formulas into something weird. Thanks a lot! Solved. Nov 10, 2022 at 9:08
  • Great, glad it worked for you! Nov 10, 2022 at 10:13

Your Answer

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

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