Hello everyone,
I have the following problem: I want to send an email if a specific issue occurs. To find the email address, I have integrated an Excel table into the Action Flow, which contains the corresponding email address for a specific Purchasing Group.
I want to compare the Purchasing Group of the input with the Excel file. If a row in the Excel file matches the input, the email address from that row should be extracted and an email should be sent to that person (upper path). If no Purchasing Group matches the input, the fallback route should be triggered.
Currently, I am producing two bundles: one that extracts the correct email and leads to the upper path, and another with non-matching Purchasing Groups, which leads to the fallback route.
I either want to produce only one bundle that contains the correct email and no second bundle, or another possibility would be to check the number of created bundles in the filters. If more than one bundle is created, I could determine that a correct and an empty bundle are created, and the upper path would be triggered. If only an empty bundle is created, the fallback route would be triggered.
Can I query the number of created bundles in the filters? Or do you know other possibilities to solve this problem?
