Announcements
Hi,
I would like to update 50000 records in canvas app. Can someone guide me.
I want to calculate the days differences between two dates and update the difference to a field.
Hey! To calcualte you can use a DateDiff(Date1, Date2)
To calculate the difference between two date convert the string to DateValue and then DateDiff function. Check the formula below.
DateDiff(DateValue(Label1.Text),DateValue(Label2.Text));
@PapithaSekar1
In general, it is poor design to save a calculated value in a database back end when it can be easily calculated and displayed in PowerApps as described by @Nogueira1306 and @vidyadhar
I would like to know how can i patch 50000 record with the calculated value.
Then, my advice is to update them through power automate
thank you
@PapithaSekar1 ,
I strongly suggest you read this document on Throttling before you attempt this and also be mindful for your Flow API call limit - either could cause your a lot of issues with what you are proposing to do.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 405 Super User 2026 Season 2
Mohsin Ali 368
WarrenBelz 244 Most Valuable Professional
