Date filter with dropbox

(0) Share

Report

Posted on by loopingmurdock

250

Hey,

here is the code am using but am trying to insert, so rither do a condition on the actual month i like to add a dropbox to select the month.

Thanks guys

If(
 !IsBlank(
 LookUp(
 Add_Expensive,
 DateOf >= Date(
 Year(Now()),
 Month(Now()),
 1
 ) And DateOf < DateAdd(
 Date(
 Year(Now()),
 Month(Now()),
 1
 ),
 1,
 Months
 )
 )
 ),
 Text(Sum(Add_Expensive, Income) - Sum(Add_Expensive, Purchase), "0.00€")
)

a dropbox with the name of the month, cant figure out where to but it

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
@loopingmurdock

To get an Items property for the dropdown, create a collection

Collect( col_months, Calendar.MonthsLong() ); ForAll( col_months, Collect( colNumberedMonths, Last( FirstN( AddColumns( col_months, "RowNumber", CountRows(colNumberedMonths) + 1 ), CountRows(colNumberedMonths) + 1 ) ) ) )

and use colNumberedMonths as the Items property.

You can filter your table

Filter( AddExpense, Month(Dateof) = Dropdown1.Selected.RowNumber )

Was this reply helpful? Yes No
loopingmurdock 250 on at

Like (0)

Report

Thanks... alot

Was this reply helpful? Yes No