filter activity criteria

Question

Hi,
In the pipeline I am filtering the lookup activity of a .csv file

Inside the condition of filter I have:
@equals(activity('LookupOC').output.value[0]['ID'], add(int(variables('vOID')), 1))

In th eabove expression I am trying to get the row for the ID+1

There is no error but I do not seem to get the filtered row for row with ID=2
Output
{
"ItemsCount": 6,
"FilteredItemsCount": 0,
"Value": []
}

Answer 1

Hi @arkiboys ,
Thankyou for using Microsoft Q&A platform and posting your question.

Here, you are trying to compare string with int value . That's the reason there is no output.

Use int to convert string to integer value in the first parameter passed in condition as well.

Here , I used @activity('Lookup1').output.value as item and @equals(int(item().Id),2) as condition in filter activity.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators