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
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!
Proud to be a Flownaut!
hi @FH1000 please try this, I suppose you are using Sharepoint but this solution works with onedrive to.
replace(string(outputs('ValueSQL')),'000','999')
Proud to be a Flownaut!
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
45 | |
41 | |
39 | |
37 | |
32 |
User | Count |
---|---|
87 | |
85 | |
51 | |
48 | |
39 |