Including Sub-Folders in a Flow Query (Advanced)

[SolarWill]

Hello.

One very large disappointment from Microsoft is the fact that they don't support Alert Flows for sub-folders, only for the folder selected, or the top level/parent.

I was wondering if there was a way to code this into the JSON file then import into Flow.

Check out the default code:

            },
            "method": "get",
            "path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://yoursitehere.com/folderiwanttobealertedfor'))}/triggers/onupdatedfile",
            "queries": {
              "folderId": "%252fALL%2bFILES%252fPARENTFOLDER",
              "includeFileContent": true,
              "queryParametersSingleEncoded": true,
              "inferContentType": true,
              "includeSubFolders": true
            },

Notice the last line

"includeSubFolders": true

I added that, and obviously it does not work. Microsoft - it is literally this easy, why? Because this does not work - I need to make over 300+ flows JUST to support alerts for all sub-folders under a parent.

Anyways - does anyone know if I can add/change a trigger

/triggers/onupdatedfile

 To maybe

/triggers/onupdatedhierarchy

Or - can I modify this query?

"folderId": "%252fALL%2bFILES%252fPARENTFOLDER", "code to include folders underneath"

This is the best way I can exlain myself - I apologize if it appears like a rant, but I've got 300+ flows I need to make to be alerted just under one parent folder because Microsoft doesn't support this.

[Pieter_Veenstra · Accepted solution]

Is this the trigger that you are after:

Just leave the folder blank and all files/folders will trigger your flow.

By the way editing the json of a flow is not recommended. If you want to do this then please look at Azure Logic Apps instead.

[SolarWill]

Pieter, interesting reply.

This could be a solution - but I need alerts for when a file is created/modified in a parent folder and folders underneath.

I noticed that picture is of a "Properties Only" template - what does that mean?

I don't want to be notified of what changes in an entire document library, just one parent folder in that library and everything underneath that folder.

Thanks for the reply.

[Pieter_Veenstra]

You should be able to leave the folder configuration blank and start the flow with a sindition in which you check the folder name in the Url. It does mean that the flows will run on every document chnage, however you could put your alerting local inside a condition.