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
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,818)