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)
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()):
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 !
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.