Power Platform Community Forum Thread Details

Hello all,

Continuing this post, I want to sort the gallery where I show the participants by ascending sequence number without having it refresh everytime I change a field in the gallery. Quick refresher: I have a set of participants (Deelnemers) and their sequence number (Volgorde) for an event. Their sequence number is updated in a gallery. This is saved to the sharepoint entry of the event via a save button in a nested concatenated string, for example: 1-1;2-5;3-2;4-4;5-3 meaning participantID 1 is first, participantID 2 is 5th and so on:

After the values from the gallery and thus the string has been saved, I want to refresh the gallery where the participants are sorted by their sequence number ascending. When I use this code for the OnChange of the Volgorde (sequence) field the gallery refreshes immediately, making it impossible to work with the gallery correctly:

UpdateIf(colGalleryDeelnemersNieuweVolgorde, ThisItem.ID = ID, {Volgorde: Self})

I am running in circles using various collections to store the sequence numbers, but at this point I'm just guessing what the correct method of doing this is.

In short:

Anybody have an efficient general description of sorting galleries based on sequence number where the sequence numbers are changed in the gallery itself? The sorting should only take place after the sequence numbers have been saved to Sharepoint using a save button.

Hope I make myself clear!

Categories:

Using Apps Using Formulas