How to Track progress in SharePoint list form from Power Automate ?

[Bhanu2023]

I have 3 Stages-  Not Started, In progress , Completed

When ever below sample List have all Yes - Status - Completed 

                             sample List have all No - Status - Not Started

                             sample List have mix of Yes and No  - Status - In progress

How to run the flow in power automate when ever status change and show it on the top of SharePoint list form  

?

COl1	COl2	COl3	COl4	COl5
YES	YES	YES	YES	YES

[SudeepGhatakNZ]

You could just use the "When item is created or modified" trigger.

You can create a SharePoint view that displays items in descending order of Modified date.

[Bhanu2023]

@SudeepGhatakNZ - Need additional details / sample Solution how to achieve it. Please guide

[SudeepGhatakNZ]

You could achieve this without using Power Automate.

Create a calculated column in SharePoint with Datatype text with the similar formula.

=IF(
    AND([Column A]="High",[Column b]="High")
    ,"Red"
    ,IF(
        AND([Column A]="High",[Column b]="Low")
        ,"Gold"
        ,IF(
            AND([Column A]="Low",[Column b]="High")
            ,"Green"
            ,IF(
                AND([Column A]="Low",[Column b]="Low")
                ,"Black"
                ,"NA"
               )
           )
      )
  )

 You can then just include the column in the view and sort it by Modified date

[Bhanu2023]

@SudeepGhatakNZ - I want to show this in list form not in the list . When some one click new status at top should be Not started . Then change of status on the basis of column value added ,

[SudeepGhatakNZ]

Have you considered using a Power Apps form?

[Bhanu2023]

@trice602 - please guide if we have a way to do it . Want to show progress in SharePoint list form .