Answered

How do I identify a table in Excel?

Like (0) Share

Report

Posted on 29 Jan 2024 13:05:20 by SharonGilmore

I'm creating a flow which should trigger when a particular form is submitted. I want to take the form responses and add them to an Excel spreadsheet. I'm stuck on the part where I 'Add a row into a table'. I can select the Excel file, but then it asks me to specify the table - I'm not sure what to put here. Do I need to create a table in my Excel file? If so, I can do that, but I don't know how to give it a name or id so that I can identify it.

All responses (4)

Answers (1)

SharonGilmore 7 on 29 Jan 2024 at 15:42:42

Like (0)

Report

Re: How do I identify a table in Excel?

Thanks
Verified answer

Unknown geen idee 1,755 on 29 Jan 2024 at 15:41:14

Like (1)

Report

Re: How do I identify a table in Excel?

Dear S.

Happy flowing,
Koen
SharonGilmore 7 on 29 Jan 2024 at 15:39:05

Like (0)

Report

Re: How do I identify a table in Excel?

Thanks, but how do I assign it a name, or see the name which is automatically assigned?
Unknown geen idee 1,755 on 29 Jan 2024 at 15:34:05

Like (0)

Report

Re: How do I identify a table in Excel?

Dear Sharon,

PowerAutomate will only recognize tables in Excel which are defined as such.
In your excel file (on OneDrive/Sharepoint), please define a table (CTRL-T) using the functions you see highlighted in the screenshot below. You can also provide a name (one is automatically assigned).

Hope this helps, if so, please indicate as like/solution in the thread.
Happy flowing,
Koen