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
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 !
why this error occur?
Have you create the Year column in Sharepoint list as number ?
oh..missing that step..tq
@gabibalaban or any else way to limit my filter for example to display only 10 last record in order to cater this delegation warning?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
208 | |
49 | |
43 | |
41 | |
36 |
User | Count |
---|---|
291 | |
84 | |
80 | |
80 | |
77 |