Announcements
Hello,
I have using below formula in my text box
If(CountRows(Filter('Goal Approval',Emp_Name = User().FullName)) > 0,"Y","N")
It not works because I have lagged amount of data.
So can anyone suggest me different way to do this?
Hey!
I have 1 app with the same CountRows() and it works. That is just a warning. Did you test it and make sure that it does not work?
If you need additional help please tag me in your reply and please like my reply.If my reply provided you with a solution, pleased mark it as a solution ✔️!Best regards,Gonçalo NogueiraCheck my LinkedIn!Check my User Group (pt-PT)!
Hi @Viral21
Its delegation warning. We can ignore if the filter data volume is less than 500 (default). We can increase to max 2000.
If you believe the data can grow then use this formula
With( { _Item: Filter( 'Goal Approval', Emp_Name = User().FullName ) }, If(CountRows(_Item)>0,"Y","N") )
My Sample
With( { _Item: Filter( IssueTracker, 'Assigned to'.DisplayName = User().FullName ) }, If(CountRows(_Item) > 0,"Y","N") )
IssueTracker - SP List
'Assigned to' - Person
HI @StalinPonnusamy Why it not me proper value?Is it something wrong done by me?
you can see my list have value with Emp_Name = Archer Admin, but still it given me result "N"
HI @Nogueira1306 I know that, but it not works for me
Can you place another label and set Text property to User().FullName to verify the name? This helps to troubleshoot.
You can see into this snap
Is it Sharepoint List or Document Library? Seams you have a folder.
share point list
Surprising. Other troubleshooting items
1. Can you select the filter to see UI filter works like
2. Hard code your name like
With( { _Item: Filter( 'Goal Approval', Emp_Name = "Archer Admin" ) }, If(CountRows(_Item)>0,"Y","N") )
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 397 Super User 2026 Season 2
Mohsin Ali 354
WarrenBelz 232 Most Valuable Professional
