Create Table in Excel when Sheet Name Changes

(1) Share

Report

Posted on by SammutW

Hi,

I am trying to create a flow where I extract data from an excel sheet which is received daily by e-mail.

I have already create such flow with success but now I am facing a difficulty because the Excel file I receive daily has got a different sheet name everyday (today`s date) and therefore the flow cannot create the table and consequently read from the table.

Is there a solution to this please ?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

David_MA 12,966 Super User 2025 Season 2 on at

Like (1)

Report
Since you don't show your flow, I don't know what you've done so far. Have you tried using the action Get worksheets?

If there is more than one sheet in the spreadsheet, but it is always the first or last sheet where you pull the data, you can use an expression to get the value:
Get the name of the first sheet: first(outputs('Get_worksheets')?['body/value'])?['name']
Get the name of the last sheet: last(outputs('Get_worksheets')?['body/value'])?['name']

Was this reply helpful? Yes No
SammutW 39 on at

Like (0)

Report

Hi again,

I am trying the Get Worksheets tool and is working fine, However in the next step I am trying to create a table from which I will read the data.

The create table step is giving me a ' Bad Request' error. ( as per screenshots)

Any idea what I am doing wrong please ?

Was this reply helpful? Yes No
SammutW 39 on at

Like (0)

Report

Hi again,

I changed the table range an d even tried to introduce a delay between get worksheets and create table but still the same error : Bad Request

"statusCode": 400,

    "headers": {

        "Cache-Control": "no-store, no-cache",

        "Pragma": "no-cache",

        "Set-Cookie": "ARRAffinity=e263c61e92942e1dfc44f2d5780dd00bced69da0909266b10434ae8b24e4c2dc;Path=/;HttpOnly;Secure;Domain=excelonline-ne.azconn-ne-002.p.azurewebsites.net,ARRAffinitySameSite=e263c61e92942e1dfc44f2d5780dd00bced69da0909266b10434ae8b24e4c2dc;Path=/;HttpOnly;SameSite=None;Secure;Domain=excelonline-ne.azconn-ne-002.p.azurewebsites.net",

        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",

        "x-ms-request-id": "8eaf43c2-dd6c-4018-be90-08431f0eeb9f",

        "X-Content-Type-Options": "nosniff",

        "X-Frame-Options": "DENY",

        "x-ms-environment-id": "default-11a9a6bf-358f-4d87-bd1e-b4bef2cfba0e",

        "x-ms-tenant-id": "11a9a6bf-358f-4d87-bd1e-b4bef2cfba0e",

        "x-ms-dlp-re": "-|-",

        "x-ms-dlp-gu": "-|-",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "false",

        "Date": "Mon, 03 Mar 2025 12:14:04 GMT",

        "Content-Length": "288",

        "Content-Type": "application/json",

        "Expires": "-1"

    },

    "body": {

        "status": 400,

        "message": "Invalid request\r\nclientRequestId: 04a04296-ed68-4d62-b7e0-944be9738d38\r\nserviceRequestId: 8eaf43c2-dd6c-4018-be90-08431f0eeb9f",

        "error": {

            "message": "Invalid request"

        },

        "source": "excelonline-ne.azconn-ne-002.p.azurewebsites.net"

Was this reply helpful? Yes No
Suggested answer

SammutW 39 on at

Like (1)

Report

Hi again,

I managed to find a solution to this issue.

The issue was that the sheet name being a date (03-03-2024) couldn`t be used in the Create Table step because of the special charachters.

The solution was to either change the sheet name to Sheet1, for example, or either not using the sheet name at all since only one sheet was being used.

Thanks for the help,

William.

Was this reply helpful? Yes No