Send Graph http request to add rows into an xlsx table

(0) Share

Report

Posted on by SwiPowE_ch

Hi Folks,

I am referring to this blogpost from Paul Murana and the comment on this page from Andy Lawrence.

Paul is showing how to use the Power Automate Action Send an "http request (preview)" in "Office 365 Groups"

to create table rows in an excel table stored in OneDrive
This is the URI for sharepoint:

 https://graph.microsoft.com/v1.0/drives/{drive ID}/items/{item ID}/workbook/tables/CSVOutput/rows/add

I was able to add rows using the Graph explorer, so ids and syntax is correct, but PA Action fails with the error message:


RI path is not a valid Graph endpoint, path is neither absolute nor relative or resource/object is not supported for this connector. Resources: groups. Uri: https://graph.microsoft.com/v1.0/drives/b!qD.........YFlhWZRYox14DWXAOL/items/01JITT...NJITOC/workbook/tables/Tabelle1/rows/add

As it works fine in Graph explorer, it must be connected to the PA action.

Any ideas what it could be? Maybe a permission / connector problem?

Thank you and best regards from Switzerland

SwiPowE aka Bernd

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@SwiPowE_ch i see one different in the URL you have the and the URL that the blog post has i.e. /me/ is missing between /v1.0 and drive/, try putting that.

Was this reply helpful? Yes No
SwiPowE_ch 78 on at

Like (0)

Report
Copy link

Link copied!

Hi Anna,
thank you for your answer...the difference comes from 2 alternative ways, you can store it in Sharepoint and OneDrive and need different URLs, the one I am using is the one to save in Sharepoint which is in the comment from andy Lawrence..I tried both URLs which work both in GraphExplorer, but won't work in Power Automate.
The URL cannot be the problem as it works in Graph, something else, maybe connector permission in PA?
Thank you for your help
Best
SwiPowE

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@SwiPowE_ch are you using two different accounts, the one that use in graph explorer and one used in PA connections?

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (1)

Report
Copy link

Link copied!

@SwiPowE_ch @annajhaveri

If for some reason you can’t get stuff to work through this API, & you have access to Office Scripts, then there are other ways to accomplish the same thing

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

Was this reply helpful? Yes No
CatiaReis_ 4 on at

Like (1)

Report
Copy link

Link copied!
Hello,

I have been struggling with this too.
The solution is put the uri with the path and not with id.
In the next picture I show what do you have to replace and with what.
Go to Graph Explorer and do a GET to retrieve the sharepoint sites:

Extract the ID from the site that you're looking for, copy and paste in the ticked red part from the first image.
In the Graph explorer add to the excerpt copied from the last point '/lists'. Then click on Run and all the documents libraries will appear from the site, search for the one that you're looking for and copy the ID to the green part of the URi.
when we create a file in sharepoint, the file comes with the Display Name property (name + extension), add the display name to the purple part of URi.
Next to the Tables part of URi, we add the name of the table that we create inside the Excel file.
I hope I helped, if you have more doubts , you can reach me through email. Thank you.

Was this reply helpful? Yes No
Broselianda 2 on at

Like (0)

Report
Copy link

Link copied!

Did anyone ever get this to work? I have tried all the recommendations and I continue to receive the same error "URI path is not a valid Graph endpoint, path is neither absolute nor relative or resource/object is not supported for this connector. ".

Any advise?

Was this reply helpful? Yes No
aahubs 2 on at

Like (0)

Report
Copy link

Link copied!

I have been working on this as well, in my use case which is similar to this I am able to POST to my Excel table using Power automate GraphAPI. Im working with a Sharepoint Excel file and using the HTTP Premium connector. Currently I can only post 1 row to my table, but I'm working on this still. I will need to post all rows of data (which will be coming from a trigger table export from Power bi)

Heres what I'm doing

After i authenticate and get my token
i will use a HTTP GET with my site name to get the Site id which i parse out
https://graph.microsoft.com/v1.0/sites/{MYSITENAME.SHAREPOINT.COM}

Then, i will use the "Excel Get Tables" and in the Value of the output i see @OData.id of the Excel file. For me i know this file only has 1 table because I'm using it as a template so this method works for me, but you could grab the Table ID that you get in the values and adjust your Odate.id

And then*
nested in apply to each. I will use HTTP POST with this URI and then in the Body insert my Values
https://graph.microsoft.com/v1.0/sites/{MYSITE}@{items('Apply_to_each')['@odata.id']}/rows/add
Body looks like this;
{
"index": 0,
"values": [
[
"Name",
"Department"
]
]
}

Im still trying to figure out how to run the post for each row like the Standard excel connector works... Hopefully this helps someone

Was this reply helpful? Yes No