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

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

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

< 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

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

dries
Frequent Visitor

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (35,245)