web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : PRJpunknwH1+kpRF9a478g
Power Automate - Using Flows
Answered

How to set up the conditions to filter out Folders

Like (0) ShareShare
ReportReport
Posted on 26 Nov 2023 08:19:53 by 16

I created a Folder1 in SharePoint, and within Folder1 there is a SubFolder2. Both Folder1 and SubFolder2 may occasionally have documents uploaded, such as Excel files. Now, I need to implement the following: when a .xlsx file is uploaded to Folder1, an email notification is triggered to inform me of the new file arrival; when a new .xlsx file is uploaded to SubFolder2, no action is taken and it is directly filtered. My current difficulty is how to set up the conditions to filter out SubFolder2?

I have the same question (0)
  • RY0660 Profile Picture
    16 on 27 Nov 2023 at 03:01:24
    Re: How to set up the conditions to filter out Folders

    Great, it worked.Thanks again.

    RY0660_0-1701055925738.png

     

  • RY0660 Profile Picture
    16 on 26 Nov 2023 at 16:23:46
    Re: How to set up the conditions to filter out Folders

    Hi Nived,

    Thank you very much for your prompt reply.

     

     

  • Verified answer
    Nived_Nambiar Profile Picture
    18,014 Super User 2025 Season 2 on 26 Nov 2023 at 12:34:00
    Re: How to set up the conditions to filter out Folders

    Hi @RY0660 

     

    try this trigger condition within your trigger :

     

    Nived_Nambiar_0-1701001937742.png

     

    @and(endsWith(triggerOutputs()?['body/{Path}'],'Folder1/'),endsWith(triggerOutputs()?['body/{FilenameWithExtension}'],'.xlsx'))

     

    This condition checks whether the parent folder where the file is uploaded is of Folder1 and if the file has the extension .xlsx 

     

    See the flow designed for this :

    Nived_Nambiar_1-1701002007122.png

     

    Sharepoint folder structure used:

    Nived_Nambiar_2-1701002032241.png

     

    Hope it 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! 🙌

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 736 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 396 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 339

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow
Loading complete