Alfred
September 5, 2024, 5:44pm
1
Is there a working way of adding sharepoint files I am trying to use the upload files on sharepoint with no luck.
pradeep931
(Pradeep Bandharam)
September 5, 2024, 5:59pm
2
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?
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.
…
Anil_G
(Anil Gorthi)
September 15, 2024, 4:33am
5
@Alfred
Here is a workaround…when you need to change the column type to text but can format it as hyperlink using html markup
The workaround I found was to keep the column as text, but add the data in html format, which looks like a hyperlink column
New System.Collections.Generic.Dictionary(Of String, Object) From {
{"URLLink", "<a href="""+in_StrURLLink+""" target='_blank'>Link</a>"}
}
Hope this helps
Cheers