web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to search a galler...

Power Apps

Unanswered

How to search a gallery for the last 30 days.

(0) Share

Report

Report

Posted on by CU06111240-0

83

This is the current formula I am using : Search('Conditioning Tool',TextSearchBox1.Text,"Title") . What formula can be used to descend my log and display only the last 30 days from my SharePoint list?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

timl 37,320 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @tchamb2

The following formula will do this:

SortByColumns( Search( Filter('Conditioning Tool', Created > DateAdd(Today(),-30,Days) ), TextSearchBox1.Text, "Title" ), "Created", SortOrder.Descending )
ivan_apps 2,189 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Sort( Table, Formula [, SortOrder ] )
SortByColumns( Table, ColumnName1 [, SortOrder1, ColumnName2, SortOrder2, ... ] )

either one works for sorting. Just substitute the ‘Table’ by your filter criteria. I this case created in the last 30 days. Note that SharePoint delegation plays a part in Search() so Filter() is usually preferred, combined with StartsWith().

Sort(
Filter(Table,
StartsWith(Title, Textbox1.Text),
Created > DateAdd(Today(), -30, Days)),
”Created”,
SortOrder.Descending
)

Join the conversation