'File Change Trigger' activity not working with '.xlsx' file

Help
,
13

We just completed the investigation and this is caused by Office products renaming files during save operations. When an office file is opened, a new ~File.xlsx file is created and that’s the file that Office is editing. Then when a save occurs, the original file is renamed to SOMETHING.tmp and ~File.xlsx is renamed to File.xlsx.

The File Changed Trigger is generic as it works on file changes in the system and we don’t have plans to add customized support for Office. To work around this, there are two options:

  1. Instead of triggering on NotifyFilter=‘Filename’, trigger off of ‘Attributes’
  2. Trigger off of file renames

The second options is a better practice and I’ve included a sample workflow showing how it works

FileTriggerTest-Excel.zip (13.5 KB)

4 Likes