delegation warning with filter function

[twister]

Hi, my filter gallery got this yellow warning when using filter function. How do I cater for this warning?

Search(
    SortByColumns(
        Filter(
            mainTable,
            level = 3, Year(proposer_date)=Year(Now())
        ),
        "ID",
        If(SortDescending1, Ascending, Descending)
    ),
    TextInput19_1.Text,
    "Title",
    "status"
)

Filter(sinc_main_team, Title = varEdit.ID)

Thanks

[gabibalaban]

Hi @twister ,

Is mainTable a sharepoint list ?

If so, i'm affraid that you need to create a Year column in this list to keep the year of proposer date column - don't forget to refresh in powerapps the connection to this list (you can try to use a calculated column inside sharepoint, in some circumstances it works) and also to use a context variable for year(today()):

UpdateContext({yearNow:Year(Today())})

Your formula should look like this:

Search(
    SortByColumns(
        Filter(
            mainTable,
            level = 3, Year = yearNow)
        ),
        "ID",
        If(SortDescending1, Ascending, Descending)
    ),
    TextInput19_1.Text,
    "Title",
    "status"
)

 Hope it helps !

[twister]

why this error occur?

[gabibalaban]

Have you create the Year column in Sharepoint list as number ?

[twister]

oh..missing that step..tq

[twister]

@gabibalaban or any else way to limit my filter for example to  display only 10 last record in order to cater this delegation warning?