I have a sharepoint list with entries that have a completion date associated with each one. I have a gallery that is used to display all the entries from this list. This list can become quite long and I want to make it easier to sort through by only displaying the entries that have a completion date that falls within the current year and quarter. For example if 10 of the entries were completed in April of 2020 and 5 were completed in May of 2020 then I only want the gallery to display those 15 items instead of the whole list. Can anyone help me figure out how to do this?
What is the nature of your date column?.
Let me get feedback if it doesn't work show screenshot
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
@eka24 I was unable to get that to work. I have a calculated column in share point with this formula to determine the year: =TEXT([Audit Date],"YYYY").
I also have a calculated column to determine the quarter: ="Q"&CHOOSE(MONTH([Audit Date]),1,1,1,2,2,2,3,3,3,4,4,4). These show the correct year and quarter in sharepoint.
I am just not sure how to use the information in powerapps. This is my formula for items with the gallery:
Items = SortByColumns(Filter([@'Audit Master'],StartsWith(Section,TextSearchBox1.Text)||StartsWith(Operation,TextSearchBox1.Text)||StartsWith('Auditor Name'.DisplayName,TextSearchBox1.Text)),"Title",If(SortDescending1,Descending,Ascending))
Hi @wagner_nathan .
Calculated column is not delegable for sharepoint list in PowerApps, so it doesn't make sense for large data set.
You need to create a real Text column or Number column to store the Year and Quarter by workflow, then filter the gallery by them.
SortByColumns(Filter([@'Audit Master'], NumberYearColumn = Year(Now()) && NumberQuarterColumn= RoundUp(Month(Now())/3, 0) &&(StartsWith(Section,TextSearchBox1.Text)||StartsWith(Operation,TextSearchBox1.Text)||StartsWith('Auditor Name'.DisplayName,TextSearchBox1.Text))),"Title",If(SortDescending1,Descending,Ascending))
Hope this helps
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.