How i can count the number of true

[CPKH]

I have Select which take a specific column and i get an Output of:

 {
    "True": true
  },
  {
    "True": false
  },

Now next step contains Compose which count the number of

"True": true

I try to use the function:

length(body('Select')?['True'])

but i get an error.

"InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2625': 'The template language expression 'length(body('Select')?['True'])' cannot be evaluated because property 'True' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'."

Thanks for your help! 🙂

[abm]

Hi @CPKH ,

Not sure that is possible with composite step. Once you used the ParseJSON then it will unfold with an For-Each block to iterate the values.

Please have a look at this blog.

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[v-bacao-msft · Accepted solution]

Hi @CPKH ,

If you want to calculate the number of items whose True field value is true, you could refer to the following method.

Use Filter array to filter out the object with a value of True in Select, and then use the length() function to calculate the number.

Hope this helps.

Best Regards,