web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Data Table to O...

Power Apps

Answered

Filter Data Table to Only Show those with blank entries in any column

(0) Share

Report

Report

Posted on by jamescosten

643

I have a data table that has 7 columns.

Column 1 - Job

Column 2 - Part

Column 3 - Tool

Column 4 - Date

Column 5 - Machine

Column 6 - Impressions

Column 7 - Cycle

I would like to only show rows that have a blank entry in any of the columns 4, 5, 6 & 7. It could have a single blank or multiple blanks but i want to only show those items. Any row that has all data to be excluded.

Any ideas how to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

AARON_C 2,235 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jamescosten,

You can filter the data table using a formula like this:
Filter('Data source', IsBlank(Date) || IsBlank(Machine) IsBlank(Impressions) || IsBlank(Cycle) )

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No

Join the conversation