SharePoint Document Issues

How to Update a SharePoint Column When Another Column is Clicked

Camila MilosovichCamila Milosovich Oct 29, 2026 868 views

Question details

The user wants to automatically change the value of a status column in SharePoint when a hyperlink in a different column is clicked.

How to Update a SharePoint Column When Another Column is Clicked
Product
SharePoint Online
Device & OS
not provided
Scenario
Managing document or task statuses in a SharePoint list where interacting with a link should trigger a status transition.
Observed behavior
SharePoint Online does not have an out-of-the-box feature to automatically update a column based on a hyperlink click in another column.
Before you start

Ensure you have the appropriate site permissions to create and manage Power Automate flows for your SharePoint list.

Solution 1Recommended

Use Power Automate to Update SharePoint Status

Create a Microsoft Power Automate flow to detect the hyperlink click event and automatically update the corresponding status column in your SharePoint list.

Because SharePoint Online does not offer a native way to update columns directly via hyperlink clicks, Power Automate provides the best integrated workaround.

You can configure an automated flow that updates the list item's status while defining specific rules to handle repeated clicks or sequential status transitions (such as moving from 'In Progress' to 'Completed').

1
Launch Power Automate

Open your Microsoft 365 app launcher and select Power Automate to access your flow workspace.

2
Create a new flow

Click on 'Create' in the left menu and select 'Automated cloud flow' or 'Instant cloud flow' depending on how you plan to structure your hyperlink trigger (e.g., using an HTTP request trigger connected to the link).

3
Add the SharePoint action

Add a new step and search for the 'Update item' SharePoint action. Select it to add it to your flow.

4
Configure list details

In the 'Update item' action, input your SharePoint Site Address and select the specific List Name from the dropdown menu. Map the item ID dynamically from your trigger.

5
Set the new status

Locate your Status column in the action parameters and set its value to your desired new state (e.g., 'In Progress'). Save and test your flow.

Use Power Automate to Update SharePoint Status
Advanced Flow Rules: If you need complex rules for repeated clicks, consider asking for custom flow configurations in the Microsoft Power Automate Community.
Free Microsoft Office alternative

Edit SharePoint Documents Seamlessly with WPS Office

While you manage your lists and automated workflows in SharePoint, you can use WPS Office as a lightweight, free alternative to Microsoft Office for editing downloaded Word, Excel, and PowerPoint files.

  1. 1. Download and install: Visit the official WPS website to download the free office suite for your PC or mobile device.
  2. 2. Open your files: Launch WPS Office and open the Word, Excel, or PowerPoint files you downloaded from your SharePoint environment.
  3. 3. Edit and save seamlessly: Edit your documents with full formatting tools and save them in their native formats to easily re-upload them to your workspace.
Highly compatible with Microsoft Office formats (.docx, .xlsx, .pptx) for all your SharePoint documents.Free, lightweight, and fast-loading alternative for daily document editing and management.Familiar user interface ensures seamless migration with zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Can I use JSON column formatting to update a status on click in SharePoint?

JSON column formatting can change the appearance of a column and create clickable action buttons, but it cannot directly update the underlying list item data unless the JSON button is configured to trigger a Power Automate flow.

Is Power Automate free to use with SharePoint Online?

Yes, basic Power Automate capabilities necessary for standard SharePoint list automations are included with most Microsoft 365 and SharePoint Online commercial subscriptions.

How do I prevent users from clicking the link multiple times and disrupting the flow?

You can add a 'Condition' control in your Power Automate flow to check the current status of the SharePoint item. If the status is already set to 'In Progress' or 'Completed', the flow can simply terminate without making redundant updates.