Verify subfolder exist and return the path

(0) Share

Report

Posted on by ZN-01071546-0

I am trying to create a flow that will store emails in a folder on SharePoint when sent in about a person's account. The issue I am having is having the flow verify if the subfolder exist since it would put the email in the MISCELLANEOUS folder if a folder for that account does not exist yet. As you can see below, the folder path is by Year, Type, the account number with name, and then the COMMUNTICATIONS folder where the email would be stored.

I have already built the why for the flow to find out the folder for the year but I am stuck on how Power Automate can confirm if there is a folder with the account number and name inside of the Folder A or B. If Power Automate can verify the sub folder, then I would need to have the output to create the path to the folder so I can plug that part in to the reset of the flow to store the email.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

chiaraalina 2,447 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ZN-01071546-0

Use Get files (properties only) to retrieve the account folders, filter by account number, and use the returned {FullPath} to build the target /COMMUNICATIONS path. If no match is found, route the email to MISCELLANEOUS.

Split email subject:

If the account number is always the first value in the email subject:
@{split(triggerOutputs()?['body/subject'],' ')[0]}

Get all folders (and nested)

Filter by name

Condition:

If true ->

first(body('Filter_array'))?['{FullPath}']

You can then create the email file at this path:
concat(first(body('Filter_array'))?['{FullPath}'],'/COMMUNICATIONS')

Let me know if it worked!

Was this reply helpful? Yes No
ZN-01071546-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @chiaraalina,

I tried what you suggested and the Filter array output is not returning anything. I created this test flow as a copy of what you did in your suggestion, Please let me know what you need to help fix the action.

Also, how did you setup the Condition to test true or false?

Was this reply helpful? Yes No
ZN-01071546-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @chiaraalina,

I am just sent this message since the last one's @ did not seem to work.

Was this reply helpful? Yes No