To get all the SharePoint sites in tenant using power automate
this is the error I'm facing right now
Hi @resappleshinnin ,
Please try:
Schema
{
"type": "object",
"properties": {
"statusCode": {
"type": "integer"
},
"headers": {
"type": "object",
"properties": {
"Transfer-Encoding": {
"type": "string"
},
"Vary": {
"type": "string"
},
"Strict-Transport-Security": {
"type": "string"
},
"request-id": {
"type": "string"
},
"client-request-id": {
"type": "string"
},
"x-ms-ags-diagnostic": {
"type": "string"
},
"X-SearchPlatform": {
"type": "string"
},
"OData-Version": {
"type": "string"
},
"Timing-Allow-Origin": {
"type": "string"
},
"x-ms-apihub-cached-response": {
"type": "string"
},
"x-ms-apihub-obo": {
"type": "string"
},
"Cache-Control": {
"type": "string"
},
"Date": {
"type": "string"
},
"Content-Type": {
"type": "string"
},
"Content-Length": {
"type": "string"
}
}
},
"body": {
"type": "object",
"properties": {
"@@odata.context": {
"type": "string"
},
"@@odata.nextLink": {
"type": "string"
},
"value": {
"type": "array",
"items": {
"type": "object",
"properties": {
"createdDateTime": {
"type": "string"
},
"description": {
"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"
}
}
}
},
"required": [
"createdDateTime",
"id",
"lastModifiedDateTime",
"name",
"webUrl",
"displayName"
]
}
}
}
}
}
}
Best Regards,
Bof
Now this provides total sites but next step I want to pass only the site URL one by one not an entire result
Hi @resappleshinnin ,
What kind of results do you need? Plain text? Can you provide a sample?
Best Regards,
Bof
yeah I get it but I want to pass the site URL one by one like apply to each is there a way to do it.
Hi @resappleshinnin ,
You could try Graph API :
https://graph.microsoft.com/v1.0/sites?search=*
Best Regards,
Bof
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional