cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudosaurus
Post Prodigy
Post Prodigy

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

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:

sudosaurus_0-1637769405262.png

Excel file:

sudosaurus_1-1637769572154.png

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
sudosaurus
Post Prodigy
Post Prodigy

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

View solution in original post

3 REPLIES 3
sudosaurus
Post Prodigy
Post Prodigy

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

eburniston
New Member

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.

 

eburniston_0-1643997387424.png

 

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_0-1644359503763.png

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,947)