Count if issue

[Anonymous]

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

[TheRobRush]

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]

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,

[Anonymous · Accepted solution]

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]

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,