Error message when trying to create Excel Workbook

Help Orchestrator
,
1

Please help!

Unable to create an excel workbook in my flow. The below error message is generated. Any help would be much appreciated.

Error: UiPath.MicrosoftOffice365.Office365Exception: The caller is not authenticated.
at UiPath.MicrosoftOffice365.Activities.BaseLeafConnectionServiceActivityWithoutBindings.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 UiPath.Shared.Activities.ContinuableAsyncCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.MicrosoftOffice365.Activities.Office365BaseClientActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
UiPath.MicrosoftOffice365.Office365InternalException: Code: unauthenticated
Message: Unauthenticated

   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 Microsoft.Graph.UploadSessionRequest.DeleteAsync(CancellationToken cancellationToken)
   at UiPath.MicrosoftOffice365.Files.Extensions.FilesExtensions.DeleteSessionAsync(GraphServiceClient graphClient, UploadSession session)
   at UiPath.MicrosoftOffice365.Files.Extensions.FilesExtensions.UploadStreamAsync(GraphServiceClient graphClient, Stream stream, DriveItem destination, String cloudFileName, ConflictBehavior conflictBehavior, String account, CancellationToken cancellationToken)
   at UiPath.MicrosoftOffice365.Excel.Extensions.ExcelExtensions.CreateWorkbookAsync(GraphServiceClient graphClient, String name, DriveItem parent, ConflictBehavior conflictBehavior, String account, String sheetName, CancellationToken cancellationToken)
   at UiPath.MicrosoftOffice365.Services.GraphServiceClientProxy.CreateWorkbookAsync(CreateWorkbookRequest request, CancellationToken cancellationToken)
   at UiPath.MicrosoftOffice365.Activities.Excel.CreateWorkbookConnections.SafeExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
   at UiPath.MicrosoftOffice365.Activities.BaseLeafConnectionServiceActivityWithoutBindings.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
	Microsoft.Graph.ServiceException: Code: unauthenticated

Message: Unauthenticated

	   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 Microsoft.Graph.UploadSessionRequest.DeleteAsync(CancellationToken cancellationToken)
	   at UiPath.MicrosoftOffice365.Files.Extensions.FilesExtensions.DeleteSessionAsync(GraphServiceClient graphClient, UploadSession session)
	   at UiPath.MicrosoftOffice365.Files.Extensions.FilesExtensions.UploadStreamAsync(GraphServiceClient graphClient, Stream stream, DriveItem destination, String cloudFileName, ConflictBehavior conflictBehavior, String account, CancellationToken cancellationToken)
	   at UiPath.MicrosoftOffice365.Excel.Extensions.ExcelExtensions.CreateWorkbookAsync(GraphServiceClient graphClient, String name, DriveItem parent, ConflictBehavior conflictBehavior, String account, String sheetName, CancellationToken cancellationToken)
	   at UiPath.MicrosoftOffice365.Services.GraphServiceClientProxy.CreateWorkbookAsync(CreateWorkbookRequest request, CancellationToken cancellationToken)
	   at UiPath.MicrosoftOffice365.Activities.Excel.CreateWorkbookConnections.SafeExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
	   at UiPath.MicrosoftOffice365.Activities.BaseLeafConnectionServiceActivityWithoutBindings.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
2

@Josh_Prior

as per error you dont have access to file or the creds provided are wrong…or may be create access is not there

cheers

3

it seems you don’t have proper authorization to write / create file or your credential’s are wrong

4

I have the same problem. Could you solve this?

5

Hie @Josh_Prior it looks like you don’t have the permission to create the excel sheet …for further you have to contact to Admin …
cheers happy Automation