Count Blanks, Non Blanks in PowerApps Form

(0) Share

Report

Posted on by Prem4253

697

Hello,

I've a SharePoint list connected to PowerApps form. On Daily basis New records are added to the form, which than gets stored to SharePoint List.

I'm looking for a logic to count Blanks, Non Blanks from a particular column to add within PowerApps form.

See below is this helps to understand my requirement:

Hopefully someone can assist me in this regards.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Prem4253

In the order you posted them
With( ( _Data: Filter( SPList, IsBlank('Receipt Date') ) }, CountRows(_Data) ) With( ( _Data: Filter( SPList, !IsBlank('Receipt Date') && IsBlank('Invoice No') ) }, CountRows(_Data) ) With( ( _Data: Filter( SPList, !IsBlank('Receipt Date') && IsBlank('Invoice Date') ) }, CountRows(_Data) ) With( ( _Data: Filter( SPList, !IsBlank('Receipt Date') && !IsBlank('Invoice No') && !IsBlank('Invoice Date') && IsBlank('Licence No') ) }, CountRows(_Data) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
timl 37,262 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi y Prem4253

Another way to do this would be to call the CountIf function. The syntax would look like this:

Count rows where ReceiptDate is blank:

CountIf(YourSharePointList, IsBlank(ReceiptDate))

Count rows where ReceiptDate is not blank and InvoiceNo is blank:

CountIf(YourSharePointList, !IsBlank(ReceiptDate) && IsBlank(InvoiceNo))

Count rows where ReceiptDate is not blank and InvoiceDate is blank:

CountIf(YourSharePointList, !IsBlank(ReceiptDate) && IsBlank(InvoiceDate))

Count rows where ReceiptDate is not blank, InvoiceNo is not blank, InvoiceDate is not blank, and LicenceNo is blank:

CountIf(YourSharePointList, !IsBlank(ReceiptDate) && !IsBlank(InvoiceNo) && !IsBlank(InvoiceDate) && IsBlank(LicenceNo))

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Both timl's and my approaches will work, however both a subject to a maximum count of your Data Row Limit (I meant to note this on my original post as you will not get a Delegation warning and the limit is after the filter, whereas you will with timl's version with the limit before the filter).

Was this reply helpful? Yes No