Row reordering with List buttons

CamCov ok so I have a list as shown below which has a single line of text column for each of the SwapSequence columns. I'll give you the JSON for that later in this post as you need to create the 2 flows first, 1 to move the selected item up 1 in the sequence and 1 to move it down and swap the other item affected.

The Swap Sequence + button triggers the following flow:

The trigger is for a selected item, then the first action is to get the item. Then add a compose and select Sequence from the dynamic content box. Then add another compose to add 1 to the sequence number.

We then get the item that currently has a sequence number of seq+1 and we add a compose to take 1 away from it:

Next, add an apply to each and inside it add an update item action that updates the previous +1 item with a new sequence number that is 1 less.

Then outside the apply to each update the item you selected by adding 1 to it:

Once you've built this flow you need to add a new single line of text column to your SharePoint list and format it in advanced mode with the following JSON, changing the id in the actionParams line to the id of your flow:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "button",
  "txtContent": "Swap Sequence +",
  "customRowAction": {
    "action": "executeFlow",
    "actionParams": "='{\"id\":\"cdb95289-8680-4fca-97b0-21d4645be08d\", \"headerText\":\" ' + [$Title] + '\",\"runFlowButtonText\":\"Go\"}'"
  },
  "style": {
    "background-color": "#b2eee6",
    "border-radius": "10px"
  }
}

So in running the flow we're going to click the Guadaloupe swap sequence + button which will swap it with the Cayman Islands. This is the result:

For the swap sequence down flow you need to save the flow you've just built as a copy, rename it and then go through it to do the opposite of what you did before.

Then add another single line of text column to your list and paste in the JSON but with the id of the new flow.

Come back with any questions about this.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)