get the info from an http request and insert it in a SharePoint list

(0) Share

Report

Posted on by Edvhdy

101

Hello,

I made a flow which aims to retrieve the list of all the SharePoint sites present in the tenant.

I manage to retrieve the information, but I do not know how to retrieve the creation date and the name of the site.

Then it's to retrieve each name of the site and insert it in a SharePoint list.

can you help me find a solution to retrieve each name of each SharePoint site from the output of the http request?

Spoiler (Highlight to read)

{

"type": "object",

"properties": {

"createdDateTime" : {

"type" : "string"

"id": {

"type": "string"

"lastModifiedDateTime": {

"type": "string"

"name": {

"type": "string"

"webUrl": {

"type": "string"

"displayName": {

"type": "string"

"root": {

"type": "object",

"properties": {}

"siteCollection": {

"type": "object",

"properties": {

"hostname": {

"type": "string"

}

{ "type": "object", "properties": { "createdDateTime" : { "type" : "string" }, "id": { "type": "string" }, "lastModifiedDateTime": { "type": "string" }, "name": { "type": "string" }, "webUrl": { "type": "string" }, "displayName": { "type": "string" }, "root": { "type": "object", "properties": {} }, "siteCollection": { "type": "object", "properties": { "hostname": { "type": "string" } } } }}

Thanks

flow bug.PNG

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @Edvhdy ,

shouldn't you use the 'Parse JSON' action instead of 'Parse CSV'?

Was this reply helpful? Yes No
Edvhdy 101 on at

Like (0)

Report

thanks @tom_riha

I used parse Json but the output of the http request is the same as the output of Parse Json.

I would like to be able to recover certain elements and put them in an array then insert them in the list. (that's why I wanted to use the CSV connector) but I can't do it

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

That's strange, output of the HTTP request should be the actual data, output from Parse JSON should be a lot of dynamic contents parsed from the HTTP request output.

Did you use the actual HTTP output as the sample data payload in the Parse JSON? And the output from the HTTP request as the value to parse in Parse JSON?

Was this reply helpful? Yes No
Edvhdy 101 on at

Like (0)

Report
hi @tom_riha ,

yes it is the same. maybe I have an error.

Body (Ouput) Http request :
{ "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites", "value": [ { "createdDateTime": "2019-06-17T13:54:24Z", "id": "###", "lastModifiedDateTime": "2019-06-08T08:21:10Z", "name": "###", "webUrl": "###", "displayName": "Site ###", "root": {}, "siteCollection": { "hostname": "###.sharepoint.com" } },

Output Json (input body http request) -> Ouput :

{ "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites", "value": [ { "createdDateTime": "2019-06-17T13:54:24Z", "id": "###", "lastModifiedDateTime": "2019-06-08T08:21:10Z", "name": "###.sharepoint.com", "webUrl": "###.sharepoint.com", "displayName": "Site ###", "root": {}, "siteCollection": { "hostname": "###.sharepoint.com" } },

Was this reply helpful? Yes No
Edvhdy 101 on at

Like (0)

Report

I would like to insert in a list the elements:
DisplayName
createdDateTime
webUrl

I think it would loop through each value of the Http request and retrieve the underscored items to insert them.

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

'Parse JSON' will parse the HTTP output using the schema, after the 'Parse JSON' you'll have all the values from the JSON available as a dynamic content. You can then use the values later in the flow.

Was this reply helpful? Yes No
Edvhdy 101 on at

Like (0)

Report
@tom_riha

Thank you for your help.

I made changes following your post.(see image) and I have no data at the exit of "Compose".

Here is the output of the Json parse :

{ "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites", "value": [ { "createdDateTime": "2019-06-17T13:54:24Z", "id": "###", "lastModifiedDateTime": "2019-06-08T08:21:10Z", "name": "Site 1", "webUrl": "https://###.sharepoint.com", "displayName": "Site 1", "root": {}, "siteCollection": { "hostname": "###.sharepoint.com" } }, { "createdDateTime": "2020-06-25T15:13:56Z", "id": "###", "lastModifiedDateTime": "2020-06-25T15:18:55Z", "name": "Site 2", "webUrl": "###.sharepoint.com/", "displayName": "Site 2", "root": {}, "siteCollection": { "hostname": "###.sharepoint.com" } }, ........

it seems to me that it will be necessary to loop on each element of the value "name" to be able to insert them in a list?

What do you think ?

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
I think Power Automate has problem with the @ in:

"@odata.context"

at least on my environment it doesn't accept the input you shared as a valid JSON unless i remove the @.

Other than that, you should loop through the 'value' array to get to the 'name' for each object.

Was this reply helpful? Yes No
Edvhdy 101 on at

Like (0)

Report

hi @tom_riha

indeed power automate does not like @ by deleting it I have good data output from JSON.
I will work on the flow again to remove the @.

in the flow you manage to buckle down on the value. is that what value you put?

because no value is offered to me in Dynamic content.

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

Normally, I let Power Automate to add the 'Apply to each' for me. Add only the 'Compose' action, place the 'name' dynamic content inside and it'll add the proper 'Apply to each' around it.

Was this reply helpful? Yes No