Add row to excel (Business)

[Anonymous]

Hello, 

I trying to add row to Excel (Business) but I have some troubles with "Row" option.

Everything looks good but I dont know, how to works with "Row" option. I tried to insert text which I want to insert but it showing error:

{

  "error": {

    "code": "",

    "message": "The request entity's media type 'text/plain' is not supported for this resource."

  },

  "debugInfo": "clientRequestId: bdf9113b-6a29-4d30-9684-d83d2c48155b"

}

Can you help me please?

 

 

Jan

[Anonymous]

Syntax for the Row field is

{
"ColumnName":Value,
"Column2Name":Value
}

I generally build the string in a Compose action and then pass it to the Row line in the Excel connector.

Example:

{
"LastName":"foo",
"FirstName":"bar",
"Age":4
}

[Anonymous]

I followed your syntax example above and recieved the following error 

A value must be provided for item.
clientRequestId: 127865ce-1349-42e5-902f-0a161a4307d7

[Anonymous]

Can you provide screenshots that show the wider context? I can't tell, for example, if you're typing into a Compose action or directly into the Add a Row action. You need to use Compose, which will convert the syntax into JSON.

[Anonymous]

I did use a compose and still get the same error. 

I have an excel document that contains a list of people and the identifier of their individual excel files.  In a previous get a row it pulls the information so that it can place the information from a form into a different individual excel file based on the file identifier.  All of their excel docs have the same layout with the same table name and column names. 

[Anonymous]

The issue seemed to be the # I had in one of my column names.  Once I removed that it was able to process.  Thank you for listing the syntax for the Row field above.  This is the only place I have seen that listed and was a great help in my understanding how to use it properly.

[vernariesaco]

THANK YOU SO MUCH FOR YOUR COMPOSE SYNTAX FOR THE ROW!!! YOU ARE A SAVIOR!!! THANK YOU TOO FOR THE ASKER. I HAD THE SAME PROBLEM AS YOU. 😃

[Gwill1983]

sorry for raising an old post, but I am having similar issues. I am creating a new file and then adding rows into the table. All works fine until I get to the 'add a row' part and it comes up with the error below:

{

  "error": {

    "code": "",

    "message": "The request entity's media type 'text/plain' is not supported for this resource."

  },

  "debugInfo": "clientRequestId: eb6953c5-afaf-4b57-8779-b5e6a0557eda"

}

This sheet has lots of columns, but this error has me baffled! Any assistance would be welcome.

Thanks

[vernariesaco]

hello... a screenshot of the flow and spreadsheet would help... 

[Gwill1983]

Apologies. So, I am creating a new file and adding rows from another excel sheet. 

My file is created as below:

This is followed by an apply to each as below:

The only dynamic option I have added so far is the timestamp as a test, but it is still failing. I am unsure what the error message means so not sure where to start to fix this

[Anonymous]

Hi Gwill,

You need to put the JSON defining the row into a Compose action. That will convert it to a JSON object. Then put the output into the Row field.

If you still have problems, try removing the question mark and parentheses from your column names.

[vernariesaco]

Hello @Gwill1983,

@Anonymous is right... as much as possible use only letters in your table's column names...

[Gwill1983]

Thanks for this.

I have removed everything but text from the column headings and added the compose action but I am still getting the same error message!

The compose action works perfectly, it is the adding a row into the table that fails.

[vernariesaco]

hello, could it because you are adding a row in a table that has just been created?

can you try adding a delay perhaps? i am totally unsure... i am just being hopeful that trial and error would work. sorry i do not have the exact answer...

i am also thinking what if you create a flow to create the table. then check the excel file if the flow was indeed able to create the table. then create a separate flow to add row. just to test where this error is coming from.

have you tried giving the name of the table as a value (Report) and not dynamic one (name)?

sorry these are 3 places i would look if i am facing this. good luck...

[Gwill1983]

@DamoBird365 Hi 

I have got this far using your video in the link below:

https://youtu.be/RB_ySjhm9Sg

Are you able to assist with this error? I have tried everything that I can think of to remove this error, but no matter what I adjust / test it continues to come up with this error.

[Anonymous]

@Gwill1983I'm assuming due to the SharePoint icon that you're storing the file on SharePoint. I tried creating a simple version of the flow, without the Apply to Each, which works for me by using the Identifier dynamic content instead of Id.

I would second @vernariesaco saying you should test this in stages.

1. Check the file to see if the table has been successfully created

2. If so, delete the table and run again to make sure it's still being successfully created (if the flow runs successfully up until the Add A Row action, you should delete the table before every new test)

3. If it is, see if you can write a separate flow adding a single row to an existing table.

4. If that works, then try adding the Apply to Each back in.

I am unclear what you're iterating over in order to do the Apply to Each so cannot test that for you. If the problem is in the Apply to Each, a good way to test it is to set a Compose action as the first action of the loop and put all of the relevant dynamic content into it (like a print statement, if you're familiar with traditional programming) to see what exactly it's getting.

Googling the error, it seems more likely to be a permissions or Active Directory-level issue than a flow syntax one. Can another user with higher credentials add a row to the table?

[Gwill1983]

Looking closely at what you have done, your Compose Json has these brackets {}. Mine have 'standard' brackets and when I change them to curly brackets it says that the JSON is no longer valid. 

The flow runs perfectly up until adding the data each time. The file is created with the table entered correctly each time. 

I think I can rule out permissions as I have flows running for files in the same sharepoint folder. 

This is a major mind boggle!

[Gwill1983]

It works. 

I think the problem was the JSON in the compose having the incorrect bracket type. The JSON was then invalid as there was a comma after the final entry of data. 

Just ran it and it is sorted.

Thank you both so much for your help! This is a major break through for what I am trying to achieve

[CROBOT]

Sorry to reopen this thread again. I am having a weird issue where I am following all of the steps in this thread, and my table is being created in Excel, and I am not getting an error, but it is writing blanks into each row. Let me know what I am doing wrong please!

here is the picture of the blank table. As you can see, it is adding the rows, but it isn't pasting the values into it. I have checked, the values for my variables do exist.

Here is the picture of my code and the compose. 

This is within a loop for each person in our active directory, paste in this information to a table to excel.

[CROBOT]

Also, I created that table earlier in the code. Maybe there is a delay issue?