get all true value in column of Yes\No row

[usarif]

Hi,

   I am having hard time to get True value out from YES\NO choice value. So i have SP lists of Choice and single txt column as shown below.

i am following this link 

https://powerusers.microsoft.com/t5/Building-Flows/Append-the-column-names-that-has-quot-Yes-quot-va...

appreciate any help on this....

[usarif]

here is the SP list

[DeepakS]

Hi @usarif 

When you are comparing YES/NO choice column  to true/false in condition. make sure you click on expression and use "true" value what flow provide.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up. 

[efialttes]

Hi
Is your column defined in Sharepoint List as Yes/No checkbox as in this link https://www.sharepointdiary.com/2016/10/sharepoint-online-add-yes-no-column-to-list-using-powershell... ?
Or a choice column than can take values 'YES' 'NO'?
Thanx!

[usarif]

Yes it is Yes\No Checkbox

Shows like 

[efialttes]

@usarif 

Thanks for the extra info!

@DeepakS understood it better than me, his response is the right one! You should add the expression 'true' from the Dynamic Content ->Expression. In older posts you will probably find other valid expressions we used in the old times, like bool(1)

You will see in my screenshots the result I got when using such evaluation in an 'Filter array' (this action block requests as input the very same evaluation formats as Condition action block). Once applied, the nr of items drops from almost 3000 to 156 (the ones condition matches)

Hope this helps, but please remember... credit to @DeepakS 

[usarif]

hi Super User, thanks for your help.

my output is different than expected as you mentioned. One think i am missing value in  your filter array as IsParent, not sure where it is coming from? but here what i got, not sure why i am getting only 1 VALUE.

[DeepakS]

Hi @usarif,

Could you please share a screenshot of your full FLOW in edit mode. This will help to understand your issue little better.

Regards

[usarif]

here you go

[usarif]

run mode

[usarif]

here is the Edit Mode

[DeepakS]

Hi @usarif,
In the filter array expression output of compose 2 is type length (number) and you are comparing it with true , that’s the reason you are always getting false.
You should use column that are yes/no in the condition.

Regards,

[usarif]

so i tried with different column in there and results are as seen below. So when select specific group name column, i would like get all true rows in the group name row. 

[usarif]

i tried with apply all still i am not getting true value.. as shown below..