cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter Sharepoint list with blank date

Hello,

 

I have a power app which is supposed to select a Sharepoint list and display them in my gallery only if the value of a column (set in date/time format on Sharepoint) is blank.

I have tried the solution frome here : https://powerusers.microsoft.com/t5/General-Discussion/Filter-sharepoint-list/m-p/35713#M14753 but it doesn't work for me.

In the gallery/Items, I have this : If(IsBlank(Membres.'Date payement');SortByColumns(Membres;"Nom";Ascending)).
It supposed to return one element but no result is shown on my app.

Capture.JPG

There you can see all items in my list has a value except for the last one.

 

Can someone help me figure out what is wrong ?

 

Thanks !

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Filter Sharepoint list with blank date

@Anonymous 

Try changing your formula to the following:

SortByColumns(Filter(Membres; IsBlank('Date payement');"Nom";Ascending)

You need to specify the column you are checking to be blank in the IsBlank, including the datasource name and the column name is not valid and will not return results.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

8 REPLIES 8
Highlighted
Super User
Super User

Re: Filter Sharepoint list with blank date

As your statement currently reads, you are checked to see if there is a blank date, but then you are simply sorting all your data and showing because you do not have a filter to limit your sort to only the records which are blank.  I didn't test this, but it should be something close to:

 

SortByColumns(Filter(Membres, IsBlank(Members.'Date payement'),"Nom";Ascending)

(Not sure if I substituted ; for , in all the right spots since I'm not used to that.)

 

This assumes you only want to show rows with the blank date which is what I understood you to want.

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Highlighted
Anonymous
Not applicable

Re: Filter Sharepoint list with blank date

 I tried this solution before the one shown above but it doesn't work :
 
SortByColumns(Filter(Membres;IsBlank(Membres.'Date payement'));"Nom";Ascending)

(I'm using ; instead of , because I'm in Europe and it doesn't accept , but 😉
Highlighted
Super User
Super User

Re: Filter Sharepoint list with blank date

@Anonymous What error or result does it give you when you try that formula? 

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Highlighted
Anonymous
Not applicable

Re: Filter Sharepoint list with blank date

@LRVinNC it's not showing any result sadly
Highlighted
Super User
Super User

Re: Filter Sharepoint list with blank date

Interesting because I just ran a test and it pulled my record with a blank date only.  Just for grins, try "IsEmpty" instead of "IsBlank" and see if that changes anything.  When I use IsEmpty, I get nothing.  IsBlank gives me the record.  

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Highlighted
Super User III
Super User III

Re: Filter Sharepoint list with blank date

@Anonymous 

Try changing your formula to the following:

SortByColumns(Filter(Membres; IsBlank('Date payement');"Nom";Ascending)

You need to specify the column you are checking to be blank in the IsBlank, including the datasource name and the column name is not valid and will not return results.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Filter Sharepoint list with blank date

@RandyHayes Great, it's working.

Thanks for the explanation

Highlighted
Frequent Visitor

Re: Filter Sharepoint list with blank date

Hi,

I've tried many different things and the filter doesn't work

This is what I have so far on the gallery/item

If(ComboBox2.SearchText<>"",Visitors)

I need to be able to filter to display records from the SP list where the checkout date is blank for the visitor.

 

The SP list is Visitors, the column name is CheckOut:date and time

 

Thank you for your help

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,637)