Unanswered

Having trouble creating table

(0) Share

Report

Posted on by jfcricardo

Hi everyone,

I was wondering if someone could help me with this.

What is the proper way of using the action create table?

The name of my sheet is Activity Reports - Invoices and the range is A2:AI

What is the proper way of writing this?

When I tried to write it as 'Activity Report - Invoices'!A2:AI I got the following error:

The argument is invalid or missing or has an incorrect format.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jfcricardo

To create a table using "Create table" action of excel connector, pls check the below screenshot:
We don't need to pass the sheet name, just pass the table name, cell range and column names.

The Output obtained after executing the above action:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
jfcricardo 34 on at

Like (0)

Report

Unfortunately my file has multiple sheets. That's why I was trying to use the sheet name.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @jfcricardo

In that case, pls pass the sheet name with the cell range in 'Table range' parameter. Here it the syntax:
'Activity Reports - Invoices'!A1:A2

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
jfcricardo 34 on at

Like (1)

Report
Thanks for the help. Apparently this was happening because I wasn't defining the number part of one of the cells.

I ended up finding this to have a dynamic range.

=OFFSET('Activity Reports - Invoices'!A1, 0, 0, SUBTOTAL(103, 'Activity Reports - Invoices'!$A:$A), 35)

Was this reply helpful? Yes No
almardelacruz 8 on at

Like (0)

Report

Hi, I have the same problem.

I am getting the same error message:

Here is my flow:
Create Worksheet > Create Table, I need to create the table then add rows on the created worksheet from the previous step.

Here is the error:
The argument is invalid or missing or has an incorrect format.
clientRequestId: 4d5bef20-50b8-4b76-b45e-75579afd2117
serviceRequestId: fc054c6a-49bc-4e5c-80ed-3684d859359a

Was this reply helpful? Yes No