I have an Excel file with multiple sheets, existence of those sheets are random. If a sheet is there, a series calculation will be perfomed based on the sheet data, if not, I wish there is a way to stop the workflow right away.
Is there a way to stop the workflow when workflow finds out a sheet does not exist like shown below?
Solved! Go to Solution.
Hi @yuanlu
Here is how you can do it.
1. Use the message tool like below. What the below message tool is doing is its checking recordnumber=1 exists (which means there is at least one row in false). If recordnumber=1 stop and error at that point.
2. Configure the workflow in the runtime tab to Cancel running the workflow on error.
Hope this helps : )
Happy to help : ) @yuanlu
Cheers and have a nice day!
@atcodedog05 - thanks for the clear explanation! Really helps!
Happy to help and share : ) @jacob_kahn
Cheers and have a nice day!