[RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

(1) Share

Report

Posted on by sudosaurus

1,597 Super User 2024 Season 1

Hello,

I have started building a new workflow where the first action after the manual trigger is "Create table".

However, when I run the workflow, I am presented with this error message:

The argument is invalid or missing or has an incorrect format.
clientRequestId: 532bbf84-0c0f-490a-83af-29d3a81ef2a8
serviceRequestId: ed480924-697e-491a-8a8c-22281f86f0ca

Flow:

Excel file:

Have I incorrectly formatted the Table range?

Essentially what I'm trying to do here is add a table header to an excel file when it is dumped into a folder as this will happen daily and the file cannot have the table header added to it beforehand.

All responses (8)

Answers (1)

krawad 9 on at

Like (0)

Report

Re: [RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

Hello, were you able to find a solution after all? 🙂 i have the same issue
mithushalk 340 on at

Like (0)

Report

Re: [RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

My table is incremental

I don't have a specific range

How do I tackle this error?
DC0001 4 on at

Like (0)

Report

Re: [RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

I have a question: I keep getting the below error can any help understand why and how to correct it?
The argument is invalid or missing or has an incorrect format.
clientRequestId: f19cf63d-b479-4dee-af26-e53d0f055975
serviceRequestId: f00e73cd-30e5-4dd2-8de7-01a7ca1b585d;22ee1a19-bc71-4562-8455-1e3408e15f76
DC0001 4 on at

Like (0)

Report

Re: [RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

I have a question: I keep getting the below error can any help understand why and how to correct it?
The argument is invalid or missing or has an incorrect format.
clientRequestId: 15c81ecf-d477-4fe0-8520-50e8250b5002
serviceRequestId: 49c288b1-aba4-4c41-9b76-3ad92ddb5fec
hitakshi 162 on at

Like (0)

Report

Re: [RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

Hi,
I have a question, I don't know how many columns in my excel file so to define the range in this action.
eburniston 18 on at

Like (5)

Report

Re: [RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

I solved my problem. I added quotes on either side of the dynamic field. Using a dynamic field in the table name was also a problem, but I was able to use the expressions to achieve the same results. Correcting these two issues finally allowed me to successfully create the table.
eburniston 18 on at

Like (0)

Report

Re: [RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

I have attempted this solution for the same issue, but I continue to have the error message as described above. My setup is slightly different as I am creating a worksheet and from there, creating a table. The worksheet creates each time just fine named as the Month and Year. I've changed the table range from A1:Q40 to A1:Q1, but that did not fix it either. I've tried so many different things, that I've finally had to ask for help. Below is what I currently have setup. I appreciate any input.
Verified answer

sudosaurus 1,597 Super User 2024 Season 1 on at

Like (1)

Report

Re: [RESOLVED] Create table - The argument is invalid or missing or has an incorrect format

Solved by Using this Table Range: Sheet1!A1:L4