Unanswered

When a file is added or modified (Validate new rows only)

(0) Share

Report

Posted on by PranavPh

Hi all,

I have created a flow where it reads the file from file-system(Trigger: When a file is added or modified) and if it finds the keyword ERROR in the file it sends out an email.

It works ok but say there is an ERROR keyword in the first row, it sends the email but if the file is edited another 5 times, it will send out 5 emails because every time catches the ERROR keyword in the first row.

Is there any way I can check in the flow that there has been an email sent out for the ERROR message and no need to send it again? But only send a new email if a new ERROR keyword appears in the text file? Or Just start reading the file from the new rows inserted and not from the start?

Need your inputs @Expiscornovus @ManishSolanki @rzaneti

Regards,

Pranav

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is this just a .txt file? Not a spreadsheet?

If it were a spreadsheet you could just add a column that defaults to "No" and then updates to "Yes" if an email is sent, so you could filter out any "Yes"es.

If it's a text file, though, you could keep a list separately and just say the filename, the occurrences of the word "Error" and the amount of emails sent out. Ie, if there are 3 errors and 3 emails, great. If there are 3 errors and 2 emails, time to send out another email.

Was this reply helpful? Yes No
PranavPh 12 on at

Like (0)

Report
Copy link

Link copied!

Hi, No its not a spread sheet. Its a .txt file which holds the logs from the system.

Syntax is something like this

DateTime INFO Log-details
DateTime ERROR Log-details
Datetime WARNING Log-details
Datetime INFO Log-details

Flows reads the file > Sees ERROR > Sends email > Fine. All ok.

But file gets edited and another INFO row is added, flow reads the first ERROR and sends email > Don't want that since an email has been already sent. I want the FLOW to send an email only new New ERROR is logged in the file.

Regards,
Pranav

Was this reply helpful? Yes No