How do i do timestamp for specific columns

[SIM_BERTRAM (BERTRAM SIM)]

Hi guys, im not sure and figuring out how do i do the timestamps (Email sent column) for only the approved columns? Because currently im only able to do it for the whole column instead of the only approved ones. To keep things clear i dont want the timestamp for rejected.

Pictures for reference

[liu_shubin (Shubin)]

You need to move the Excel Application Scope out of For Each Current Row as you don’t need to write result to file in the loop. Try it and then see whether it works.

[SIM_BERTRAM (BERTRAM SIM)]

Cannot need the excel file if dont have will have error

[SIM_BERTRAM (BERTRAM SIM)]

Also that one is not the problem is the range to write the value which i dont know how to only do it for the approved one

[Palaniyappan (Palaniyappan P)]

Hi

Hope the below steps would help you resolve this

1. Use a excel application scope and pass the excel file path as input

2. Inside the scope use a READ RANGE activity and mention the range as “A3” and enable Add headers property and het the output as dt

3. Now use a FOR EACH ROW activity and pass dt as input

4. Inside the loop use a IF condition like this

CurrentRow(“Status”).Tostring.Contains(“Approved”)

If true goes to THEN block where use a assign activity like this

CurrentRow(“Email sent”) = Datetime.Now.ToString

This is the important steps till where you almost reached

5. then outside the FOR EACH ROW activity use a Write range activity and pass dt as input and enable Add headers property and mention range as “A3”

6. This will write the output as expected

Cheers @SIM_BERTRAM

[liu_shubin (Shubin)]

Your “if condition” is used correctly.

You can use Write Range activity (under System workbook) to update datatable instead of updating cell. Excel Application Scope is not needed for Read/Write Range under System Workbook.

Write Range activity should be inserted outside of For Each Current Row.

[SIM_BERTRAM (BERTRAM SIM)]

Thanks this works!!