I'm trying to create a flow that is connected to a SharePoint List.
List Columns and Data Types
- Priority (Required): Integer
- Domain (Required): Choice
- ID (Required): Auto
- Title (Required): Single Line Text
- Primary Owner (Required): Person
- Secondary Owner (Required): Person
Objective: Automatically update the Priority field based on user modifications
Example:
| Priority | Domain | ID | Title | Primary Owner | Secondary Owner |
| 1 | Writing | 1 | Task A | Joe | Sally |
| 2 | Reading | 2 | Task B | Jon | Jane |
| 3 | Listening | 3 | Task C | Sally | Joe |
- User adds a new task, Task D, with Priority value "1"
- List automatically increments the priority values of Tasks A, B, and C to 2, 3, and 4. (The current priority values shift down in priority)
- User completes Task B and it is removed from the list
- List automatically decrements the priority value of Task C to replace Task B. (The current priority values shift up in priority when an item is removed)
- User changes the priority value of Task C to value "1"
- List automatically increments Tasks A and B to be 2 and 3, respectively. (The current priority values shift down when an item is modified to be a higher priority)
I have been using variables, and controls [Condition and Do until] to create a flow. But the main two problems I am running into are the flow continuously running and seemingly disregarding the condition [I refresh the list and priority values are all above 50], and that the flow changes the created item's priority along with all of the existing items. If a user creates an item and sets the priority to 1, it should remain 1 after the list has run through the flow.
Any help or suggestions is greatly appreciated! Thank you!
