If I understood right, you are trying to filter the Name that has Failed, but in your case the value is HBWO027265 / Failed and the formula substring(10.Name; 13; 6) will result 7265 /
The correct formula that you need is:
{{substring(10.Name; 13; 19)}}
because the second parameter (19) has to be the final index.
String functions | substring (make.com/en/help)
Another way to do this is searching for Failed:
There are more details about it at: Function contains using Regex - Nerd-Zone - Make Community (community.make.com)
