Unable to Add/update multiple Choice field in SharePoint list using Office365 activities

Feedback Activities
, ,
1

the SharePoint Field is having a column ‘Skills’ which has multiple values like UiPath; .net; Java

the add a row in Sharepoint using office365, we have to pass the data using datatables.

When I am trying to add object in the data table, it was throwing error.

Thanks in advance for your help!

2

@Sreelatha278

Try with text only with colon separation…

Cheers

3

Hello @Anil_G ,

it was throwing the same exception

Add List Items: Code: generalException
Message: General exception while processing

4

@Sreelatha278

Can you please try opening the exception details from locals panel and check it might give more info of the exact error

Cheers

5

This the exception details in local panel

RemoteException wrapping Microsoft.Graph.ServiceException: Code: generalException
Message: General exception while processing
Inner error:
AdditionalData:
date: 2023-06-28T02:50:32
request-id: 80ec8cd0-234a-4577-a883-31a35d9f048e
client-request-id: 80ec8cd0-234a-4577-a883-31a35d9f048e
ClientRequestId: 80ec8cd0-234a-4577-a883-31a35d9f048e

at Microsoft.Graph.SimpleHttpProvider.SendAsync(HttpRequestMessage request,
HttpCompletionOption completionOption,
CancellationToken cancellationToken)
at Microsoft.Graph.BaseRequest.SendRequestAsync(Object serializableObject,
CancellationToken cancellationToken,
HttpCompletionOption completionOption)
at Microsoft.Graph.BaseRequest.SendAsync[T](Object serializableObject,
CancellationToken cancellationToken,
HttpCompletionOption completionOption)
at UiPath.MicrosoftOffice365.Sharepoint.Extensions.SharePointExtensions.AddItemsToSharepointList(GraphServiceClient graphClient,
Office365SharepointList list,
IEnumerable`1 listOfItemData,
CancellationToken cancellationToken)
at UiPath.MicrosoftOffice365.Activities.SharePoint.AddListItems.ExecuteAsync(AsyncCodeActivityContext context,
CancellationToken cancellationToken)
at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
at UiPath.Shared.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)

6

@Sreelatha278

As per error the input provided should be in different format…can you try with sending values with comma separation "item1,item2"

Ideally using graph api we define it as a collection type and send it…but in UiPath we can only send few types…so need to see the possibilities

Else try with single item format where the first column name represents column and second represents value and of type object…you can try sending it as an array like "UiPath; .net; Java".Split(";",Stringsplitoptions.None)

Cheers

7

Hello Anil,

I am getting this error

Add List Items: One or more columns of the provided DataTable is not of the correct type

My observation : for multiple choice the datatype is Object, for the remaining fields it was object.

8

@Sreelatha278

Let me check from myside an get back if I find something for multifield

Cheers

9

thank you Anil!

Kindly check on update list item as well

10

Hello Anil,

Did you get a chance to check on this.

Thank you!

11

@Sreelatha278

Allow me some time…did not check yet…will keep you posted

Cheers

12

Hi @Anil_G ,

Please let us know the solution to the above question; we are facing the same issue.

Thanks &Regards,
Sanjay B

13

I checked with the UiPath Support team, they said this feature is currently not available using the UiPath studio. This has been raised to the Product team and they could implement it in the upcoming versions, based on the feasibility.

Does anyone have alternative solutions to achieve this.
this project is in Windows version, SharePoint activities are not compatible.

Thanks,
Sree Latha

14

@Sreelatha278

Thanks for the update…

Two options you would have

  1. Use graph api calls directly to acheive this result …for this you need to go through graph api doc and see the update list method and perform it through http request activity
  2. If you have access to power automate then we can write a power automate to update the list and values acan be passed from UiPath to power automate and run it to update the list

Cheers

1 Like
15

Moved this post from Help to Feedback as this was bug in UiPath office365 activities.

1 Like