topic RE: How to know whether a folder is empty - Get Files question in Product Forum

How to know whether a folder is empty - Get Files question

christybu — Tue, 29 Dec 2020 19:36:00 GMT

Hello, I'm trying to copy a file to a destination folder.
Before copying, I need to check whether the folder is empty,
if it's not empty, I need to trigger a email with filenames found in the folder, and
if it is empty, just copy.

I tried to use action Get Files, and follow by a Decision stage using the Successful Flag generated by the VBO.

The problem is no matter there is or is not file in the folder, the 'Success Flag' is always TRUE, so it always go to email sending stage?
Besides, how can I get the file names (normally 1 or 2 files only) from the Collection and include them in the email?

------------------------------
Regards,
Yingjie
------------------------------

RE: How to know whether a folder is empty - Get Files question

HarshitRawat — Wed, 30 Dec 2020 12:22:00 GMT

Hello,

Below is a sample flow which can serve your purpose

First you would use the same Get Files action on the folder;

The File details ( if any file is present ) would be in the output collection of Get Files

If there are any files present the rows in the collection would be greater than 0 and the process can get file names and send email

To extract the file names you can use a loop and keep on appending the values of Files collection.Name in a data item and append that data item in the email

let me know if you face any issue

------------------------------
Harshit Rawat
------------------------------

RE: How to know whether a folder is empty - Get Files question

vinodchinthakin — Sat, 22 May 2021 12:07:00 GMT

Hi Yingjie

You can use this VBO https://digitalexchange.blueprism.com/dx/entry/113833/solution/atcs---utility-file-management which helps to get files/folder count

------------------------------
vinod chinthakindi
------------------------------