How to Sort values from List of Dictionaries

Hi arshbirs0001,

The below code should do what you want. local!dictionary is the variable containing your dictionary

index(
    local!dictionary,
    wherecontains(
      "E",
      touniformstring(property(local!dictionary,"category",""))
    )
  )

Please also tell What if I want to filter with multiple conditions? like I want category A and E both 

arshbirs0001, for the next iterations with Community I suggest you open different threads for the different question since it will help colleagues to better use your topic in the future. 

Nothing prevents you to use a!forEach (quite powerful) to do what you need. I advise you to check the filter() function as well. You can define a helper function that you can use to filter a list 

a!forEach(
    items:local!dictionary,
    expression: if(
      or(property(fv!item,"category")="A",
      property(fv!item,"category")="E"),
      fv!item,{}
    )
  )

arshbirs0001, for the next iterations with Community I suggest you open different threads for the different question since it will help colleagues to better use your topic in the future. 

Nothing prevents you to use a!forEach (quite powerful) to do what you need. I advise you to check the filter() function as well. You can define a helper function that you can use to filter a list 

a!forEach(
    items:local!dictionary,
    expression: if(
      or(property(fv!item,"category")="A",
      property(fv!item,"category")="E"),
      fv!item,{}
    )
  )

arshbirs0001, did this work for you? If so, I would appreciate if you could close it by marking the above as an answer.

thanks