Loop through all subsites in Site Collection

[MrAl]

How do I loop through all of the subsites within a site collection in SharePoint Online?  I have a site collection for project sites and each of those are created based on a template, so they all have the same lists and columns.  What I need to do is go through each of those subsites and do custom calculations on a column in a task list on a daily basis.  Also, based on those calculations, I need to send an email to the person responsible for those tasks as a reminder that they are coming due, are due, or are past due.  But, since the subsites will be created dynamically, I need to loop through them without necessarily knowing they exist, so I can't set it up for specific subsites by name.

[abm]

Hi @MrAl 

Try the following REST API

_api/web/webs/?$select=title,ServerRelativeUrl

[abm]

Hi @MrAl 

If you need any further help please let me know. 

If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thanks

[MrAl]

Hi @abm 

Thanks for you reply.  I wrote a simple "Sandbox" flow and tried to implement your suggestion.  So I have it set up as a scheduled flow, followed by the Send an HTTP Request with the RestAPI, then an email.  When I try to input the info from the Send HTTP Request into the email, all I have is "Body", and when I ran it, it sent something I could use, but how do I parse that information?  

Here is part of what I see: 

":[{"__metadata":{"id":"https://site.sharepoint.com/sites/<basesite>/_api/Web","uri":"https://site.sharepoint.com/<basesite>/<subsite>/_api/Web","type":"SP.Web"},"ServerRelativeUrl":"/sites/<basesite>/<subsite>/Test","Title":"Test"}

[abm · Accepted solution]

Hi @MrAl 

See my video tutorial.

Power Automate - SharePoint Loop Through All Sub-Sites Under a Site Collection - YouTube

Thanks

[MrAl]

Hi @abm 

This is exactly what I needed!  Many thanks for the video.

Al