Hide gallery items with dates in the past?

[MSSAdmin]

Hi everyone,

I have a simple SharePoint list in PowerApps with the automatically generated BrowseScreen, EditScreen, DetailsScreen.

The view in my Browse Screen is an address and a date.

Is there any way I can hide or grey out items from this BrowseScreen that have a date in the past?

I do not want to delete the items completely but to avoid confusion with the person using it, they shouldn't appear once the date has passed.

Any help is appreciated, thank you.

[RandyHayes]

@MSSAdmin 

Set the Items property of your Gallery to the following formula:

   Filter(yourDataSource, Date>=Today())

This will only show items with dates from today on.  Change the yourDataSource to the name of you SharePoint list and this should give you what you want.

I hope this is helpful for you.

[MSSAdmin]

Hi, 

thanks for the quick response. However, I either don't know where to add the formula or it doesn't work.

This is the code currently in the Items property:

SortByColumns(Filter([@'Gear list'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

[RandyHayes · Accepted solution]

@MSSAdmin 

Change that then to the following:

SortByColumns(
    Filter([@'Gear list'], 
        StartsWith(Title, TextSearchBox1.Text) &&
        Date>=Today()
    ), 
    "Title", 
    If(SortDescending1, Descending, Ascending)
)

[MSSAdmin]

This is the error message I get.

[RandyHayes]

@MSSAdmin 

You need to replace the Date in that formula with whatever the name of your date column is that you want to filter against.  You did not mention the name of the column in your original post.

[MSSAdmin]

Got it, that works! Thank you 😃

However, is there a way to show the entries that don't have a date at all? Some of them don't so the date is added later and the entries have to be visible.

[MSSAdmin]

Any updates on my previous post?

[WarrenBelz · Accepted solution]

@MSSAdmin ,

Just helping @RandyHayes here - he has answered your post adequately, but in relation to your second question

SortByColumns(
   Filter([@'Gear list'], 
      StartsWith(Title, TextSearchBox1.Text) &&     
      (
         Date>=Today()||
         Value(Date)=0
      )
   ), 
   "Title", 
   If(SortDescending1, Descending, Ascending)
)

[RandyHayes]

Thanks for jumping in @WarrenBelz  I've been way behind on catching up with replies to posts 😕

@MSSAdmin give Warren's formula a shot, just again...don't forget to replace Date with whatever the name of your actual data column is.