Invoke an HTTP request action failed with "invalidRequest"

(0) Share

Report

Posted on by IPLO365

Hi Community,

I am having issues with an "Invoke an HTTP request" action, that adds rows into an Excel table stored in a SharePoint site.

The table is successfully created, and the Drive ID, Item ID and Table ID are grabbed from that action and passed to the problematic "Invoke an HTTP request".

The URI I am passing in the "Invoke an HTTP request" action is as per below:

https://graph.microsoft.com/v1.0/drives/@{outputs('Compose_Drive_ID')}/items/@{outputs('Compose_Item_ID')}/workbook/worksheets/Sheet1/tables/@{outputs('Compose_Table_Name')}/rows/

The body request I am sending is just an array representing just one row of data.

See image below for more details.

The error reads "invalidRequest".

What am I doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report

Hi , @IPLO365

I test it in my side , this is due to you pass the wrong body in your http request.

You need to pass the a 2-dimensional array of unformatted values of the table row.

TableRowCollection: add - Microsoft Graph v1.0 | Microsoft Learn

And this will run successfully:

So you need to convert your body in your http request.

For example, this is the flow:

item()?['OData__dlc_DocIdUrl']

item()?['Title']

item()?['eDocsNo']

And you can test it here:
Graph Explorer | Try Microsoft Graph APIs - Microsoft Graph

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No