Collections

(0) Share

Report

Posted on by RvdHeijden

602

Hey guys, can you help me out with this one

ClearCollect(collectHoofdprojecten; {Result: "Alle projecten"});;
Collect(collectHoofdprojecten;Distinct('Voorraden Logistiek'; Hoofdproject.Value));;
ClearCollect(collectDatumTelling; {Result: "-"});;
Collect(collectDatumTelling;Distinct('Voorraden Logistiek';('Datumtelling'))

Can you tell me why the first Collection works and the second one doesn't ?

Im guessing it has something to do with de last part of the formula because I want a collection based on a Date column (='Datumtelling') Basically it goes wrong in the last part from the part that i use Distinct.

Ive already tried some variations such as...

ClearCollect(collectDatumTelling; {Result: "-"});;
Collect(collectDatumTelling;Distinct('Voorraden Logistiek';(DateValue('Datum telling')))

But that doesn't work, can someone help me out here ?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RvdHeijden You don't need the first ClearCollect. Just do this,

ClearCollect(collectDatumTelling;Distinct('Voorraden Logistiek';'Datumtelling')
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RvdHeijden :

The point is that "-" is a string but Datumtelling is a date column, two different data type that can not be in one property.

Please try:

ClearCollect(collectDatumTelling; {Result: "-"});;
Collect(collectDatumTelling;Distinct('Voorraden Logistiek';Text(('Datumtelling')))

Best Regards,

Bof
RvdHeijden 602 on at

Like
a
(0)

Report
Copy link

Link copied!

The first (red) ClearCollect is to set the dropdown tot a standard value, in this case the "-".
The first (red) Collect is to set up the collection

The green lines are to set up a different Collection, i saw this formula on YouTube and it works
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RvdHeijden :

Have you tested this formula, it should work:

ClearCollect(collectDatumTelling; {Result: "-"});;
Collect(collectDatumTelling;Distinct('Voorraden Logistiek';Text(('Datumtelling')))

Best Regards,

Bof