How to create runtime folder with today's date in SharePoint

[Neha_Aggarwal1 (Neha Aggarwal)]

Hi ,i am handling one sharepoint automation where i need to create runtime folder with todays date .

as shown in the screenshot , this is the path where i need to create the folder.

in the second screenshot , shown how i m doing but its not working …i did like we used create folder in normal path .

[Vijay_0815 (Vijay Kumar)]

After your exact location give backslash and your date variable (your date should not contain backslash(/), if date contains slash, it will crate another folder. so please avoid slash and give any other symbols). it will create date folders.

[prateek.mehandiratta9 (Prateek Mehandiratta)]

@Vijay_0815

another folder. so please avoid slash and give any other symbols). it will create date folder

Add this to your path with a slash, that should do it.
DateTime.Now.ToString(“ddMMyy”)
or
DateTime.Now.ToShortDateString

[Neha_Aggarwal1 (Neha Aggarwal)]

That I already tried …but it’s not creating folder in SharePoint…same method I tried for normal desktop path there folder created

My query is this only in SharePoint this concept is not working

[Neha_Aggarwal1 (Neha Aggarwal)]

plz check the screenshot , but this concept is not working in sharepoint

[Anil_G (Anil Gorthi)]

@Neha_Aggarwal1

Please try this

How to create runtime folder with todays date in sharepoint

@Neha_Aggarwal1 Do a find files with Now.ToString(“MMddyyyy”) if the find files does not return any output that is results.count=0 then create folder …by getting the previous folder using find files…else folder is already present move ahead Cheers

Path ecosts will not work with sharpeoint

Cheers

[Neha_Aggarwal1 (Neha Aggarwal)]

could u plz check where i did wrong because solution is not working, its throwing bad request error on create folder activity

[Anil_G (Anil Gorthi)]

@Neha_Aggarwal1

First of all path exists will not work on sp folders

Follow these steps

1. Use find files or folder activity nad give query for todays folder Now.ToString("MMddyyyy") and sub folder will be the folder till where it is to be created say till sucess in your case and assign output to results variable say results
2. Now use if condition with results.Count>0
3. On then side the folder is already created
4. On else side it is not created so use find files or folders activity again but now query will be success and sub folder will be till the folder containing success
5. After find files use create folder(this should be the office 365 activity) and give folder name as Now.ToString("MMddyyyy") and in folder location driveitem give the output of find files /folder results(0)

Cheers

[Neha_Aggarwal1 (Neha Aggarwal)]

in the 4th point i did not understand query success…what exactly i have to write in that

and in the 5th point …which results(0) is this that comes from second file folder activity which is in else part?

[Anil_G (Anil Gorthi)]

@Neha_Aggarwal1

4. Success is the folder in which you need to create your final date folder so query shpuld be success and subfolder shpuld be till Archive
5. Yes this is the results of the find files in the else side

Cheers

[Neha_Aggarwal1 (Neha Aggarwal)]

i m getting error on the create folder activity …index was outside the bond of array

[Anil_G (Anil Gorthi)]

@Neha_Aggarwal1

Query should be "Success"

And sub folder should be the remaining value before success thats is "Dev/…./Archive"

Cheers

[Neha_Aggarwal1 (Neha Aggarwal)]

@Anil_G thanks for ur help,it worked