Need alternate solution of CountRows

(0) Share

Report

Posted on by Viral21

194

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

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 Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
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") )

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @Viral21

My Sample
With( { _Item: Filter( IssueTracker, 'Assigned to'.DisplayName = User().FullName ) }, If(CountRows(_Item) > 0,"Y","N") )

IssueTracker - SP List
'Assigned to' - Person

Was this reply helpful? Yes No
Viral21 194 on at

Like (0)

Report

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"

Was this reply helpful? Yes No
Viral21 194 on at

Like (0)

Report

HI @Nogueira1306
I know that, but it not works for me

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @Viral21

Can you place another label and set Text property to User().FullName to verify the name? This helps to troubleshoot.

Was this reply helpful? Yes No
Viral21 194 on at

Like (0)

Report

You can see into this snap

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Is it Sharepoint List or Document Library? Seams you have a folder.

Was this reply helpful? Yes No
Viral21 194 on at

Like (0)

Report

share point list

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
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") )

Was this reply helpful? Yes No