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
Go to Solution.
In order to Filter only records that were created in last 30 minutes put the following formula in the Gallery.Item:
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.
View solution in original post
Thankyou that's works great
thankyou that works great
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.