News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Build of flow to creat...

Power Automate - Building Flows

Unanswered

Build of flow to create dynamic ranking column in SharePoint

(0) Share

Report

Report

Posted on by LK-18120736-0

Dear community,

I have a SharePoint list with approx. 50 list items. I would like to add a ranking column ranking them from 1-50 (unique values) and if priority changes e.g. bumping No. 10 down to No. 50, then the rest of the list will automatically update accordingly. I posted this on the SharePoint community site, and was referred to here as there is no "out of the box" solution to this and power automate flow may be the best option. I have already looked at these two posts, but as I am very new to Power Automate, I need more support (perhaps even screen dumps) building a flow.

Solved: Ranking Column

Solved: Update Sharepoint list Rank column when an item's ranking is changed

Thanks a lot.

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 31,039 on at

Like (0)

Report

Build of flow to create dynamic ranking column in SharePoint

Hi @LK-18120736-0,

I have created something similar with list/column formatting, so you might not need a flow at all.

Below is an example of that.

The setup uses a Votes column to keep track of the number of Votes. And a Vote column to either add (upvote) or remove (downvote) a vote from that total number of Votes. The ideas are sorted on the Votes number.

You can use the setvalue for this and combine it with an elmType button

https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-advanced#set-multiple-field-values-of-an-item-using-customrowaction

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 144,858

#2

RandyHayes 76,287

#3

Pstork1 64,505

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans