In DoForEach Smart Service Expression Component filterNulls does not

You can use an alternate function to remove nulls from a list - can you try difference({"test1","test2",null,"test5",null},""). Result of this function would be test1, test2, test5

use reject function------- reject(fn!isnull,ri!array)

#knowledgeshare Appian 7.0 introduced the looping functions -- see forum.appian.com/.../Looping_Functions. The DoForEach usage has been deprecated and should be replaced with the looping functions moving forward.

We are on Appian 6.6.1

Yes, difference works for me.. I don't see reject function... Must be in Appian 7.0

Then you can do =fn!remove(pv!array,fn!where(doforeach("isnull",pv!array)))

#knowledgeshare Note: Expression rules, when used in the doforeach, are *not* resolved by the Application Builder's dependency checker, and hence you need to manually keep track of the expression rules used inside doforeach. In the expression I mentioned above, you will be using isnull, so not a problem here, but something to keep in mind in-case you plan on using expression rules inside the doforeach. Hope this helps!

There is no WHERE clause in Appian 6.6.1. Is this something we can use? I tried but its not working? Is the isnull function in doforeach in double inverted commas?