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

sfddfdff

fdsdsgfhd

16 REPLIES 16
Venxir
Resolver I
Resolver I

Hi werner88,

 

Just use:

Filter(YourTable, ExpirationDate > Now())

This will not autmatically refresh when just looking at the gallery so keep that in mind.

werner88
Frequent Visitor

 

whtrjztkhtk 

 

Hi,

 

You don't give me much to work with mate. Please post screenshots or code to clarify the problem and why it's not working.

werner88
Frequent Visitor

 

fgsffdsbgfb 

 

SortByColumns(Filter ('title', StartsWith(Title, TextSearchBox1.Text ) && Created > Now()), "Created", If(SortDescending1,Ascending , Descending))

Depending on your locale and what's actually in your Created column, you need to edit this code.

werner88
Frequent Visitor

sgtrjzkjdf

Meneghino
Community Champion
Community Champion

Pease be aware that filtering by dates only works with the = operator and not < or > with some data sources, for example SharePoint, SQL Server or Azure SQL Database.

Reference here.

sfdtjd

Do you use SQL Server?

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

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (58,268)