How to stamp multiple case refrence in same report one by one?

Help Something Else
1

I have scenario where a single case reference contains multiple progress statuses(Completed, Inprogress, Delayed, Cancelled) including some other information , and I need to review each status and stamp them individually for the same case reference. How can I accomplish this task within a report?

2

Hello Vaishnavi,

  1. Maintain this data in a excel file then reading data using UiPath and You can add conditions using UiPath according to status. If its “Completed” you can perform desired task.
  2. Review Each Case Reference: Go through each row one by one and review the progress statuses for that case reference.
  3. Stamp Each Status: For each case reference, mark or stamp the appropriate status. You might use symbols, colors, or simply type the status next to each case reference.
  4. Save your progress.

Hope you find this useful.

1 Like
3

Hi @Vaishnavi_Sable
Welcome to the community!

Can you please let me know whether you are working in a linear process or a transactional process( Sequence or a Re-Frame work)

Thanks
Biswajeet

4

I have made my project in re framework

5

Thanks for the confirmation

Here is how you can certainly achieve that:

Create a global dt variable with headers in Initialization scope for further use.

  1. In the process transaction scope you can use a switch statement for all the progress status.
  2. Based on the condition you can switch into that specific condition and stamp the status column as per the condition of your switch.

Example: if the condition matches with completed status you will stamp completed, if matched with in progress it will stamp it as in progress, and in the get transaction state transition where Transaction item is notNothing and where transaction item is Nothing use a write range to write it in the report excel with the updated Dt variable.

Thanks
Bishwajeet

1 Like
Forum Engagement Daily Reports
6

Thanks @Biswajeet_kumar, Happy Automation!

1 Like
7

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