Filter for Distinct

(0) Share

Report

Posted on by joel914823

557

Hello,

I have a Clear Collect function in my on start on my app. I have a column in the collection called 'UniqueIssues' so thought I could improve the on start by only clearing the Distinct values in my 'UniqueIssues' column. I am having a hard time adding this to the below formula. Any help is appreciated.

ClearCollect(Issues,Filter('Issue tracker', Operations.Value="Centralized Services" && Created >= DateAdd(Today(),-1,TimeUnit.Days)))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Joel,

The formatting would be something like this I think:-

ClearCollect(Issues,Distinct(Filter('Issue tracker', Operations.Value="Centralized Services" && Created >= DateAdd(Today(),-1,TimeUnit.Days))),DistinctValue)

Was this reply helpful? Yes No
joel914823 557 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sickle-Cell I tried to enter this but the DistinctValue part does not populate.

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @joel914823

Try this,

ClearCollect(
Issues,
Distinct(
Filter('Issue tracker', Operations.Value="Centralized Services" &&
Created >= DateAdd(Today(),-1,TimeUnit.Days)
),
UniqueIssues
)
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Joel,

Sorry I wasn't clear. The DistinctValue part will be the column of data you want to return values for. In your case, replace DistinctValue with UniqueIssues 🙂

Was this reply helpful? Yes No