How can i Extract the entire folder hierarchy

Help Activities
,
21

1/ Other question : i notice that when the folder is empty its not write on excel, i need to have all the names folders even when they are empty

2/ ok so i can do the same with sharepoint ?
If yes i need the tenant ID and other information to my IT departement ?
@Shiva_Nikhil

22

@Soudios
you can write the name of the folder even it is empty

23

yes but the bot doesnt do that so far

24

@Soudios

you need to use condition

like if count=0
Then assign foldername to a variable

you can access the sharepoint folder files using UiPath Activities

hope this helps

25

can you show me how can i do plz ?

https://forum.uipath.com/uploads/short-url/oj6JkmjQHBByj50430xvMOerhZD.xaml

26

@Soudios

foldercase.xaml (14.8 KB)

Hope this helps

27

its not working i have the same result, i don’t have the main folder where there is nothing inside
@Shiva_Nikhil

28

your folder has more than 5 levels
you can edit at build data table add 1 level

29

@Soudios

create a dummy folder and try with that it will work

cheers

30

i added more that 15 level in the data table

image

31

???
That’s what i did, i create folder with no files inside and i can’t see it in the excel file

32

number of columns is same number of levels in your folder
but if it not permanent, we need use dynamic variable

33

@Soudios

image

For me its working with empty files in a folder

hope this helps

34

its not working for me, as u can see there is a folder “test” and i can’t see it in the excel file because the folder is empty

image

image
image243×567 4.71 KB

35

i added many column to not have this issue but now i need to have all the folders with the extraction not only when there is a file inside

36

I want to know if the folders you need to get have a fixed number of levels?
if yes please tell me your folder structure, for example tree

37

its better to have dynamic variable, but for now i have 13 levels, but maybe i will have more levels later

38

@Soudios

can you check the below code and follow the steps and place values in the add datarow

Main.xaml (17.2 KB)

39

ok i understand volatility will be ok with any level, if your current is 13 then you can leave 13 columns,
it’s evening in vietnam, i’m going to think about how to use volatility with all levels,
For now, to solve it urgently, you can use 13 columns temporarily, I will respond soon

40

i don’t know what to put into “ArrayRow”
image