cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

display only records if a comun is empty

Hello

 

I am trying to build a powerapp that shows in a gallery all the records created by the user itself and of which a certain column does not yet contain any valuedata. So that the user only see the records that requer attention.

 

Filter(cars; 'Create By'.DisplayName = User().FullName) //shown only record for the current user

 

i all so want to shown only the records where columX is empty.

 

I don't no how to add this to the current filter

 

hopefully someone can help

 

thx

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: display only records if a comun is empty

I got the solution

 

Filter(LeenAutocars; 'Create BY'.DisplayName = User().FullName; 'Column X' <= 0)

 

thx

View solution in original post

3 REPLIES 3
Highlighted
Helper I
Helper I

Re: display only records if a comun is empty

I got the solution

 

Filter(LeenAutocars; 'Create BY'.DisplayName = User().FullName; 'Column X' <= 0)

 

thx

View solution in original post

Highlighted
Dual Super User
Dual Super User

Re: display only records if a comun is empty

Hi @icturion 

 

Filter(cars; 'Created By'.DisplayName = User().FullName && Column=Blank())

 

replace Column with your column reference

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Highlighted
Helper I
Helper I

Re: display only records if a comun is empty

Hi RezaDorrani

 

that also works thanks

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,223)