Answered

Filter Sharepoint list with blank date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

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 !

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

LRVinNC 2,297 on at

Like
a
(1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

 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 😉

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@LRVinNC it's not showing any result sadly

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(4)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

@RandyHayes Great, it's working.

Thanks for the explanation

Was this reply helpful? Yes No
omelo 52 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No