cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SergiuCantacuzu
Frequent Visitor

Data table, show only lines with a certain column not blank

Hi,

I'm killing my brain after 20 years from my last programming ( high school ) to develop a Power App for my work. 

In a certain screen, I need to show info from a library using a data table, but only those lines that don't have info in a certain column.

Ex :     order date      spare part   date of delivery

           20/04/2020     mouse         

           21/04/2020     phone          22/04/2020

so in that screen mentioned above a need to see in the data table only the first line where the ordered part isn't delivered.

the question it will sound silly but where do I write the formula  Filter(datatable, isblank('date of delivery')) 

 

thank you in advance

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

What you have filtered is [Numar Factura Column6] not [Numar Factura].

Can you show the image with [Numar Factura Column6]

Are they not different columns?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

7 REPLIES 7
eka24
Super User III
Super User III

Try:
Filter(TableName, IsBlank('date of delivery'))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

the question is, where do i write the formula ? 

on the Visible - fx of the screen, or of the data table in the screen ? or some were else ?

On the Items of the DataTable.

After that Go To Fields and choose the Table columns. (Pictures below)

 

TableName.JPG

 

Fields.JPG

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

i don't understand what i do wrong !

 

without the filter, yo can see the column from the right [Numar Factura] were there is only one line with info. with the filter i want that line not to be showed. 

 

without filter.JPG

 

so with filter all disappear . i have tried instead of 'comenzi piese' to use DataTable9, no success. what do i do wrong ? 

 

filter.JPG

 

What you have filtered is [Numar Factura Column6] not [Numar Factura].

Can you show the image with [Numar Factura Column6]

Are they not different columns?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

🙏  that was the mistake. now it's ok ! big thanks !ok.JPG

Glad I helped
Thanks you

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (41,425)