Error Message - Pulling Excel File that Doesn't Exist

Hello there,

I have the following workflow (see below) where I am picking the first three files:

The interesting thing is, I only have 3 excel files into that specific folder, but as you can tell from the first anchor, it's picking up 4 files. The 4th file is the one highlighted below - and that's the file I renamed as "Archived_Mar". I have no idea why this file with the "~" keeps showing up which is causing an error message.

These are the only files I have in the folder:

I hope you can help!! Thanks

Input

Error Message

Help

Accepted answers

binu_acs

@Kristie_Pires Add a filter tool after the directory tool and set the condition !StartsWith([FileName],'~')

All comments

binu_acs

@Kristie_Pires Add a filter tool after the directory tool and set the condition !StartsWith([FileName],'~')

geraldo

@Kristie_Pires

You are not viewing these files due to the configuration of windows folders.
option must be checked:
show hidden files, folders and drives

These files with ~ is when the file is open, when you close the file it disappears.
but if there is any unexpected problem, this file may get lost ~ in the folder

Kristie_Pires

@binu_acs I was able to filter out that file! Thank you 😉

Thank you @geraldo - I checked the option to show hidden files, folders and drives and that file still doesn't show up. So, I am still unsure why I had the issue in the first place.

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335