microsoft / PowerPlatformConnectors

This is a repository for Microsoft Power Automate, Power Apps, and Azure Logic Apps connectors
https://aka.ms/connectors
MIT License
985 stars 1.27k forks source link

[BUG] Excel Connector not working when saving copy from shared flow #3649

Open BPPAutomations opened 2 months ago

BPPAutomations commented 2 months ago

Type of Connector

Certified Connector

Name of Connector

Excel Online For Business

Describe the bug

There is a step Create worksheet in a flow (say flow A), flow A is shared to other user, other user used save as to save a copy flow on one's My Flow (say flow B).

Flow B found bug when testing, the root cause seem to be Power Automate generate the metadata: image

This metadata is only visible in code view, and user have to manually recreate the step to generate the new metadata.

I dont see why this is useful on user side since we can do nothing in the step in order to change it.

Is this a security bug?

No, this is not a security bug

What is the severity of this bug?

Severity 1 - Connector is broken or there's a very serious issue

To Reproduce

See Description

Step code view in plain text in case image can't load:

{ "type": "OpenApiConnection", "inputs": { "parameters": { "source": "me", "drive": "b!TlKbfAC6nEuVIqqHMyXpppcqNPdR7LxPrNpo6oLE7WKoxKS2vVfPSKRTqX8aP6Bu", "file": "/@{variables('Excel File Name')}", "body/name": "@outputs('Get_New_Tab_Name')" }, "host": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness", "connection": "shared_excelonlinebusiness", "operationId": "CreateWorksheet" } }, "runAfter": { "Get_Name_and_Key_only": [ "Succeeded" ] }, "metadata": { "01A4NZQQLDFMHLVPLDNBE2IWWJFJL4SYH3": "/[02008094] Flow Analysis.xlsx", "tableId": null } }

Expected behavior

no such metadata should be generated such that the flow is more migratable.

Environment summary

Power Automate on Web

Additional context

/