Sharepoint Lists - Add List Items With Hyperlink

[Alfred]

Is there a working way of adding list items with a hyper link using the add list items activity? I am trying to use the add list item activity to add a datable, but there is one column that is not strings but hyperlinks.

[pradeep931 (Pradeep Bandharam)]

Hello @Alfred

You need to create the dictionary for the hyperlinks, please find the below steps for more information

–>Create a dictionary** to store your field names and values.
–>Include the hyperlink** in the correct format.
–>Use the Add List Item activity** to push the data to your SharePoint list.

Add list item example:

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

{“TestNumber”,4},

{“TestHyperlink”,“https://www.test4.com”}

}

How To Update A Hyperlink Column In A SharePoint List?

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. …

[Alfred]

Thanks for the quick response. However the add to list items activity does not accept Dictionary, it only accepts datatables.