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" } )Code language: JavaScript (javascript)

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 } )