How To Update A Hyperlink Column In A SharePoint List?

[system]

How to update a Hyperlink column in a SharePoint List?

Note: Hyperlink and Picture columns are not yet supported for the Graph API calls.

Resolution: Using a different field type for the Hyperlink column type (for example a Text) is the only option as SharePoint API will not be used in the O365 package (UiPath.MicrosoftOffice365.Activities).

An alternative solution can be the custom UiPathTeam.SharePoint.Activities[1.7.0] package activities from https://gallery.uipath.com/api/v2 source.

Note: Even if the needed results are achieved at this time, it can not be officially supported for it is not an UiPath official package.

Find the manual SharePoint Custom Activities Package.pdf for the respective package with some good examples at SharePoint Custom Activities Package. It has been tested internally to update the Hyperlink column and Add some items to the list.

SharePoint application scope example:

Add list item example:

Prop Dictionary: New Dictionary(Of String, Object) From {{"Title","HR4"},

{"TestNumber",4},

{"TestHyperlink","https://www.test4.com"}

}

Update list items:

Prop Dictionary/PropertisToAdd: New Dictionary(Of String, Object) From {{ "TestHyperlink", "https://www.modified.com"}}

CAMLQuery: "" + "HR2" + ""

Results in SharePoint: