I want to write into excel when the status changes into Completed
what should be the condition for this and want to write in-process
only once no matter how many times it loops.
If it breaks in middle the status should be In Process
I want to write into excel when the status changes into Completed
what should be the condition for this and want to write in-process
only once no matter how many times it loops.
If it breaks in middle the status should be In Process
Hi @Bhushan_Nagaonkar ,
For understanding this, we would also require to have a view of the Steps done in your workflow. How is the Process implemented ?
We could use a counter variable for this case, as you are using the While
loop activity. Create an integer variable called counter
. Intialize it to 0 using an Assign
Activity before the While
loop Activity.
After the call to the API, Check if the counter =0 using an If
Condition activity. Get the Status and update the Status in Excel/Datatable.
Increment the counter
to counter+1
using an Assign
Activity.
This should help to avoid multiple updation of In Process
Status.
Let us know if you are able to implement this.
Can you please show me in ss and I’m using do-while activity. Thanks
@Bhushan_Nagaonkar ,
The Outline should be in the below manner (Just the sequence and not the actual flow method)
Let us know if you are facing any issues and what exactly it is.
Ok, I will let you know
It worked Thankyou so much
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.