Unanswered

Filter Out Blanks from SP List

(1) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

MMcCloud 351 Super User 2025 Season 2 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Verified answer

Phineas 5,325 Super User 2025 Season 2 on at

Like (1)

Report

MMcCloud, you almost got it.

The following did the trick.

Filter(Drop_Backup_Collection,Activity <> Blank())

Was this reply helpful? Yes No