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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Ram Prakash Duraisamy 5,885 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CU26100700-0 15 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,885 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CU26100700-0 15 on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,885 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @SL93 ,

Do you want to have group by with filter ?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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"))

Was this reply helpful? Yes No