Power Platform Community Forum Thread Details

Create a table with dynamic worksheet name

Hello,

I am trying to create an Excel file with a newly created sheet in which I also create a table.

Firstly I use Create file action, and then Create worksheet to make a new sheet.

Finally, I am using Create table action and want to specify the sheet just created.

However, an error always occurs when I use a name of the newly created worksheet in the Table Range section as dynamic content as shown below (File field is intentionally left blank).

{
    "statusCode": 400,
    "headers": {
        "Cache-Control": "no-store, no-cache",
        "Pragma": "no-cache",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "x-ms-request-id": "83c16c9b-3eba-480d-835d-b9b5463c85ee",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "x-ms-tenant-id": "ccfd56bc-535e-4fe0-955c-223ec8eb4ed1",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Tue, 17 Sep 2024 04:08:15 GMT",
        "Content-Length": "426",
        "Content-Type": "application/json",
        "Expires": "-1"
    },
    "body": {
        "status": 400,
        "message": "引数が正しくない、不足している、または形式が不適切です。\r\nclientRequestId: 7e82a03a-0d1d-40d4-baf5-8762b5f83cf7\r\nserviceRequestId: 83c16c9b-3eba-480d-835d-b9b5463c85ee",
        "error": {
            "message": "引数が正しくない、不足している、または形式が不適切です。"
        },
        "source": "excelonline-jw.azconn-jw-001.p.azurewebsites.net"
    }
}
 