How to add a numbering to an email subject line

[Gandalf_NotGrey]

We have a report that a team runs multiple times a day (Gallery App). The output is in the form of a table sent over email.

Currently, the subject line of the mail is "Team Report ABC"

The user has requested the subject line to be: "Team Report ABC #1 DD/MM/YYYY HH:MM:SS". So, every time the report runs each day, #1 should become #2 and then #3 and similarly.

We have added the Datetime stamp on the subject line but are not able to add the numbering on the email subject line.

Does anyone have any suggestions on how to achieve this?

These numbers will go from 1 to xx on each day and will reset to 1 on the next day.

Thanks. 

[binuacs]

@Gandalf_NotGrey One suggestion is to read the number from an external file (saved in an excel file) and end of the workflow increment the number and replace the existing value in the excel file. 

[Gandalf_NotGrey]

Thanks @binuacs for the suggestion. Could you please explain how to do this? I am able to add the number through an excel file but can't understand how to increment it at the end of the workflow and how to reset it again to the beginning, each day.

[binuacs]

@Gandalf_NotGrey Attaching a sample workflow, which reads the ID from the excel file (which was initially assigned as 0, then each run the ID will get incremented by 1 and update the existing excel file

[Gandalf_NotGrey]

Thanks @binuacs 

This is very helpful

One doubt, how does the ID gets reset again to 0, at the end of every day?

[binuacs · Accepted solution]

@Gandalf_NotGrey I added Date field also in the ID sheet to reset the ID value for the next day's run. Can you test from your side and see it is working?

[Gandalf_NotGrey]

Hey @binuacs 

Thank You so much for this. We tried this yesterday and it worked like a charm.

Thanks again. Appreciate your effort.

[binuacs]

@Gandalf_NotGrey Glad to know it worked for you!!!