Filter gallery by quarter

[freddiejoseph1]

Hi all,

I have a gallery which is linked to a sharepoint list. One of the columns in SharePoint is a date column. I am able to filter my gallery by the months January-December using a drop down, but when I add Q1, Q2, Q3, Q4 to the list of IDs in my drop down, I cannot filter the gallery by Q1, Q2, Q3, Q4 or using the IDs for these options..

Here is my list of IDs/Months: 

Here is my gallery items:

The whole formula works except the section around the quarters and combining the items which have January and February and March as a month.

I would appreciate some help around how I can filter a sharepoint list by Q1, Q2, Q3, Q4 in a powerapps gallery.

Thanks,

Freddie

[v-bofeng-msft · Accepted solution]

Hi @freddiejoseph1 :

Firstly,let me exolain why you encounted this problem.

The point is the condition

drpPartner.Selected.Value='All' And DropdownDate.Selected.Mon = "Q1"

is contained by

drpPartner.Selected.Value='All' And DropdownDate.Selected.Mon<>"ALL"

.

So the event after condition 

drpPartner.Selected.Value='All' And DropdownDate.Selected.Mon = "Q1"

will never be executed.

Secondly,please try:

Sort(
     Search(
            If(
               drpPartner.Selected.Value='All' And DropdownDate.Selected.id=0,
               'Tactical Comms'
               drpPartner.Selected.Value='All' And DropdownDate.Selected.id<=12,
               Filter('Tactical Comms',Month(CommunicationReleaseDate)=DropdownDate.Selected.id),
               drpPartner.Selected.Value='All' And DropdownDate.Selected.id = 13,
               Filter(XXXXXXXX),
               drpPartner.Selected.Value='All' And DropdownDate.Selected.id = 14,
               Filter(XXXXXXXX)……

Best Regards,

Bof

[freddiejoseph1]

Hi Bof,

Your solution worked. Thank you so much for your help!

Kind regards,

Freddie

[v-bofeng-msft]

Hi @freddiejoseph1 :

Is there anything else I can help?
If this post helps, then please consider Accept it as the solution to help others.Thanks😀
Best Regards,
Bof