Answered

Count if issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I have an app linked to a Sharepoint list. I have a screen with a gallery which is filtered with this formula:

Distinct(Filter(WPO;Or('Realizado (SI/NO)'=Blank();'Realizado (SI/NO)'="Rechazado";'Realizado (SI/NO)'="Solicitado Deassingment") &&'Centro productivo'= SelectedLocation);Matricula)

[*WPO is the name of my sharepoint list; Realizado (SI/NO)/Matricula/Centro Productivo are the names of colums; SelectedLocation is a text value I have set in the screen before]

Then, within the gallery elements, I would like to put a kind of dashboard. In order to achieve that, I have put a label with a text using the following formula:

CountIf(WPO;'Realizado (SI/NO)'= Blank() && Matricula = ThisItem.Result && 'Centro productivo'= SelectedLocation)

But the CountIf formula does not work. Anyone can help me?

Attached are the screenshots of the app. Thank you!

Regards,

Javier

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I think youd have more luck with something like this (used generic names cause yah)

Countrows(Filter(SharePointLIST,ISBLANK(SharePointLIST.columnchecking)=true/false)
v-xida-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

Based on the formula you provided, I could not find any syntax error with it. Please check if you have typed a proper Filter condition within your CountIf function.

Please also consider modify your formula as below:

CountRows( Filter(WPO; IsBlank('Realizado (SI/NO)') && Matricula = ThisItem.Result && 'Centro productivo'= SelectedLocation) )

Please take a try with above solution, check if the issue is solved.

Best regards,
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

@v-xida-msft and @TheRobRush , thank you very much for your answers.
I partially solve the problem. It was a delegation problem that apperared due to the huge size of my list. I have reduce the number of items in it and now it works perfectly.
Thanks again!

Best regards,
Masoud9
@v-xida-msft wrote:
Hi @Anonymous ,
Based on the formula you provided, I could not find any syntax error with it. Please check if you have typed a proper Filter condition within your CountIf function.

Please also consider modify your formula as below:
CountRows( Filter(WPO; IsBlank('Realizado (SI/NO)') && Matricula = ThisItem.Result && 'Centro productivo'= SelectedLocation) )
Please take a try with above solution, check if the issue is solved.

Best regards,
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Have you solved your problem?

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,