Count Blanks, Non Blanks in PowerApps Form

(0) Share

Report

Posted on by Prem4253

369

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:

Using Apps Using Formulas

SM Req.JPG

All responses (3)

Answers (1)

Verified answer

WarrenBelz 147,870 Most Valuable Professional on at

Like (1)

Report

Count Blanks, Non Blanks in PowerApps Form

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).
timl 35,179 Super User 2025 Season 1 on at

Like (0)

Report
Count Blanks, Non Blanks in PowerApps Form

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))
Suggested answer

WarrenBelz 147,870 Most Valuable Professional on at

Like (0)

Report
Count Blanks, Non Blanks in PowerApps Form

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