Answered

Filter Out Blanks from SP List

(1) Share

Report

Posted on by Phineas

4,702 Super User 2025 Season 1

I have SP List1.

I have Power App Gallery1 and Label1

SP List1 has Activity columns and Consumable columns.

Though the Activities and Consumables and related, the user
wants the lines posted separately to the SP List1.

This leaves blanks in each of the Activity and Consumable line
items.

I am displaying the Activities in Gallery1.

I am using Label1 to display total Activities.

Gallery1 is showing the blanks from SP List1, and Label1 is
including the blanks in the tally.

Is there a way to write a formula in the Gallery items (and Label1)
that eliminates the blanks from SP List1 in Gallery1 and Label1?

In the example there are six (6) Activities and thirteen (13)
Consumables.

The tally shows nineteen (19) Activities and should only show
six (6).

The first Activity from SP List1.

The seventh Activity from SP List1.

Categories:

Using Apps Using Formulas

All responses (3)

Answers (1)

Verified answer

Phineas 4,702 Super User 2025 Season 1 on at

Like (1)

Report

Filter Out Blanks from SP List

MMcCloud, you almost got it.

The following did the trick.

Filter(Drop_Backup_Collection,Activity <> Blank())
ronaldwalcott 3,497 on at

Like (0)

Report

Filter Out Blanks from SP List

What do you mean by this

Though the Activities and Consumables and related, the user
wants the lines posted separately to the SP List1.

You could use something like

Filter('SP List1', Not(IsBlank(Activities))) - to filter the list

CountRows(Gallery1.AllItems) and this to count the count the gallery (not sure this is what you want)
Suggested answer

MMcCloud 96 on at

Like (0)

Report

Filter Out Blanks from SP List

Good Evening,

In this situation I would personally would use the Filter formula.

For example,

Filter(CustomGallerySample,SampleHeading<>"")

Replace CustomGallerySample with your data source and SampleHeading with your column you are looking for an entry in.

This would filter your data source for where it does not equal nothing.

If this answers your question considering choosing my response as the answer and have a nice day!