cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chrono9084
Helper I
Helper I

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

15 REPLIES 15
JohnAageAnderse
Memorable Member
Memorable Member

Hello @Chrono9084 

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

Kind regards, John

v-alzhan-msft
Community Support
Community Support

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:

1.png

 

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.

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

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

@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?

I must have done this wrong 😂

I hate being so new to this.

 

image.png

Capture.PNG

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.

FlowFileToChannelPost1.pngFirst 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.

FlowFileToChannelPost2.png

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

Kind regards, John

@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.

1.PNG2.PNG3.PNG

 

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

@JohnAageAnderse 

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

Folder Path: Shared Documents/Test Channel 1/

 

4.PNG5.PNG6.PNG7.PNG

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

@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"
  }
]

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

@JohnAageAnderse 

 

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

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!

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,748)