cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlanCampbell
Level: Powered On

Filter Gallery by created time

Hi all,  I'm trying to filter a gallery who's datasource is a sharepoint list by the created time.  I only want to show records that have been entered in the last 30 minutes.  

 

Any help would be greatly apprecaited

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Filter Gallery by created time

Hi @AlanCampbell

 

In order to Filter only records that were created in last 30 minutes put the following formula in the Gallery.Item:

Filter(
    PowerAppsTestList1,
    Created > DateAdd(Now(),-30,Minutes)
)

Created is the DateTime value field that every SharePoint List has.

Now() is a function which returns current time in DateTime format

DateAdd is a function where you can add or subtract any amount from DateTime

 

I tested it and it works. However this function can not be delegated to SharePoint List datasource.

 

3.png

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Re: Filter Gallery by created time

Hi @AlanCampbell

 

In order to Filter only records that were created in last 30 minutes put the following formula in the Gallery.Item:

Filter(
    PowerAppsTestList1,
    Created > DateAdd(Now(),-30,Minutes)
)

Created is the DateTime value field that every SharePoint List has.

Now() is a function which returns current time in DateTime format

DateAdd is a function where you can add or subtract any amount from DateTime

 

I tested it and it works. However this function can not be delegated to SharePoint List datasource.

 

3.png

View solution in original post

AlanCampbell
Level: Powered On

Re: Filter Gallery by created time

Thankyou that's works great

AlanCampbell
Level: Powered On

Re: Filter Gallery by created time

thankyou that works great

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 203 members 5,342 guests
Please welcome our newest community members: