Hey Im looking for a way to purge all tickets older then 30 day. using a google sheet as the database
Thank You in advance for your help
Go to Solution.
I just tested with below steps and it works for me.
1. In Google Sheet, add a date type column called "Date" to Sheet2, users need to manually fill this column with the created date.
2. Let PowerApps create an app using this table.
3. Add a button, set its OnSelect property to:
4. After I click on the button, all records that has 30 days before today in Date column will be deleted.
View solution in original post
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.