If you just want to process records with Status active, then try something like
@contains(item().status,'Active')
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello! @Nasreen Akter @MartinJaffer-MSFT
I have a Filter activity after a Lookup Activity (which is successfully bringing back data from a SQL Server DB Table); I want to send the filtered data to the ForEach for if an Employee is NOT "Inactive"....as shown below. My Filter Condition is: @startswith(item().status,'Inactive')
I have in my first row of data the Status = 'Inactive'; however the employee data in the first row of the Inactive filter is still being passed to the ForEach Activity; therefore something is incorrect. Should I have all my Filters inside the ForEach instead of before it?
Any suggestions will be greatly appreciated! Thanks! Mike Kiser
If you just want to process records with Status active, then try something like
@contains(item().status,'Active')
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
There is a "not" function. You can use this to invert the results of the contains.
@not(contains(item().status,'Inactive'))