Action failed and no dependent action succeeded. path for the new folder is not provided error

[Veblitz]

I have uploaded the below excel in sharepoint document library in order to power automate to create folder structure

Flow steps

Expanding Applyto each step

Expanding Apply to each step

[FLMike]

Hi @Veblitz 

An Apply to Each is usually for Multiple Loops.

If the first loop isn't the one that failed, move to the next one until you find it.

Your Apply to Each should show like 1 of 4 and use the arrows to move.

Please show your Apply to Each Opened in the Flow that failed

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Veblitz]

Im able to get rid of error but im unable to create below structure dynamically from excel values 

[NathanAlvares24]

Hi @Veblitz !

Please see below flow of mine. I replicated same and it works. I'll explain it on the way with every screenshot for you to understand.

Flow:

Pic 1

Pic 2

Pic 3

Let me explain now:

I guess till list rows is already understood.

I added these two actions because of the case where you have all columns empty in a row based on your data from excel:

This will help to filter the rows based on an expression:

@or(not(equals(trim(item()?['Month']), '')), not(equals(trim(item()?['Country']), '')), not(equals(trim(item()?['Customer']), '')), not(equals(trim(item()?['New']), '')))

Please ignore the warning above this action after inserting this action and going back to basic mode. It will work for sure.

So example output will be for this:

And its just what you need. Use this body in the output of apply to each action.

The condition 5 (change the name as you want. I just kept it as the same) is really important. This is the year folder.

2024
│
├── 1
│   └── USA
│       └── Microsoft
│           └── Renewal
│
├── 2
│   └── UK
│       └── ABC
│           └── Pending
│
└── 3
    └── [Country Not Specified]
        └── Cool
            └── Approvals

You gave me this right? Now see in the case of this:
└── 3
    └── [Country Not Specified]
        └── Cool
            └── Approvals

You know based on above, the year folder serves as a parent folder to the rest as the year column for the other two rows are empty. This is what the condition does. Store this year folder name in a variable and use it throughout till it encounters another year in that column of which it will overwrite the previous year.

Now I will give expressions for each condition and its yes and no parts:

1) Condition 5

Expressions used:

(type these in the expression tab)

Condition 5:
not(equals(items('Apply_to_each')?['Year'],''))
true (type this in the expression tab)

directly paste the following in the "Folder Path" section:

Create new folder 5:
@{items('Apply_to_each')?['Year']}

2) Condition

Expressions used:

(type these in the expression tab)

Condition:
not(empty(items('Apply_to_each')?['Month']))
true (type this in the expression tab)

directly paste the following in the "Folder Path" section:

Create new folder 4:
@{variables('Year')}/@{items('Apply_to_each')?['Month']}

3) Condition 2

Expressions used:

(type these in the expression tab)

Condition 2:
not(empty(items('Apply_to_each')?['Country']))
true (type this in the expression tab)

directly paste the following in the "Folder Path" section:

Create new folder 3:
@{variables('Year')}/@{items('Apply_to_each')?['Month']}/@{items('Apply_to_each')?['Country']}

4) Condition 3

Expressions used:

(type these in the expression tab)

Condition 3:
not(empty(items('Apply_to_each')?['Customer']))
true (type this in the expression tab)

directly paste the following in the "Folder Path" section:

Create new folder 2:
@{variables('Year')}/@{items('Apply_to_each')?['Month']}/@{items('Apply_to_each')?['Country']}/@{items('Apply_to_each')?['Customer']}

5) Condition 4

Expressions used:

(type these in the expression tab)

Condition 4:
not(empty(items('Apply_to_each')?['New']))
true (type this in the expression tab)

directly paste the following in the "Folder Path" section:

Create new folder:
@{variables('Year')}/@{items('Apply_to_each')?['Month']}/@{items('Apply_to_each')?['Country']}/@{items('Apply_to_each')?['Customer']}/@{items('Apply_to_each')?['Name']}

Input:

Output:

In 2022:

In 2023:

The other one of 2023 has Month column empty hence won't create the folders for the subsequent data.

In 2024:

This flow will surely guarantee you 100% success in creating the folders.

I hope this helps. Please do let me know once tried.

[FLMike]

What exactly is the error and which exact action is failing. If there is no failure it worked, otherwise there will be an error.

Which action isn't working? Are the folders already there/ Are you certain the Document Library is correct?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey