Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
BPPAutomations opened this issue Sep 16, 2024 · 0 comments
Open
Labels
bug Something isn't working

Comments

@BPPAutomations
Copy link

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

/

@BPPAutomations BPPAutomations added the bug Something isn't working label Sep 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant