Unanswered

Filter Gallery Based on Another Gallery's Selection

(0) Share

Report

Posted on by poweruser_21

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:

"fiscal years" with a single column called "years".
- This is connected to the Fiscal Years Gallery (attached picture).
"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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@poweruser_21 ,

Try this formula for items property of the Measures Gallery:

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

Hope it helps !

Was this reply helpful? Yes No
poweruser_21 12 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi gabibalaban,

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

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.

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
poweruser_21 12 on at

Like
a
(0)

Report
Copy link

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

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?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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))

Was this reply helpful? Yes No
poweruser_21 12 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No