web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : E/wPDUZL3UN4AgDhb5YzYX
Power Apps - Building Power Apps
Answered

How to create function the priority level in a list

Like (0) ShareShare
ReportReport
Posted on 28 Oct 2021 11:19:01 by

hey there 

 

Anyone created the function where lets say the list item sequence will auto update when the prior is completed?

 

Before
ItemPriorityStatus
A4N/A
B3N/A
C2N/A
D1N/A
E5N/A
F6N/A
G7N/A

 

After
ItemPriorityStatus
A3N/A
B2N/A
C1N/A
D Completed
E4N/A
F5N/A
G6N/A

 

 

I have the same question (0)
  • Verified answer
    Gerard Simpson Profile Picture
    2,987 Moderator on 28 Oct 2021 at 23:55:23
    Re: How to create function the priority level in a list

    Hi - you can try the following solution, which works on a SharePoint List data source. 

     

    Text pasted below also - looks a lot less intimidating without the comments

     

    AmDev_0-1635465074499.png

     

    Pasted text also:

     

    With(
    {SelectedPriority: ThisItem.Priority},

    Patch(
    'TEST Priority Seq',
    ThisItem,
    {
    Priority: 0,
    Status: {Value: Self.Selected.Value}
    }
    );

    UpdateIf(
    'TEST Priority Seq',
    Priority <> 0 && Priority > SelectedPriority,
    {Priority: Priority - 1}
    )
    )

     

    Hope this helps - good luck!

  • Community Power Platform Member Profile Picture
    on 29 Oct 2021 at 04:42:55
    Re: How to create function the priority level in a list

    thanks mate; the formula works like magic mike 

  • Gerard Simpson Profile Picture
    2,987 Moderator on 29 Oct 2021 at 08:54:16
    Re: How to create function the priority level in a list

    Great stuff! - glad it worked out for you

  • ucrtaps683 Profile Picture
    2 on 26 May 2023 at 18:05:06
    Re: How to create function the priority level in a list

    this information is great, but sorry i am new to lists.  where do i enter this information?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard