Unanswered

Variable as Folder Path

(0) Share

Report

Posted on by jsbmk

Basically I have a lot of units in a project I am working on and want to create a SharePoint folder for each one named after each project. The Path argument of "create new SharePoint folder" doesn't seem to recognize variables as dynamic arguments so I've tried passing the data in through a .json file and the compose action but my flow keeps getting stuck in the apply to each function at the end.

Running the program without the create folder action shows that the values I want to use to name the folders as are coming out of Compose 3 just fine. So it's something with the create folder hanging everything up.

Is it possible to pass in a variable as the the Path argument when creating a new SharePoint folder? Or is there a reason I'm missing as to why the apply to each is getting stuck?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

David_MA 14,056 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Since you don't show what you are actually composing in the Compose actions, it is hard to tell what the problem may be. However, this has worked for me without any issues:

In the Create file action, select the root level folder where you want the subfolders created. Then be sure that your variable data path begins with a backslash as shown above in the Compose Folder Name action. Don't confuse it with the Compose Folder Path action. That one creates the link to the folder that I use in an e-mail action later on.

My naming convention is the current year and the ID of a forms submission padded with zeros. It results in folders named like:

Was this reply helpful? Yes No
jsbmk 2 on at

Like (0)

Report
Copy link

Link copied!

Oops. Here's what I have currently:

Compose 1: base64(outputs('Get_file_content_using_path')?['body'])
Compose 2: base64ToString(outputs('Compose'))

The first two composes are used to get the json data from my file. The data is then parsed into the format:
[
  {
    "UnitNumbers": "Fxxxxxx1 "
  },
  {
    "UnitNumbers": "Fxxxxxx2 "
  },
...
]

Then attached is what I have inside the apply to each loop

Was this reply helpful? Yes No
David_MA 14,056 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

What you are generating cannot be used as a folder path. It contains invalid characters and line returns that are not allowed. A folder path would be something like.

/documents/expenses/reports

Was this reply helpful? Yes No
S-Venkadesh 1,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @jsbmk ,
I have replicated the issue you mentioned and here are the steps and details of what worked for me:
I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No