Creating folders and sorting into subfolder

[FH1000]

I have a flow that is triggered when a new SQL item is created:

This flow creates a folder based on a project number: 133841 for instance

I would like to be able to put this into a sub folder: 133000-133999 automatically

So when we get to 134000 it get put into a new subfolder 134000-134999

[efialttes]

Hi!

So your plan is to convert project number into an int, div by 1000. Then convert result back to string, search for folder names starting with result, right? If no Folder found, create a new one.

Thanx!

[ChristianAbata]

hi @FH1000  please try this, I suppose you are using Sharepoint but this solution works with onedrive to.

replace(string(outputs('ValueSQL')),'000','999')