Power Platform Community Forum Thread Details

Hi all,

I initially had this working after finding help on the community forum https://answers.microsoft.com/en-us/msoffice/forum/all/format-list-view-of-items-for-top-3-highest-using/4ec7ab55-491d-41b2-a6fb-ab0af79c66aa?messageId=ee6eb16b-7ff1-4b7c-accb-a8bb566b4323.

However, now it doesn't work as intended. The concept is a number field to which I need to apply a 1 for the highest value(s), 2 for the second, and 3 for the third highest value(s). This was working but I notices that it was not updating the existing items that had been previously ranked 1 that should be 2 or 3 now.

If anyone has a better way or an improvement, maybe something I've overlooked that would be great!

Screenshot 2024-05-02 at 5.07.31 PM.png

I hope that my further explanation will help explain this situation and what my goal is.

The below is the what my goal is. I update a list and have a custom view that is used in a SharePoint page.

Screenshot 2024-05-03 at 8.46.49 AM 2.png

Here are the PA Flow actions in sequence that I have now:

I get the items from the list
Initialize a variable to be an Array
Compose the list items field "Connected" which is a number field which will be used to identify the most to least amount for ranking using a "Sort" field
1. The Compose outputs are appended
Then the I compose the apply to each data "Number" and map it to {item()} which then converts it automatically in PA to current item, not sure why
Next I compose 1st, 2nd, and 3rd place data
1. I use the following for 1st, 2nd, and 3rd place compose actions in this order
  body('Select')[0]
  body('Select')[1]
  body('Select')[2]
Using the "Get Items..." action from above to apply to each for 3rd place
1. then the condition takes the the "Outputs" from the compose for 3rd place and checks if equal to the Connected field's value
2. Then the item's "Sort" field is then updated
3. then "a" and "b" is repeated in the following 2nd and 1st place in that order