cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
twister
Post Patron
Post Patron

delegation warning with filter function

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

 

 

twister_0-1618820722932.png

 

Filter(sinc_main_team, Title = varEdit.ID)

 

twister_0-1618821116056.png

 

Thanks

5 REPLIES 5
gabibalaban
Super User
Super User

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
Post Patron
Post Patron

why this error occur?

twister_0-1618824862425.png

 

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

twister
Post Patron
Post Patron

oh..missing that step..tq

twister
Post Patron
Post Patron

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,109)