web

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

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps create collection filt...

Power Apps - Building Power Apps

Answered

create collection filtered on created date -31 days

Like (0) Share

Report

Report

Posted on 7 Apr 2021 10:18:19 by dennisb88

603

Hi all,

A short question, I've in my onvisible settings a clear collect where I'm collection all the records that are not older then 31 days.

To achieve that I've build the follow code:

ClearCollect(
 Col_Myhours,
 Filter(
 registration,
 User = Var_User, Created >= DateAdd(
 Today(),
 -31,
 Days
 )
 )
)

It works fine, my collection is filled. But it's give me the error: "Date add function cannot be blank".

I didn't know what/ where the issue is.. Does anyone know what's wrong?

Regards,

Dennis

All responses Img

All responses (3)

Answers Img

Answers (2)

pbaxter 8 on 21 Jul 2021 at 19:28:35

Like (0)

Report

Re: create collection filtered on created date -31 days

@dennisb88 super helpful thanks for the solution!
Verified answer

dennisb88 603 on 07 Apr 2021 at 11:37:10

Like (0)

Report
Re: create collection filtered on created date -31 days

Hi @C-Papa , thank you for your reply.

You're suggestion was the right one! Thanks!

The correct formula:
Set( var_date, DateAdd( Today(), -31, Days ) ); ClearCollect( Col_Myhours, Filter( registration, User = Var_User, Gemaakt >= var_date ) )
Verified answer

C-Papa 1,836 on 07 Apr 2021 at 11:22:16

Like (0)

Report

Re: create collection filtered on created date -31 days

Try setting the date add value in a variable and using the variable in the formula