Hi,
I am getting the following error when running a workflow and I'm unable to resolve it or find a work-around.
The workflow has 2 inputs
1 - List of products which have previously been reported
2 - New list of products report
The workflow joins the product codes from the two reports and reports any which are on (2) which are not on (1).
The error appeared to occur only when there are no records going from the Left output anchor to the macro input anchor.
If I add in a select, for example, between the join and the macro, the error occurs between the select and the macro.
The macro uses a detour to send an email if the count is greater than zero.
I tried adding a dummy record which will always end up in the L output anchor, but excluding it from the count (so the count still goes through as zero). The error still occurs.
I tried changing the value in the action tool in the macro and including the dummy record. I changed the zero in the Formula box to 1. The error still occurred.
Then I ran it with no records input (count=0) when the formula was 'Tonumber([#1])=1', and this ran without issue, but I get the bug when I ran it again with the input count value as 1.
I changed it back to 0 and I get the bug when the input is 0 but not when it is greater than 0.
I have used this macro before without issue. Can anyone spot what I'm missing or make any suggestions on how to resolve this please?
Thanks
PuffinPanic
