cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Count if issue

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

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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,


 

View solution in original post

4 REPLIES 4
Helper V
Helper V

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

 

Countrows(Filter(SharePointLIST,ISBLANK(SharePointLIST.columnchecking)=true/false)

Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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,


 

View solution in original post

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (3,412)