web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / With function doesn't ...
Power Apps
Answered

With function doesn't work with Dataverse table to Count rows on filter with conditions

(0) ShareShare
ReportReport
Posted on by 15

Team, Earlier I was using Excel table and below mentioned solution was working fine I switched to Dataverse table with same field and not able to get count on 'Text Label', I can see the count If I hover the mouse on "With" function but the value is not assigning to  a Text label.

 

 

 

With(
	{
		wData:
		Filter(
			TableDataverse,
			IsMale = 0
		)
	},
	CountRows(
		Filter(
			wData,
			IsIndian = 1
		)
	)
)

/*
Dataverse Table Example
----------------------------------------------------------
S.No | Name | IsMale | IsIndian |
-----------------------------------------------------------
1 Test1 1 0
2 Test 5 0 1
3 Test 10 1 1
*/

 

 

I have the same question (0)
  • v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @sanjay_knp 

    Your code seems that it has no error and you can see the return number when your mouse hover on your code, can you show a screenshot in your side?

     

    Best Regards,

    Yueyun Zhang

  • Verified answer
    sanjay_knp Profile Picture
    15 on at

    Hi Yueyun , I wish if I could share the screenshot, I found an another solution to handle this issue & the below mentioned solution is working. Weird thing the below mentioned solution was not working on Excel sheet. Anyway thank you for looking into my query.

    CountRows(
     Filter(
    	 TableDataverse,
    	 IsMale = 0 && IsIndian = 1
    	)
    )

     

  • v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @sanjay_knp 

    Thanks for your sharing and glad to hear that you have find the workaround in your side. Can you mark your reply as solution so that it can help more people!

     

    Best Regards,

    Yueyun Zhang

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 414

#2
WarrenBelz Profile Picture

WarrenBelz 377 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 315 Super User 2026 Season 1

Last 30 days Overall leaderboard