PowerApps SharePoint hyperlink field – Update URL and Description 😲 with REST API

This video has all of the things. We explore the SharePoint Hyperlink or Picture field. How can you update it (hint, only possible sometimes in Power Apps), how you can read the description (hint: Power Apps cannot), and how Power Automate flow and the Rest API is the only way. This video finally explain all of the nuances of this handy but annoying little field. We have gallery, form, patch, flow, parse JSON, and SharePoint HTTP action all included in an action packed video. I hope you enjoy. Oh yeah, and we do some fun troubleshooting for Nulls with parse JSON.

0:00 – It starts
2:01 – How to use the Hyperlink or Picture column in SharePoint
3:29 – Saving images to a Picture Library in SharePoint
6:35 – Viewing a Hyperlink or Picture column in Power Apps gallery and the fact you can’t directly get the description
7:51 – Using the form control to update the URL of a Hyperlink SharePoint column in PowerApps. Does not work for Picture column.
9:27 – Using the Patch function in Power Apps to update they Hyperlink column URL but not the Picture column URL.
11:52 – We have to use Power Automate flow to update all of the fields
13:26 – Using the SharePoint REST Api to update both the description and the URL for the Hyperlink or Picture column in SharePoint
20:19 – Getting the Description from the Hyperlink or Picture column using the SharePoint REST api. Requires Parse JSON and generate from sample.
22:39 – Troubleshooting Parse JSON
26:40 – Accounting for blanks in Parse JSON by allowing nulls to fix the failure

Power Apps Training at https://training.powerapps911.com