Displaying items that were created last month in powerapps

Like (0) Share

Report

Posted on 6 Sep 2022 17:49:07 by KDAI

166

I am trying to display the count of items that were created last month lets say now August 2022.

here is my code

With(
{
StartDate: Date(
Year(Today()),
Month(Today()) - 1,
1
),
EndDate: Date(
Year(Today()),
Month(Today()),
1
) - 1
},
ClearCollect(
collcreatedlastmonth,
Filter(
'mylist',
Created >= StartDate,
Created <= EndDate
)
)
);

I do have items created in August but it displays 0 . what is wrong with the formulae

Categories:

Using Apps Using Formulas

Mobile App

General Questions

Connecting to Data

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 06 Sep 2022 at 18:18:23

Like (1)

Report
Re: Displaying items that were created last month in powerapps

@KDAI

Please consider changing your Formula to the following:

With( {StartDate: Date(Year(Today()), Month(Today()) - 1, 1), EndDate: DateAdd(Date(Year(Today()), Month(Today()) + 1, 1), -1, Days) }, ClearCollect(collcreatedlastmonth, Filter('mylist', Created >= StartDate, Created <= EndDate ) ) );

This would include the prior month and any records in the current month.

I hope this is helpful for you.