cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sinnamora
Frequent Visitor

SharePoint - List folder action

Hi everyone,

 

I have to count the directory in a specific path. 

I tried with a List Folder then with length of his body but it doesn't work.

It's beacause of the number of directory in it.

 

Any suggestions?

 

Thanks in advance.

Silvia I.

 

 

 

 

7 REPLIES 7
MarconettiMarco
Super User
Super User

Hello @sinnamora ,

please share the flow steps in edit mode and share also the error you got, so that we could help you.

 

BR,

Marco

edgarsimoes
Microsoft
Microsoft

Hello, @sinnamora 

 

Based on the context that you give, I did a reproduction of your issue on my side. Of course you can share us your flow, like @MarconettiMarco  told.

 

Regarding my reproduction:

1st - My target directory:

edgarsimoes_0-1656675456485.png

 

2nd -  My flow:

edgarsimoes_1-1656675508721.png

 

3rd - the expression that I used:

 

length(outputs('Get_files_(properties_only)')?['body/value'])

 

 

And, this was my result:

edgarsimoes_2-1656675582568.png

 

Hope this help you.

 

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

 

Happy Automating,

 

Edgar Simões

 

Hi Marco,

 

thanks for replying back to me. That's my flow.

 

sinnamora_0-1656917579026.pngsinnamora_1-1656917603474.pngsinnamora_2-1656917622248.png

 

Nice day,

SI

Thanks @sinnamora ,

please share also the error you got and the expression length you're using in the Condition control.

 

BR,

Marco

Hi edgarsimoes,

 

I tried this solution but the result is not correct.... 

On my Compose appeared 100 but in this directory are almost 14.000 directory.

I have to count how many directories are into the root...

 

Thanks for helping me.

 

bye

SI

Hello, @sinnamora 

 

Sorry to hear that, I tried again on my side adding more file and folder within the root, and I was able to get the exact number that I was expecting.

 

Can you share your a flow on your side following the steps that I gave you? Just to understand if something is missing or if It needs something more to get it right.

 

Happy automating,

 

Edgar Simões

Hi @edgarsimoes ,

 

for a realistic test you have to move almost 15.000 folders into the directory. I tried my flow with DEV environment and it works.

 

Bye,

S.I.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,719)