Unanswered

Countif function is not returning a result

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to create some logic based on the result of a countIf function but for some reason the countif function is returning a 0 result even though it should be returning a count of 4 for the particular record I am looking at, but if I use the same operation and combine a CountRow and Filter formulas, it returns the correct result. Any ideas on why CountIF is not working even though it is the same exact condition? These formulas are entered into fields in a gallery.

CountRows(Filter('[dbo].[tblData_VendorMasterSSPaymentTerms]',ThisItem.VMSSPayTermsCLM_ContractID=VMSSPayTerms_AribaContractID))

CountIf('[dbo].[tblData_VendorMasterSSPaymentTerms]',ThisItem.VMSSPayTermsCLM_ContractID=VMSSPayTerms_AribaContractID)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

Can you try to modify your CountIf formula as:

CountIf('[dbo].[tblData_VendorMasterSSPaymentTerms]',VMSSPayTerms_AribaContractID=ThisItem.VMSSPayTermsCLM_ContractID)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Do you mean that these two formulas return different results?
Did you get delegation warning?

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yea I tried flipping the condition. no avail unfortunately.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yea the countif function returns 0 when it should be 4.

The combination of count rows and filter returns the correct result, but includes a delegation warning

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Well, that should be related to delegation problem.
That's PowerApps itself limit.
If your record is smaller than 2000, you could change the limit to 2000 to avoid this problem.

If your record is lager than 2000, you should use delegable functions. If you do not use, you may get wrong result like your issue.
Here are some docs about delegable functions:( different data source have different delegable functions)
https://docs.microsoft.com/en-us/connectors/commondataservice/
https://docs.microsoft.com/en-us/connectors/sharepointonline/
https://docs.microsoft.com/en-us/connectors/sql/

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I would agree but the count if formula is.not returning the correct result and is not the getting a delegation warning.

The formula that is returning the correct result has the delegation warning so that is not the issue.

Was this reply helpful? Yes No
LegoLad20 2 on at

Like (0)

Report
Copy link

Link copied!

Hey @Anonymous ,
Were you able to find a solution to this? I am having the exact same issue currently.

Thanks

Was this reply helpful? Yes No