PATCH A SharePoint Hyperlink Column In Power Apps

Goal

Change the WebsiteHyperlink column (Hyperlink Type) from blank to “https://www.google.com”.

Special Note: a hyperlink column has two properties – Url and Description. Power Apps patches the Url and Description with the same value. If you want to have different values for these you must use Microsoft Automate as a workaround.


Input

Vendors (SharePoint List)

ID	VendorName	WebsiteHyperlink
1	Matthew Devaney

Patch Function Code

Patch(
    Vendors,
    LookUp(Vendors, ID=1),
    {
        WebsiteHyperlink: "https://www.google.com"
    }
)

Output

Vendors (SharePoint List)

ID	VendorName	WebsiteHyperlink
1	Matthew Devaney	https://www.google.com

Scenario #1

Patch a value found in a text box to a Hyperlink field.

Patch Function Code

Patch(
    Vendors,
    LookUp(Vendors, ID=1),
    {
        WebsiteHyperlink: TextInput_Website.Text
    }
)