Dynamic File Path in New Sharepoint

Thanks, Sam. I can understand the AI route, but if it’s based on LLMs, I don’t want to risk hallucinations.

I made the following change:

1. I use “Find Folder” for the folder I want to search inside (to target its nested folders)
2. I use “Get Folder Contents” and plug in the Folder ID from the “Find Folder” step to find all the nested folders (one of which will be my INSTALLATION folder).
3. I run a Javascript step with the following code to parse through the results of the “Get Folder Contents” step, find the Folder name (INSTALLATION in my case), and grab its corresponding Folder ID:

const names = inputData.folder_names;

const ids = inputData.folder_ids;

// If Zapier passes them as strings instead of arrays, fix that

const nameArray = Array.isArray(names) ? names : names.split(',');

const idArray = Array.isArray(ids) ? ids : ids.split(',');

// Clean values (important for matching)

const cleanedNames = nameArray.map(n => n.trim());

// Find index of target folder

const target = "INSTALLATION";

const index = cleanedNames.findIndex(n => n === target);

if (index === -1) {

  throw new Error("Folder 'INSTALLATION' not found");

}

// Get matching ID

const folderId = idArray[index];

return {

  folder_id: folderId

};

^Someone with better Javascript knowledge would likely be able to clean this up. Not sure if either of the strings to arrays step, or the trim step are needed.

Here are the “Code by Zapier” configurations for this Javascript step, with the input data pulling from the “Get Folder Contents” step. 

I then take the folder ID from the Javascript output and use it in a Create Folder step. I tested this and it seems to be working fine.

Having said that, I’m glad dynamic file paths have at least been discussed because these four steps used to be ONE. That’s very disappointing. Not a fan of “updates” that degrade capability.

It’s pretty crazy that grabbing a folder in a group of nested folders dynamically is not a thing. It seems like such a basic function someone might run into. The only goal here is to create a folder inside a nested set of folders. The nested folder just changes with the year because we’re grouping business activity within the year. It just seems like a very basic functionality.

Hopefully it can get resolved. This seems like more of a Microsoft (Sharepoint) issue than a Zapier issue, but regardless this has become very inefficient and hopefully there’s a resolution.