cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
poweruser_21
Regular Visitor

Filter Gallery Based on Another Gallery's Selection

Hello,

 

I know similar questions have been posted before. However, their setups were different, or the solutions didn't work for me. Plus I'm still learning.

 

I have 2 SharePoint (SP) Lists:

  1. "fiscal years" with a single column called "years".
    • This is connected to the Fiscal Years Gallery (attached picture).
  2. "calendar" with multiple columns.
    • Two of these columns are "FY Affected" and "Measure".
    • The "FY Affected" column has rows of years similar to 1. above.
    • The "Measures" column has rows of text data

 

What I am trying to do:

  • When I select a year from the Fiscal Years Gallery, I want the Measures Gallery to show only those Measures from the "calendar" SP list pertaining to only the selected year.

 

The formula I entered for the Measures Gallery - Items property, does not work. Would appreciate any help with this.

 

Thank you.

6 REPLIES 6
gabibalaban
Dual Super User
Dual Super User

@poweruser_21 ,

Try this formula for items property of the Measures Gallery:

Filter(calendar,'FY Affected'=Gallery2.Selected.Years)

Hope it helps !

 

 

 

Thanks for your prompt response. It doesn't seem to like the ".Years".

 

2022-01-11 12_41_24-Window.png

 

I've tried the following as well:

  • Gallery2.Selected
  • Gallery2.SelectedItem
  • Gallery2.SelectedItems
  • Gallery2.Selected.ID
  • Gallery2.Selected.Value
  • Gallery2.Selected.Item
  • Gallery2.Selected.Items

None of these work unfortunately.

 

Thanks.

It is the name of your column from 'fiscal years' list, so it should be years (without first capital letter). 

I will correct my post if it works, otherwise we'll keep looking for the answer. 

I see.

  • In this case, the name of my column is simply 'fy'.
  • I tried Gallery2.Selected.fy; but was not successful.

 

2022-01-11 13_19_59-Window.png

 

However, looking at the annotated error in the picture above made me realize that, and I apologize I didn't mention these details earlier:

  • the 'FY Affected' column from the "calendar" SP list, is formatted as a Choice in SP
  • and the 'fy' column from the "fiscal_years" SP list, is formatted as a Number in SP

Do these details help?

 

Hi @poweruser_21

Let me make it easy for you:

1). 'FY Affected' column is a Choice type from the 'calendar' SP list

2). 'fy' column is a Number type from the 'fiscal_years' SP list

3). You want to filter calendar list based on the 'FY Affected' column that has similar year like the 'fy' column in 'fiscal_years' SP list

 

If the above is correct, please modify your formula as below:

Filter(calendar,'FY Affected'.Value=Text(Gallery2.Selected.Years))
Best Regards,
Qi

Thanks Qi,

 

I didn't get a chance to test your formula as I created a work around for my issue. But I learned something new with your solution (converting to Text)!

 

Thanks to you, and @gabibalaban for your responses.

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.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,560)