Announcements
Hello all,
I am working against an excel worksheet that is converted to a SharePoint List. In the list there are duplicate names in a Column named "Source". I have created a gallery that contains a label that gathers the duplicated named instance (e.g. Inventory). I have been successful in gathering the total number of duplicate names by using Count Rows. What I am attempting to do is to use the On Select property of a button to navigate to a new Horizontal Gallery that will show each named instance in the "Source" Column. From this new gallery users can view the data from the named instance then decide whether to delete the duplicate named instance if it is not important. I have all other formulas working properly except the On Select property of the navigation button which would show each named instance in the new horizontal gallery. Is this possible to accomplish? Thank you in advance.
Hi @ITPadawan Can you post an example of what the data looks like in the label that contains the duplicated names, using fake/dummy data?
Thank you for your response. The Data that I am using is from a sample.(Older Excel worksheet not used in production any longer). I am using CountRows(Filter(Datasource, Source=ThisItem.Source)) to populate the label. I wish to use the OnSelect function to populate a gallery with each individual instance based on the Count of instances. For example. If the count of items is 5 the corresponding gallery will show all five items.
Hi @ITPadawan The code in the label is not delegable (see the yellow triangle), try:
With( { varDupes: Filter( Datasource, Source = ThisItem.Source ) }, CountRows(varDupes) )
Then, when you click on a row in that gallery (let's call it Gallery1), the Items property in the second gallery should be:
Filter( Datasource, Source = Gallery1.Selected.Source )
Thank you! That worked perfectly. Is it also possible in the second gallery to show each instance in as gallery item? For clarity if there are five counted instances each instance is shown as a separate gallery item.
Unless I'm misunderstanding you...
Let's say the selected row in the first gallery has a source called 12345 and there are 10 duplicates of 12345 in the source table.The 2nd gallery should list all 10 instances of 12345 from your source table using the code I gave you:
My apologizes. Yes you are correct. I had some previous formatting that I needed to remove that seemed to cause this issue. Thank you again for your help I appreciate you. Take care.
Great! Glad it's solved!d(-_-)b
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
