Unanswered

How do I identify a table in Excel?

(0) Share

Report

Posted on 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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Unknown geen idee 1,757 on at

Like (0)

Report

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

Was this reply helpful? Yes No
SharonGilmore 7 on at

Like (0)

Report

Thanks, but how do I assign it a name, or see the name which is automatically assigned?

Was this reply helpful? Yes No
Verified answer

Unknown geen idee 1,757 on at

Like (1)

Report

Dear S.

Happy flowing,
Koen

Was this reply helpful? Yes No
SharonGilmore 7 on at

Like (0)

Report

Thanks

Was this reply helpful? Yes No