How to Update a SharePoint Column When Another Column is Clicked
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.

- 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.
Ensure you have the appropriate site permissions to create and manage Power Automate flows for your SharePoint list.
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').
Open your Microsoft 365 app launcher and select Power Automate to access your flow workspace.
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).
Add a new step and search for the 'Update item' SharePoint action. Select it to add it to your flow.
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.
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.

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. Download and install: Visit the official WPS website to download the free office suite for your PC or mobile device.
- 2. Open your files: Launch WPS Office and open the Word, Excel, or PowerPoint files you downloaded from your SharePoint environment.
- 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.

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.




