Answered

Get YEAR and compare with dropdown Year for filter

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to get the year from a date in dataverse. Then compare that year to the text dropdown I have for the years to be able to filter the list. For some reason, the line in RED is giving me issues (probably because I don't know what I am doing)

No Idea what I am doing wrong. I feel like its me not understanding how a date gets converted to a number or text that I can use to compare with the text from the dropdown.

SortByColumns(
 If(Text(DropdownPPYear.Selected.Value) = "All",
 Filter(
 'ITCosting PrePaid Schedules',
 PmtMonthDate >= DateAdd(Now(),1, Years) && 
 VendorSearchInput.Text in Vendor
 ),
 Filter(
 'ITCosting PrePaid Schedules',
 Text(Value(Year(PmtMonthDate))), >= Value(DropdownPPYear.Selected.Value) && 
 VendorSearchInput.Text in Vendor 
 )
 ),

"crd83_pmtmonthdate", 
SortOrder.Ascending 
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

mate_toth 98 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,
It looks like there is an extra comma after the ValuePmtMonthDate))), and the Text isn't needed. Can you try with this one?
Value(Year(PmtMonthDate)) >= Value(DropdownPPYear.Selected.Value)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
This was the final code that seems to have worked properly. I thank you for your help. I hate commas! haha
SortByColumns( If(Text(DropdownPPYear.Selected.Value) = "All", Filter( 'ITCosting PrePaid Schedules', VendorSearchInput.Text in Vendor && PmtMonthDate >= DateAdd(Now(),0, Years) ), Filter( 'ITCosting PrePaid Schedules', Value(Year(PmtMonthDate)) >= Value(DropdownPPYear.Selected.Value) && // Text(Value(Year(PmtMonthDate))), >= Value(DropdownPPYear.Selected.Value) && VendorSearchInput.Text in Vendor ) ), "crd83_pmtmonthdate", SortOrder.Ascending )

Was this reply helpful? Yes No