Email Autmation

How to detect that data is saved in a file(example: scraped data) before sending an email?
Please suggest options. Thanks in Advance!!

What file type are you working with?

@Riya_Lanjewar
the most minimal approach could be:
check if datatable has no 0 rows count

2 Likes

It is EXCEL. Which saves the data of Data scrapping.

If it is an excel file, read the range with the path to the excel file you want and check if the data table that is output from that read range activity has data by either looping through it or counting the rows.

If it is a simple text file, just extract the contents of it and check if the string is empty or Nothing.

If you are scraping data and placing it in an excel file, then I would just create a separate work flow for that and return a boolean indicating the data was saved properly.

1 Like

Thanks for quick response and resolving my query.

Thanks for the reply. I will surely try this solution Thanks for resolving my query.:innocent:

1 Like

@Riya_Lanjewar

You can check whether the data is scrapped as below

As Read Range will output DataTable

So Place a if condition and try as below

YourDatatable.Rows.Count > 0

Hope this helps

Thanks

1 Like

Thank you so much for reply. I will surely try this.

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