SharePoint Document Issues

How to Move and Strike Through Completed Items in SharePoint Tracking Lists

Maira Mehtab Sep 21, 2026 869 views

Question details

The user wants to automate a SharePoint action-tracking report so that when an item's status is changed to Completed, it automatically moves to the bottom of the list and is formatted with strikethrough text.

Product: SharePoint / Power Automate
Device & OS: not provided
Scenario: Managing an action-tracking report created from a standard Tender template in SharePoint.
Observed behavior: The user needs a customized workflow to automatically reorder list items and change their visual formatting based on status changes.

Before you start

Ensure you have the necessary permissions to edit list views and create Power Automate flows for your SharePoint site. Familiarize yourself with basic SharePoint column formatting to easily apply custom JSON scripts.

Solution 1Recommended

Use Power Automate to Reorder Completed Items

Create an automated flow to detect status changes and update a custom sorting column, pushing completed items to the bottom.

SharePoint lists do not have a built-in feature to automatically move rows to the bottom based on status alone. By adding a hidden sorting column and using Power Automate, you can dynamically update this column whenever an item is marked as Completed.

Add a sorting column

In your SharePoint list, add a new number column (e.g., 'SortOrder'). Set a default value of 1 for new and active items.

Create a new Power Automate flow

Open Power Automate and create an automated cloud flow triggered by 'When an item is created or modified' in SharePoint.

Set a condition for completed items

Add a Condition action to check if the 'Status' column is equal to 'Completed'.

Update the sorting value

In the 'If yes' branch, add the 'Update item' action. Change the 'SortOrder' value to a significantly higher number (e.g., 999) so it sorts below active items.

Modify the list view sort order

Go back to your SharePoint list, edit the current view, and set the sort order to use your 'SortOrder' column in ascending order.

Solution 2

Apply Strikethrough Formatting Using JSON

Use SharePoint's built-in column or view formatting with JSON to apply visual strikethrough styling to completed rows.

Solution 3

Consult the Microsoft Power Platform Community

If your Tender template has complex dependencies, consulting the official community can yield tailored solutions and expert guidance.

Free Microsoft Office alternative

Looking for a Lightweight Office Suite? Try WPS Office

While SharePoint and Power Automate are specialized for complex cloud list automation, WPS Office provides a seamless, free alternative for your everyday document, spreadsheet, and presentation needs. It is perfect for teams looking to create and manage local reports efficiently without complex configurations.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Free and lightweight suite for creating action-tracking spreadsheets locally.Built-in PDF editing, conversion, and collaboration tools.Familiar tabbed user interface for a zero-learning-curve transition.

microsoft office alternative - wps office

Frequently Asked Questions

Can I hide completed items instead of moving them to the bottom of the list?

Yes. Instead of using Power Automate to reorder them, you can simply edit your SharePoint List View settings and add a Filter condition where the Status column is 'not equal to' Completed.

Why aren't my Power Automate changes reflecting immediately in SharePoint?

Power Automate flows may take a few moments to trigger and process the update in the background. Refreshing the browser page after 10-15 seconds usually displays the updated sorting order.

Do I need coding knowledge to format SharePoint lists with a strikethrough?

Basic list formatting can be done using the out-of-the-box design rules in the formatting pane. However, applying specific conditional styling like a strikethrough requires copying and pasting a simple JSON code snippet into the Advanced mode editor.

Does applying a strikethrough via JSON change the actual text data?

No. SharePoint view and column formatting only changes how the data is visually displayed to the user in the browser. The underlying text data remains completely unmodified.

Document & File Issues