When a file is created or modified (properties only) not tracking subfolders

[Chrono9084]

I built my flow based on this thread: https://powerusers.microsoft.com/t5/Building-Flows/Getting-channel-ID-for-channels-in-Teams/m-p/1989...

The problem I am having is that files placed within subfolders of each teams file area seem to not be caught by the flow.  Is there something I need to do to make this first step/node search past the first folder?

[JohnAageAnderse]

Hello @Chrono9084 

Please provide a screenshot of the trigger (expanded) so we can see the setup 🙂

Kind regards, John

[v-alzhan-msft]

Hi @Chrono9084 ,

Please leave the folder field blank and trigger would be triggered for all the files in the library.

And if you only want to do any actions in the flow when the files in a special folder is created or modified in the library, you could add a condition under the trigger to check for the file path:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chrono9084]

@JohnAageAnderse 

substring(triggerBody()?['{Path}'],17,sub(length(triggerBody()?['{Path}']),18))

[JohnAageAnderse]

Hello @Chrono9084 

Your trigger seems fine, except that I would use "When a file is created" instead! Else you will get a post everytime someone updates the document 🙂

Suggest you to use a Filter array action after your List channels action. Use the triggers Folder path contains Channel list name for the condition.

Then loop through the output from the Filter array and post accordingly.

Kind regards, John

[Chrono9084]

@JohnAageAnderse I will try this....but if my trigger is fine...why would it not be catching files created in subfolders?

Also (side question), is there a way to filter out new folders from showing up as new files?

[Chrono9084]

I must have done this wrong 😂

I hate being so new to this.

[JohnAageAnderse]

Hello @Chrono9084 

Your trigger is ok, but you will have to handle the situation when a file is modified - do you still want to post about that?

Anyway, I created a small flow that may do what you need - when a file is created in a teams channel.

First action is the trigger:

When a file is created.

Second action is the List channels in my teams.

Third action is the Filter array.

The From is filled with the Channel list

The condition is filled with:

- Folder path from the trigger

- The operation contains

- The Channel Id

In the last actions, an Apply to each is used to loop through the output from the Filter array action.

In the loop is then the action to post a message in the channel.

Kind regards, John

[Chrono9084]

@JohnAageAnderse 

Hey John, thank you for taking so much time to help me.

I recreated your method and it almost worked.  It seems to be seeing subfolders now but it simply will not create the message.

[JohnAageAnderse]

Hello @Chrono9084 

From your previous run, can you expand the trigger and see what value the path property has? ... or post the whole trigger output here 🙂

Kind regards, John

[Chrono9084]

@JohnAageAnderse 

Full Path: Shared Documents/Test Channel 1/BIM360 Model Publishing Guide.docx

Folder Path: Shared Documents/Test Channel 1/

[JohnAageAnderse]

Hello @Chrono9084 

Now in your run, expand the Filter array action and show all the data in the From field or scroll down till you can see that it contains a channel "Test Channel 1".

Kind regards, John

[Chrono9084]

@JohnAageAnderse 

[
  {
    "id": "19:63a657d7eb8b47eb90d704163e234b57@thread.tacv2",
    "displayName": "General",
    "description": "This is a team to test things out.",
    "email": "",
    "webUrl": "https://teams.microsoft.com/l/channel/19%3a63a657d7eb8b47eb90d704163e234b57%40thread.tacv2/General?groupId=5008a5a9-bb0e-4663-a61b-149325553a3d&tenantId=3d2de914-3e4f-4ef9-8cd4-842187e05f59"
  },
  {
    "id": "19:43838f60773b4cb7bbdc97d510e36ffd@thread.tacv2",
    "displayName": "Test Channel 1",
    "description": null,
    "email": "",
    "webUrl": "https://teams.microsoft.com/l/channel/19%3a43838f60773b4cb7bbdc97d510e36ffd%40thread.tacv2/Test+Channel+1?groupId=5008a5a9-bb0e-4663-a61b-149325553a3d&tenantId=3d2de914-3e4f-4ef9-8cd4-842187e05f59"
  },
  {
    "id": "19:ea964a96d53f499587a7a33d49b42f87@thread.tacv2",
    "displayName": "Test Channel 2",
    "description": null,
    "email": "",
    "webUrl": "https://teams.microsoft.com/l/channel/19%3aea964a96d53f499587a7a33d49b42f87%40thread.tacv2/Test+Channel+2?groupId=5008a5a9-bb0e-4663-a61b-149325553a3d&tenantId=3d2de914-3e4f-4ef9-8cd4-842187e05f59"
  },
  {
    "id": "19:fed1b97c640c4d5781049a9ab2f73bd8@thread.tacv2",
    "displayName": "Test Private Channel 1",
    "description": null,
    "email": "",
    "webUrl": "https://teams.microsoft.com/l/channel/19%3afed1b97c640c4d5781049a9ab2f73bd8%40thread.tacv2/Test+Private+Channel+1?groupId=5008a5a9-bb0e-4663-a61b-149325553a3d&tenantId=3d2de914-3e4f-4ef9-8cd4-842187e05f59"
  }
]

[JohnAageAnderse · Accepted solution]

Hello @Chrono9084 

The channel name "Test Channel 1" is in a property named DisplayName - so in the Filter array, use Channel Displayname or Channel name (not sure which) instead of Channel Id!

Kind regards, John

[Chrono9084]

@JohnAageAnderse 

Awesome!  Thank you!  Not only did you help me fix this but you taught me something.  🙂

[Anonymous]

Hello I am trying your solution for a SharePoint Library.

I am currently building a flow so that an Email is sended if we modify a field (column of the SharePoint).
I try to use the "when a file is added or modified (properties only)" trigger but on only ONE column of the SharePoint.
If I modify any other column I don't want the flow to trigger.

So with your solution I put in the condition:

"Full Path"  contains "FolderName"

But what is the "foldername" field please? Is it only the SharePoint column name (in text)? or "triggerbody()?['FolderName']"? or the "path" of this column? 

I am a little lost to be honest. Thanks!