Power Platform Community Forum Thread Details

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: