Unanswered

Trigger Condition when a file is uploaded inside a specific folder and get the main folder ID

(0) Share

Report

Posted on by johnjohn123

3,514

I have a SharePoint online site which contain a document library named "Customer Share" >> and inside this library we have a folder named "Clients" >> and inside the "Clients" folder we have around 10,000 sub-folders representing clients.

Here is a sample of the folder structure:-

- Customer share

- Clients

- ClientA

- Contracts

- Agrements

- others

- ClientB

- Contracts

- others

- ClientC

- ClientD

- Attachments

- others

Now i want to define a trigger condition when a document is created or modified ONLY under the "Clients" fodler's sub-folders. for example to trigger the flow if someone add a file under "Clients/ClientA/Contracts" or under "Clients/ClientA/" or under "/Clients/ClientA/Contracts/2023/".. while the flow should not run if someone add or modify a file under "/Attachments/" or "others" or directly under "/Clients" .. is this possible?

Second Point. i also need to get the folder Id of the related client sub-folder. for example if a file is uploaded inside "/Clients/ClientA/Contracts/2023/" i want to get the ID of the ClientA folder..

Thanks

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

Try this as your trigger filter:

greater(length(split(triggerOutputs()?['body/{Path}'],'/')),2)

If the length of the array resulting from splitting the path on a / is greater than 2, you are in a subfolder

Likewise, you can use a SharePoint Get folder metadata using path action to get the upper level folder ID.

You will need to supply the path. You can build the path from the result of a split:

split(triggerOutputs()?['body/{Path}'],'/')

You can refence the individual elements to build the path to an upper level folder.

Let me know if you need more help.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer thanks will try this any update you accordingly.. Thanks

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer but how i can differentiate if the file is been uploaded to these folders "/Attachments/" or "others" or directly under "/Clients" ?? you appraoch assume that there is only one folder named Clients.. am i correct? while we have folders with the same level as Clients named Attachments & Others and so on..

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

OK - so how about checking for /clients/ in the path?

I am assuming there is only one directory called clients and you are interested in anything blow that.

Something like this:

greaterOrEquals(indexOf('/Clients/',[Reference to the path from Dynamic props]),0)

If /Clients/ is not in the path, indexOf will return -1

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer thanks for the reply, so i will need to merge the 2 condition together ? am i correct?

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@johnjohn123

An expression like greaterOrEquals(indexOf('/Clients/',[Reference to the path from Dynamic props]),0) is all you need for your trigger filter.

You can use the split() example in my screen shot above when retrieving the folder metadata.

Give it a try and post screen shots if you need more help.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer ok will try them both and keep you posted. Thanks

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer unfortunately when i added the 3 trigger conditions together ,, the flow will never run.. i created a new question @ https://powerusers.microsoft.com/t5/Building-Flows/quot-When-a-file-is-created-or-modified-property-only-quot-with/m-p/2242909#M248870 if you can have a look.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer i think the index greaterOrEquals(indexOf('/Clients/',[Reference to the path from Dynamic props]),0)

need to be backwards as follow:-

greaterOrEquals(indexOf([Reference to the path from Dynamic props],'/Clients/'),0) ??

Was this reply helpful? Yes No