SOLVED

How to Patch a SharePoint Hyperlink Field using PowerApps

%3CLINGO-SUB%20id%3D%22lingo-sub-137578%22%20slang%3D%22en-US%22%3EHow%20to%20Patch%20a%20SharePoint%20Hyperlink%20Field%20using%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137578%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20successfully%20used%20PowerApps%20Patch%20Function%20to%20create%20new%20items%20in%20a%20SharePoint%20list.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20I%20have%20not%20been%20able%20to%20Patch%20a%20%3CSTRONG%3EHyperlink%20Type%3C%2FSTRONG%3E%20field.%20I%20assume%20it's%20one%20of%20the%20Complex%20Data%20types.%20I%20am%20not%20sure%20where%20to%20get%20info%20on%20that%20one.%20I%20did%20find%20info%20on%20updating%20other%20complex%20fields%20like%20Choice%20and%20Person.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAny%20help%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-137578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-137840%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Patch%20a%20SharePoint%20Hyperlink%20Field%20using%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137840%22%20slang%3D%22en-US%22%3E%3CP%3EI%20read%20elsewhere%20that%20there%20may%20not%20be%20support%20for%20writing%20to%20the%20SharePoint%20Hyperlink%20or%20Photo%20column%20type%2C%20so%20I%20worked%20around%20this%20by%20just%20using%20a%20regular%20text%20column.%20Add%20I%20wanted%20was%20to%20enable%20the%20user%20to%20be%20able%20to%20get%20to%20a%20URL%20from%20a%20PowerApps%20for%20where%20there%20would%20be%20documentation%20they%20needed%20to%20read.%20I%20simple%20hid%20the%20field%20on%20the%20PowerApp%20form%20in%20display%20mode%20and%20use%20a%20button%20control%20along%20with%20the%20OnSelect%20formula%3A%3C%2FP%3E%0A%3CPRE%3ELaunch(the_Field_name_with_the_URL)%3C%2FPRE%3E%0A%3CP%3EBy%20default%20it%20launches%20the%20link%20in%20a%20new%20browser%20tab%20which%20is%20perfect%20for%20me.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I have successfully used PowerApps Patch Function to create new items in a SharePoint list.   

 

But I have not been able to Patch a Hyperlink Type field. I assume it's one of the Complex Data types. I am not sure where to get info on that one. I did find info on updating other complex fields like Choice and Person. 

Any help?

 

 

1 Reply
best response
Solution

I read elsewhere that there may not be support for writing to the SharePoint Hyperlink or Photo column type, so I worked around this by just using a regular text column. Add I wanted was to enable the user to be able to get to a URL from a PowerApps for where there would be documentation they needed to read. I simple hid the field on the PowerApp form in display mode and use a button control along with the OnSelect formula:

Launch(the_Field_name_with_the_URL)

By default it launches the link in a new browser tab which is perfect for me.