Forum Discussion
Power Automate and SharePoint List Required field URL
Morning:
I have a problem.
I am creating an automation based on a SharePoint list. The automation will check for date, and send a notification out when a document needs to be revised, at which point, the Document's status will change form Live to "Due revision".
To make that change, i added an Update File and here is the problem
The list has "Required" fields one of them is "Document Title" which is a Hyperlink type.
this field has 2 parts, URL and Alternative Text. The Alternative text is what displays on the list
The problem is, when using Power Automate "Get Items" " Document Title" on the "Update Item" action, then it will display the URL on the list instead of the document name
(instead of showing the name of the Document it shows URL)
So, is there a way to sort this out (other than changing the filed to not required - since it is an important one)
Thank you
1 Reply
Hi MVCuser,
Yes, this is a known limitation with hyperlink fields in Power Automate. When using actions like "Get item" or triggers like "When an item is created or modified", the description part of the hyperlink is missing, which causes issues—if the field is required.
One reliable workaround is to use the "Send an HTTP request to SharePoint" action to retrieve the item. This method returns both the URL and the description, allowing you to preserve the full hyperlink value during updates.
Another approach I’ve used successfully is a bit of a workaround:
- Temporarily make the hyperlink field optional in the list settings.
- Update your Power Automate flow and leave the hyperlink field blank in the "Update item" action.
- After saving the flow, set the hyperlink field back to required.
This works, but every time you edit the flow, you’ll need to repeat these steps. It’s not ideal, but it’s a practical workaround if you don’t want to use the HTTP request method.
--------------------------------------------------------------------------------------------------
If this response helped you, please consider liking it and marking it as the accepted answer.
