Trigger for the arrived excel file

Help Studio
, ,
1

hello all,

I want to develop trigger wich start every time when the new file excel is arrived
knowing that at each arrival email,the new file overwrites the old one

(as idea i think we must get the time from properties of the file excel?

Thank u

2

Hi @nora_ziani,

You can follow the below steps.

  1. Create a robot to check the folder every 5/10 minutes.

  2. If there is any new file arrives, process it and move it to another backup folder

  3. Follow step 1 to monitor the folder

3

How I get the date of the arrived of the new file excel please
the trigger i know how to do it

4

I think you can get file creation time from the file properties. I don’t think you will get the file arrival time.
To ensure it is a new file, you can delete the file/clear the folder once you process it.

5

I have this problem ,thank u
image

6

Could you please attach the activity/actions that you are using in the main file…?

1 Like
7

here the activity , Best regards
image

8

image
here the rest part best regds

9

Try

Directory.GetLastWriteTime(filePath).ToString() and
Directory.GetLastWriteTime(filePath).ToString("dd.MM.yyyy-HH.mm.ss")

10

image
hello, now i get the date of the creation of the file

then for the trigger my I add a condition for this in order to see if the new file is arrived then the trigger must start
Thank u

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.