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

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
Dual Super User
Dual 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 Partisan
Post Partisan

why this error occur?

twister_0-1618824862425.png

 

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

twister
Post Partisan
Post Partisan

oh..missing that step..tq

twister
Post Partisan
Post Partisan

@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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,557)