Exclude subfolder in "find file in folder"

Like (0) Share

Report

Posted on 20 May 2019 06:07:46 by MathiasJ

Hi!

I have a flow, which I want to schedule every 20th each month.

This flow should check if there are any files in a specific folder on my OneDrive, BUT exclude subfolders and files in there.

If there are any files in that exact folder, attach those files in an email and send.

My issue is that I cant figure out how to ignore the subfolder.

Any ideas?

All responses (7)

Answers (0)

RyanRhode 2 on 19 Jul 2021 at 17:32:58

Like (0)

Report

Re: Exclude subfolder in "find file in folder"

Hello - I am trying to achieve the same using Power Bi - anyone have helpful tactics to ommit certain subfolders?
Current function is simply ' Source = Folder.Files("file location")

I am trying to ommit specific sub folders within those parent files.
RichardF 2 on 28 Jan 2021 at 08:46:58

Like (0)

Report

Re: Exclude subfolder in "find file in folder"

Hi Barry, I know this is an old post but just wanted to say this worked perfectly for me when I had the same issue today, so many thanks 👍

cheers

Richard
MathiasJ 4 on 30 May 2019 at 19:42:14

Like (0)

Report

Re: Exclude subfolder in "find file in folder"

It didn't quite work for me, but I managed to validate on the file path that If [file path] contains [subfolder name], it will skip that file.
v-bacao-msft on 29 May 2019 at 10:12:39

Like (0)

Report

Re: Exclude subfolder in "find file in folder"

Hi @MathiasJ ,

Any update?

Best Regards,
v-bacao-msft on 21 May 2019 at 06:25:53

Like (0)

Report

Re: Exclude subfolder in "find file in folder"

Hi @MathiasJ ,

Below is my test result. In Apply to each, only the files and subfolders in the specified folder are traversed, the files in the subfolders are not included.

And I used Condition to exclude the subfolders, so I can only get the file contents of the files in the specified folder.

Flow configuration:

The specified folder in OneDrive:

Flow run history:

Only traversed 7 items, excluding subfolders, and only getting the contents of the file when Condition is true.

Best Regards,
MathiasJ 4 on 20 May 2019 at 13:08:26

Like (0)

Report

Re: Exclude subfolder in "find file in folder"

Unfortunately, the search is still looping through the files in that subfolder. I am only interested in files in the parent folder
v-bacao-msft on 20 May 2019 at 06:44:46

Like (0)

Report

Re: Exclude subfolder in "find file in folder"

Hi @MathiasJ ,

You could use Is folder? to exclude subfolders and files inside it in the specified folder.

Image reference:

Best Regards,

Community site session details

Exclude subfolder in "find file in folder"

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Exclude subfolder in "find file in folder"

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates