web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps undefined

Power Apps

Unanswered

undefined

(0) Share

Report

Report

Posted on by Moira0509

150

I am trying to use formula like:

ClearCollect(colSolution,Distinct(colsolution,Level))

But Only level of colsution is being colllected. Other item are not collected.

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Moira0509 ,

That is because you are using the Distinct function, which returns a single column table of unique values in the selected column, in this case Level.

Please describe what you wish to achieve in order to find the solution for the issue.
Moira0509 150 on at

Like
a
(0)

Report
Copy link

Link copied!

I am using this for the collection
ClearCollect(colShiftRollouts,
Sort(Filter(colShiftRollouts,RollOutDate=Today()),RollOutDate,SortOrder.Ascending),
Sort(Filter(colShiftRollouts,Month(RollOutDate)=Month(Today()),Year(RollOutDate)=Year(Today())),RollOutDate,SortOrder.Ascending),
Sort(Filter(colShiftRollouts,RollOutDate< Date(Year(Today()),Month(Today()),1)),RollOutDate,SortOrder.Ascending)
);

but it is creating a double value of the collection.
How to stop repetition of value
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Moira0509 ,

Can you please describe what you want to achieve. For instance: Only save the items in colShiftRollouts with a RollOutDate that is equal to or less than the current month.

This translates to the below formula:

ClearCollect(colShiftRollouts, Sort(Filter(colShiftRollouts,RollOutDate<= Date(Year(Today()),Month(Today()),1)),RollOutDate,SortOrder.Ascending) );

Join the conversation