Remove items form list not working

[dries]

Hi

I have a list with a date field (datum). I added a button to delete all records with a date older dan 60 days. I added this code to the button, but it is not working. Any suggestions?

RemoveIf(Maaltijden,(Datum<(Today()-60)))

thanks.

[Meneghino · Accepted solution]

What is the data source?

If SQL Server or Azure SQL DB or SharePoint then > or < or >= or <= comparisions do not work are not delegated.

Reference here:

https://baizini-it.com/blog/index.php/2017/09/28/powerapps-and-azure-sql-database-current-issues/

[Rebetcha]

< works on these datasources, but then the function is not delegable so will only work on the first 500 records. You could make a Flow to remove the records. The OnSelect action would then be to fire of the Flow. Reference to make a Flow and use it in a PowerApp here: https://docs.microsoft.com/en-us/powerapps/using-logic-flows.

[Meneghino]

Got me @Rebetcha, you are correct.  I edited my earlier post.

[dries]

Thanks.

The data source is a sharepoint list.

One the screen, I only had a button. I added a gallery first, and now it works...