When creating table in excel with power automate. The argument is missing, invalid, or incorrectly formatted.

[Anonymous]

Hi, has anyone had something like this happen to them, and tried everything to get the flow to work but I still haven't been able to do it.

try making the flow like Reza did (thanks a lot for this great tutorial)

https://www.youtube.com/watch?v=Kupz71dWYyY&t=602s

and also tried this solution

https://powerusers.microsoft.com/t5/Building-Flows/RESOLVED-Create-table-The-argument-is-invalid-or-...

But in my case what I am doing is that from power apps I send a JSON with a collection with its data ready to make a table

I then loop through this JSON to manipulate the data and create the column names

and from here I make the process of the video from minute 9:34 to 14:28 as explained by R3za https://youtu.be/Kupz71dWYyY?t=574

I get the properties of an excel template file I create the file on my sharepoint site, such as the identifier of the new file created

and this is where I tried to carry out the Reza process

and also the other solution of the link

https://powerusers.microsoft.com/t5/Building-Flows/RESOLVED-Create-table-The-argument-is-invalid-or-...

and tried creating the sheet and putting the notation
'Name'!A1:N1
like also without the quotes
Name!A1:N1

I have done everything but without any result, does anyone know what the correct format should be to give the range to the table and be able to create it

thank you very much for any information

[abm]

Hi @Anonymous 

Once you created the Excel file in SharePoint you trying to create a table for that excel file? If it is I have got a video about this.

https://www.youtube.com/watch?v=P9rDwrI7ZBA&t=0s

Thanks

[Anonymous]

Thank you very much for your answer, yes, in part, it is what you indicate, but what I need is that from a JSON where I have all the records of the database, I pass it to a table format and then create the excel file in a library of document and later in that file that did not have any information inside, create the table and start adding the rows dynamically going through this JSOn table but they also ask me to do it with the excel connectors to be able to do a better maintenance in the future but I will do another flow tried this solution in the same way thank you very much

[abm]

Hi @Anonymous 

See my video first and see if that resolves your issue or not. The error you getting about invalid argument means the value which you passing is not quite right. Need to see the full flow in action and see it to find a resolution also English is my native language so not sure about those steps from the screenshots.

[Anonymous]

Yes bro, I already checked the video of your solution but it doesn't solve it because of what I told you above, I must do it with the information that I bring from this JSON of power apps and in turn do it with the Excel connectors so that the maintenance team I can make the changes in the future if they change the place of the library or site, but thank you very much for your solution