Hi everyone,
I have column in Dataverse which is a Yes/No Column regarding 'Photo required'.
Now I would like to reference that in PowerApps with:
Filter('Vehicle Photo Templates', 'Vehicle Photo Templates'.'Photo required'.Yes) -> Not working
CountRows('Vehicle Photo Templates'.'Photo required') -> This only gives me total amount of rows
I would like it to give me back the total number of rows with choice 'Yes' and choice 'No'.
It worked, thanks!
Hello, @Gnashy , You need to use your Choice Name:
CountRows(Filter('Vehicle Photo Templates', 'Photo required'='Photo required'.Yes))
CountRows(Filter('Vehicle Photo Templates', 'Photo required'='Photo required'.No))
I am assuming that your Choice Object Name is Photo Required.
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
MS.Ragavendar
32
Michael E. Gernaey
24
Super User 2025 Season 1
WarrenBelz
18
Most Valuable Professional