Announcements
I'm making an Org Chart and have a vertical line icon that acts as a connector from one gallery item to the next. The icon is showing at the very bottom of the gallery because I have it placed at the bottom of the gallery template record, but there's no more gallery items to connect it to. I don't want it to be visible if it's the last item in the Gallery's visibleindex. How do I accomplish this? It's also child gallery inside a parent gallery. I've tried various countrows and visibleindex comparisons to no avail.
Hi @russrimm1
Is your gallery items connected to a data source? If so you can use this code in the Visible property of your icon:
ThisItem.ID <> Last(YourDatasource).ID
Hi @Adrian_Celis not currently - it's an imported Excel spreadsheet but the end goal is to come up with a process by which the person exporting the xls can drop it somewhere and automatically have it update a datasource. Problem is the sheet is protected so I haven't been able to get a Dataflow to accomplish this part yet. I'll try LAST once I figure out how to get it to replicate to a data source. Thanks!
I see. You can also put your imported Excel data to a collection and do the same formula, this time use the collection. Just make sure you have an ID column or any sort of identifier.
ThisItem.ID <> Last(YourCollection).ID
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 392 Most Valuable Professional
11manish 181 Super User 2026 Season 2
MS.Ragavendar 112 Super User 2026 Season 2