-1

I want to get distinct value in PowerApps where Active (choice column)="Yes", trying below but I am not getting correct value it returns false value:

Distinct(Filter(Splist, Active =true),'spsinglelinetextcolumn')
Improve this question

2 Answers 2

Reset to default
-3

Try it in below format:

Distinct(Filter(DataSource, Condition),ColumnToBeSelected)

Source: Distinct values on a filtered drop down.

Example:

You have data source, SPList and a choice column (Active) with text value of Yes. Then you can use it something like below:

Distinct(Filter(SPList, Active = "Yes"), ColumnToBeSelected)

official documentations:

  1. Distinct function
  2. Filter function
Improve this answer
2
  • It's the same formula in the question, what's the new in your answer? How is it accepted? 😮
    – Miguel Isidoro
    Commented Dec 23, 2019 at 6:42
  • 3
    Are you serious? It's clear, the user don't need to know the formula syntax, he already knows it and the evidence is it is written in his question with the correct parameters , but his problem was in the condition logic! you didn't point him to this point, so you didn't add something new! It's not considered an answer to the question! 😑 How is it accepted 🌚
    – Miguel Isidoro
    Commented Dec 23, 2019 at 7:01
1

Resolved.

I just needed to use <> instead of =.

Improve this answer

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.