cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dries
Frequent Visitor

Remove items form list not working

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino Community Champion
Community Champion

Re: Remove items form list not working

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/

View solution in original post

4 REPLIES 4
Meneghino Community Champion
Community Champion

Re: Remove items form list not working

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/

View solution in original post

Re: Remove items form list not working

< 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 Community Champion
Community Champion

Re: Remove items form list not working

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

dries
Frequent Visitor

Re: Remove items form list not working

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...

 

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,491)