Filter from Json and apply to each

[vidarv]

Hi ,

I have a flow that collect sites from SharePoint online using microsoft graph

The output is going to Parse Json and the schema is

{
    "type": "object",
    "properties": {
        "body": {
            "type": "object",
            "properties": {
                "value": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "createdDateTime": {
                                "type": "string"
                            },
                            "id": {
                                "type": "string"
                            },
                            "name": {
                                "type": "string"
                            },
                            "webUrl": {
                                "type": "string"
                            },
                            "displayName": {
                                "type": "string"
                            },
                            "isPersonalSite": {
                                "type": "boolean"
                            },
                            "siteCollection": {
                                "type": "object",
                                "properties": {
                                    "hostname": {
                                        "type": "string"
                                    }
                                }
                            },
                            "root": {
                                "type": "object",
                                "properties": {}
                            }
                        },
                        "required": [
                            "createdDateTime",
                            "id",
                            "name",
                            "webUrl",
                            "displayName",
                            "isPersonalSite",
                            "siteCollection",
                            "root"
                        ]
                    }
                }
            }
        }
    }
}

The compose action is

Since there is a lot of Output, I do not want the Onedrive accounts. I want to use the filter function and filter on
isPersonalSite equal to false

When i am using the filter function, I can see the input bot the output is body[] - I am stuck on this filtering
After the filtering i want to take the Output from this filter and use a apply to each for checking the subsites on SharePoint

Can someone help to guide me trhough the filtering and am I thinking right abot the apply to each where i am going to use the filtering an the id of the filtering

[ManishSolanki]

Hi @vidarv 

In Filter array action, instead of entering false as text, pls try adding it as an expression to make it compatible with left side operand as shown below:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[vidarv]

Thank you for answering @ManishSolanki I am sorry but the output is still

{
    "body": []
}

[Nived_Nambiar]

Hi @vidarv 

I think the error is due to usage of array() function over parse json output 🤔

Based on schema i tried to generate a sample json object 

{
  "body": {
    "value": [
      {
        "createdDateTime": "2024-02-18T08:00:00Z",
        "id": "123456789",
        "name": "example",
        "webUrl": "https://example.com",
        "displayName": "Example Site",
        "isPersonalSite": true,
        "siteCollection": {
          "hostname": "example.com"
        },
        "root": {}
      },
      {
        "createdDateTime": "2024-02-17T08:00:00Z",
        "id": "987654321",
        "name": "test",
        "webUrl": "https://test.com",
        "displayName": "Test Site",
        "isPersonalSite": false,
        "siteCollection": {
          "hostname": "test.com"
        },
        "root": {}
      }
    ]
  }
}

Now i tried to do same as you tried (for mocking the api part, i just kept the given JSON object in compose and then used it in Parse JSON )

Hope this helps !

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[vidarv]

Thank you for answering @Nived_Nambiar I am sorry but i got the following error

The 'from' property value in the 'query' action inputs is of type 'Null'. The value must be an array.

[Nived_Nambiar]

Hi @vidarv 

Have you checked whether the output of http get request action, 

Also show how you have designed the flow ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[vidarv]

Hi @Nived_Nambiar 
Yes there are Output from http request that showes up in the parse json output,  or was there something else you where thinking. I have showe the flow in pictures, but here are a overview. Http request are using microsoft graph and behind is a api with fill application rights

[ManishSolanki]

Hi @vidarv 

Pls update the expression used in Compose action, try this one:

body('Parse_JSON')?['value']

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[S-Venkadesh]

Hi @vidarv ,

I've tested your use case, and it works successfully for me.
Please follow the steps outlined in the snapshot:

I hope this information is helpful. If it is, please consider giving a thumbs up 👍.

Best regards,
Venkadesh Sundaramurthy

[vidarv · Accepted solution]

Thank you for answering @ManishSolanki @S-Venkadesh 
In my compose i set

body('Parse_JSON')?['value']

and in the Filter array from i used

outputs('Compose')

Both of the soloutions work 🙂
Out of this I got 19500 records instead of 49 000. Any suggestion of how to use apply to each of the filter tu run the http throug every id to get subsites ?

[S-Venkadesh]

Hi @vidarv 
You can Extend the flow by adding another HTTP action with below endpoint to retrieve the subsites
GET https://graph.microsoft.com/v1.0/sites/{site-id}/sites
Sample Screenshot:

I hope this information is helpful. If it is, please consider giving a thumbs up 👍.

Best regards,
Venkadesh Sundaramurthy

[vidarv]

Thank you for answering @S-Venkadesh . The graph command you are reffering to, are not giving me subsites. When testing i have to use beta and the following command https://graph.microsoft.com/beta/sites/@{items('Apply_to_each')?['id']}/pages/microsoft.graph.sitePa.... Your link will just give me main sites. 

[S-Venkadesh]

Hi @vidarv 

Could you please review if you have attempted to use the GET request with the endpoint https://graph.microsoft.com/v1.0/sites/{site-id}/sites as indicated below?
For further information regarding the API endpoint, please refer to this link:  https://learn.microsoft.com/en-us/graph/api/site-list-subsites?view=graph-rest-1.0&tabs=http

I hope this information is helpful. If it is, please consider giving a thumbs up 👍.

Best regards,
Venkadesh Sundaramurthy

[vidarv]

Hi @S-Venkadesh I have tried the graph command and it do not work in our tenant, but when i try this

 GET /sites/{site-id}/pages/microsoft.graph.sitePage

it works. Thank you for helping.