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)

IDVendorNameWebsiteHyperlink
1Matthew Devaney


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


Output

Vendors (SharePoint List)

IDVendorNameWebsiteHyperlink
1Matthew Devaneyhttps://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
    }
)