How to send consolidated report after processing all items from queue

Help Activities
, ,
1

Hi All,

Bot runs 50 items ever hour from queue and generates output file for 50 items

how to send consolidated output report after processing all the items and once it sends an output report it should not Trigger output report email for next schedule as the bot is scheduled for every hour.

2

@Mopur_Kishore1

Before sending the email …in the end process state use get queue items and check if there are any in progress or new items …if yes then do not send email…if no then send email

Cheers

3

Hi @Mopur_Kishore1

You can achieve this by using set asset & get asset asset activity.

  1. Use the “Set Asset” activity to update an asset (let’s call it “LastReportSentDate”) with the current date when the report is sent.
  2. Before generating and sending the report in subsequent runs, use the “Get Asset” activity to retrieve the “LastReportSentDate” asset value.
  3. Compare the retrieved date with the current date. If they match (indicating the report was sent today), skip sending the report. If they don’t match, proceed to generate and send the report, then update the asset with the current date.

Hope this helps :slight_smile: