Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Error Code 502 - Embedded Object using List Rows Present in a Table (Business)

(0) ShareShare
ReportReport
Posted on by

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'.
  • Verified answer
    Re: Error Code 502 - Embedded Object using List Rows Present in a Table (Business)

    Hi @PowerUp1 

     

    You can check this URL that contains the error handling information for Flow: https://flow.microsoft.com/en-us/blog/error-handling/. But, if you already know that the Excel file contains this kind of content it's better to don't use it.

     

    Best Regards,

  • PowerUp1 Profile Picture
    PowerUp1 on at
    Re: Error Code 502 - Embedded Object using List Rows Present in a Table (Business)

    Thanks @chsanche 

     

    Any suggestions for 'catching' this before the flow reaches List Rows and causes an error?

     

    Ideally, I'd like to run a check on the file and if it fails then send the user a notification to correct and resubmit.

  • Re: Error Code 502 - Embedded Object using List Rows Present in a Table (Business)

    Hi @PowerUp1 

     

    This is a product limitation. The Power Automate connector doesn't accept this type of content inside your Excel file, even files that contain connections, for example, connections to SharePoint are not supported either in an Excel file. In order to use an Excel file with Flow connectors, the file needs to contain only texts and formulas, this type of content that you are using is currently not supported.

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics