Hi, I have a flow that reads rows from a table in excel. It works perfectly when a file is submitted without any embedded objects.
However, the failure occurs when the excel file contains an embedded object such as an email file or control box for running a macro.
Any ideas on how to deal with this ?
This is the error message:
There's a problem
The dynamic invocation request failed with error: Unexpected error occurred when calling the ApiHubsRuntime API: 'Microsoft.Azure.ProcessSimple.Data.Entities.Exceptions.ProcessSimpleDataException: The ApiHubsRuntime API call failed with http status code 'BadGateway' and response content '{ "error": { "code": 502, "source": "firstrelease-001.azure-apim.net", "clientRequestId": "7b6e40d7-a9b6-4a0d-86f4-e4f9-a3576a25", "message": "BadGateway", "innerError": { "status": 502, "message": "This workbook cannot be edited because it contains the following features:\r\n\r\n• Objects like form toolbar controls, toolbox controls, and ActiveX controls\r\n\r\nTo edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy.\r\nclientRequestId: 7b6e40d7-a9b6-4a0d-86f4-e4f9-a3576a25", "error": { "message": "This workbook cannot be edited because it contains the following features:\r\n\r\n• Objects like form toolbar controls, toolbox controls, and ActiveX controls\r\n\r\nTo edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy." }, "source": "excelonline-wcus.azconn-wcus.p.azurewebsites.net" } } }' at Microsoft.Azure.ProcessSimple.Data.DataProviders.AzureResourceManagerDataProvider.<>c__DisplayClass52_0`2.<<CallAzureResourceManager>b__0>d.MoveNext() in X:\bt\1108650\repo\src\processsimple\Roles\ProcessSimple.Data\DataProviders\Services\AzureResourceManagerDataProvider.cs:line 577 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.WindowsAzure.ResourceStack.Common.Algorithms.AsyncRetry.<Retry>d__3`1.MoveNext() in X:\bt\1092291\repo\src\common\core\algorithms\AsyncRetry.cs:line 0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.WindowsAzure.ResourceStack.Common.Algorithms.AsyncRetry.<Retry>d__3`1.MoveNext() in X:\bt\1092291\repo\src\common\core\algorithms\AsyncRetry.cs:line 171 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Azure.ProcessSimple.Data.DataProviders.AzureResourceManagerDataProvider.<CallAzureResourceManager>d__52`2.MoveNext() in X:\bt\1108650\repo\src\processsimple\Roles\ProcessSimple.Data\DataProviders\Services\AzureResourceManagerDataProvider.cs:line 0'.