web

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

News and Announcements icon

Power Platform CommunityForums Power Apps create collection filt...

Power Apps

Answered

create collection filtered on created date -31 days

(0) Share

Report

Report

Posted on 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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

C-Papa 1,836 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

dennisb88 603 on at

Like (0)

Report
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 ) )

Was this reply helpful? Yes No
pbaxter 8 on at

Like (0)

Report

@dennisb88 super helpful thanks for the solution!

Was this reply helpful? Yes No

Join the conversation