Skip to main content

Notifications

Power Automate - General Discussion
Answered

Excel's table name is not displayed to be selected

(0) ShareShare
ReportReport
Posted on by 9

Hi all,

 

I am trying to send multiple emails from an Excel sheet, but I have trouble. 

I tested several actions and the issue seems to be related with the sheet name selection, which does not be displayed to be selected. I tried to write the name of sheet directly, but I got this error

 

Error al guardar el flujo con el código "DynamicOperationRequestClientFailure" y el mensaje "Error en la solicitud de operación dinámica para la operación "GetTable" de la API "excelonlinebusiness" con el código de estado "NotFound". Esto puede indicar que los parámetros de entrada no son válidos. Respuesta de error: { "status": 404, "message": "The requested resource doesn't exist.\r\nclientRequestId: 6b60a478-a3d1-4a2b-9c54-616b1b7fe5a3\r\nserviceRequestId: feaa5d0f-36c1-4bc6-8ffb-7ee47429f137", "error": { "message": "The requested resource doesn't exist." }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" }.".

Otherwise, I was able to add a new sheet in that Excel file, so I do not know where the problem is.

 

Can you help me?

Thank you!


im_aea_0-1634907129298.png

 

 

 

  • im_aea Profile Picture
    im_aea 9 on at
    Re: Excel's table name is not displayed to be selected

    @ignasi

     

    You should rename the table 

    https://support.microsoft.com/en-us/office/rename-an-excel-table-fbf49a4f-82a3-43eb-8ba2-44d21233b114

     

    My mistake was that I was trying to select the worksheet ("hoja 1") instead of the table's name

  • Ignaci Profile Picture
    Ignaci 2 on at
    Re: Excel's table name is not displayed to be selected

    Hello,

    could you please indicate where is the difference? Thanks!

     

  • im_aea Profile Picture
    im_aea 9 on at
    Re: Excel's table name is not displayed to be selected

    Scott thanks!! I have noticed the difference right now and it works

  • im_aea Profile Picture
    im_aea 9 on at
    Re: Excel's table name is not displayed to be selected

    Thanks for the answer, Scoot. My issue is that I can select the file, but I cannot select the table (it is not displayed as available)

    Thanks

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Excel's table name is not displayed to be selected

    @im_aea 

    You mention sheet names - you need to reference a table and not worksheets.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard