Answered

Filter 'has at least one true'

(0) Share

Report

Posted on by CU26100700-0

I have a collecion with 3 columns like this:

QID	correct	userSelection
1	false	false
1	false	false
1	false	false
1	true	false
2	false	false
2	true	false
2	false	false
2	false	false

How can I check if there is a true value for each different QID in userSelection?

Categories:

General Questions

Connecting to Data

All responses (6)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Filter 'has at least one true'

Hi @SL93,

Do you want to check if the userSelection matches to the answer?

Could you please share a bit more about your need?

From your description, I think you want to count if there is at least one true in a grouped QID.

I have a test on my side, please take a try as below.

Add a Gallery and set the Items property as below:

GroupBy(collection,"QID","Answer")

Set the Labels within it Text property as below:

CountRows(Filter(ThisItem.Answer,correct="true"))
Ram Prakash 5,154 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter 'has at least one true'

Hello @SL93 ,

Do you want to have group by with filter ?
CU26100700-0 15 on at

Like (0)

Report
Re: Filter 'has at least one true'

What I am looking for is more like this:
Filter(GroupBy(collection, "QID", "answers").answers, userSelection)
But that is returning: "This identifier isn't recognized" on userSelection.
Ram Prakash 5,154 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter 'has at least one true'

Hello @SL93

Filter(TableName/CollectionName, userSelection = true && !Blank(Qid))
That's it 🙂

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
CU26100700-0 15 on at

Like (0)

Report

Re: Filter 'has at least one true'

Hi @rampprakash,

thanks for the reply, but that won't fix my issue.
I need all entries of the collection that have a QID where at least one has true at userSelection.
Ram Prakash 5,154 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter 'has at least one true'

Hello @SL93,

You can simply use

Filter(TableName/CollectionName, userSelection = true)

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com