PATCH A SharePoint Hyperlink Column In Power Apps

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-hyperlink-column-in-power-apps/. Author: Matthew Devaney.

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 } ) Did You Enjoy This Article? 😺

Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up