Power Platform Community Forum Thread Details

I created a Power Automate flow using the Excel "List Rows Present in a Table". It works great when using it with Excel workbooks that do not have a digital signature line.

When I try using it with an Excel that has the digital signature line added (not signed, just the block inserted like this https://support.microsoft.com/en-us/office/security-privacy/add-or-remove-a-digital-signature-for-microsoft-365-files) it does not work and I receive a 502 Bad Gateway error.

When I try signing the digital signature line, I receive a "Graph API encountered unsupported features in this workbook and was unable to work with it."

I am using a brand-new single-sheet Excel workbook that is just a single cell with "Testing Excel signature" typed in it and the digital signature line.

I know digital signatures inserted in Excels are kind of archaic but I'm trying to automate an existing business function without changing the process for users. Do you all have any ideas?

Categories:

Using flows

This appears to be a limitation of the Excel Online/Graph API connector rather than an issue with your flow.

The List rows present in a table action relies on Excel Online through Microsoft Graph. If the workbook contains unsupported features, such as a digital signature line or signed workbook content, the connector may fail with errors like 502 Bad Gateway or unsupported features in this workbook.

A few options you can consider:

Use an unsigned processing copy

Keep the original signed/signature-line workbook for the business process.

Create a copy without the signature line.

Have Power Automate read from the unsigned copy.

Move the data to a separate Excel table

Keep the signature document separate.

Store the actual rows/data in a normal Excel table without the signature feature.

Let the flow read that file instead.

Use SharePoint or Dataverse instead of Excel for the data

If the process is business-critical, Excel with signatures may not be the best backend for automation.

A SharePoint list or Dataverse table will be much more reliable for Power Automate.

Use Power Automate Desktop as a workaround

If you must interact with the signed/signature-line Excel file, desktop automation may be able to open Excel directly and extract the data.

This is more fragile than cloud flow actions, but may work when the cloud Excel connector cannot.

In short, the Excel connector does not handle all Excel workbook features. Since the error specifically says unsupported workbook features, I would avoid using the signed/signature-line workbook directly in the cloud flow and instead automate against a clean copy or a separate data source.