Unanswered

How can I sort a gallery, "If ThisItem.Visible = true, Move ThisItem.Order to the bottom, else Keep ThisItem.Order as it is" ; This is to fill empty spaces when an item is hidden

(0) Share

Report

Posted on by Robert94

520

ClearCollect(colMenu,
 {Title:"NTA", Order:1, Navigate:'NTA Questions', Visible:true},
 {Title:"Data Protection", Order:2, Navigate:'Data Protection', Visible:true},
 {Title:"CSV", Order:3, Navigate:CSV, Visible:true});

Gallery - Items - colMenu

Categories:

Building Power Apps

{43359BD6-9C4C-4C...

{003D631B-C575-4F...

I have the same question (0)

All responses (13)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Robert94

What do you mean by moving Order to the bottom?

Was this reply helpful? Yes No
Robert94 520 on at

Like (0)

Report

If the ThisItem is hidden, move the hiddenitems tabs to the bottom, this way it won`t be any spaces between visible tabs. Basicallry sort the Visible item by descending, Visible Items to be first, Hidden Items to be last.
There is a photo uploaded with the gallery.

Was this reply helpful? Yes No
Robert94 520 on at

Like (0)

Report
Sort(colMenu, If(LMB1.visibleNTA=false, If(ThisRecord.Title="NTA", ThisRecord.Order, Descending), LMB1.visibleDP=false, If(ThisRecord.Title="DP", ThisRecord.Order, Descending), LMB1.visibleCSV=false, If(ThisRecord.Title="CSV", ThisRecord.Order, Descending) ))
Something like this, maybe you get the point if you see this code

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Robert94

Yes, I saw your photo and it was the same order and everything based on the table you supplied to the Items.

I am assuming that the goal of the Visible property is to filter out things that should not be visible. They are all set to true, so not sure what value that plays or where it comes in.

If you are not using Visible to "hide" items, then can you clarify the use?

When you say tabs - what is it that you are referring to?

Was this reply helpful? Yes No
Robert94 520 on at

Like (0)

Report

For eg on this photo, i want the CSV tab to be on top, because the other ones are hidden.

{C23B88E9-8B86-40...

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Robert94

But they are not hidden! They are still in your gallery records.

You are looking at this from the inner gallery rather than the Items.

What is LMB1??

Was this reply helpful? Yes No
Robert94 520 on at

Like (0)

Report
Yes my bad, that code doesn`t seem it will work proerly, in realtime. Sorry about that.
So the visibility property of the gallery items is this:
If(ThisItem.Title="NTA",LMB1.visibleNTA, ThisItem.Title="Data Protection",LMB1.visibleDP, ThisItem.Title="CSV",LMB1.visibleCSV )
Tabs means Items/Records of the gallery.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Robert94

But what is LMB1?

Was this reply helpful? Yes No
Robert94 520 on at

Like (0)

Report
LMB1.visibleNTA is a property from a component that get`s updated in real time (based on answers from a form), and then it returns a true/false value.

For eg.
LMB1.visibleNTA - Property:
If(dcvDataCollecting.Selected.Value="I don`t know" , true,false)

Was this reply helpful? Yes No
Robert94 520 on at

Like (0)

Report

Photo for better understanding of the LMB1

{8CF2F499-1F77-45...

Was this reply helpful? Yes No