I have question about try catch
I use for each row for read dat for process in web.
If have error in web I want to next row (For each row)
Please guide me for solve it.
Thank you
put all the activities that you have inside the for each in try-catch block.
In try =add all the activities you have inside for-each
catch =handle the exception by selection system exception.
@Gayathri_Mk If found error I want stamp this row in excel and go tot next row
Please guide me for solve it in catch.
Do one thing use build data table and build the data table with columns you have in excel.
In catch use add data row activity to add this values in the data table .
After for each and use write range to add that to excel.
Can i see your workflow? What activities you are using to get the data from web.
@AJ_Ask Can I send my flow to your inbox?
Yes you can send it in inbox
Hey @Stef_99
This is a demo scenario as yours!
As Mentioned in below screenshot take a Try Catch Activtity in Foreach Row in Datatable & put all the activities in it and in catch part take Add data row activity for adding that Error row in Exception table.
Screenshot for your reference:
Attaching .xaml for your reference:
TryCatch_Sequence.xaml (13.9 KB)
Regards,
Ajay Mishra
1 Like
@Ajay_Mishra If I use write cell column result in catch In row that error
Because in try I stamp output by row.
Can i do it?
@Stef_99 Yes, You can do it!
Just remove that Write range, put Write Range at the end outside Foreach Row!
Regards,
Ajay Mishra
If you use write range workbook activity inside the for each the data will overwrite.
So, use Add DataRow Activity inside for each of catch block and use write range activity after for each.
Hope it helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.