web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Is there a way to vali...
Finance | Project Operations, Human Resources, ...
Answered

Is there a way to validate data on Update_Recordset even if we skip table data methods?

(1) ShareShare
ReportReport
Posted on by JohnBright 115
Hi experts, 
I am updating a table through update_recordset. This table has mass data. To optimize the performance of updation, I have skipped the data methods through skipdataMethods option. But now, the client needs to validate records on updating. I am exploring is there any way that we could still validate the records on updating through update_Recordset even after skipping the methods? This question might be senseless. I understand validating by not skipping the data methods is the best practice. But just exploring is there any other way that we could validate without sacrificing the performance? 
 
Thanks in advacne, 
John
I have the same question (0)
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 8,034 Super User 2025 Season 2 on at
    Is there a way to validate data on Update_Recordset even if we skip table data methods?
    Hi John,
     
    I don't think it's possible. Update_recordset will fall back to record-by-record operation once you remove the skipdataMethod(true) and that's because the update method of the table will have some logic.
     
    So if you want to validate each record you want to update, I don't think it makes sense for update_recordset to work without sacrificing performance.
     
     
    Thanks,
    Layan Jweihan
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,361 Super User 2025 Season 2 on at
    Is there a way to validate data on Update_Recordset even if we skip table data methods?
    Hi John,
     
    Like Layan mentioned, you would lose performance when validating the records. You can also consider running another batch job for validating the records afterwards, but that depends on the severity of the validation.
  • Verified answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Is there a way to validate data on Update_Recordset even if we skip table data methods?
    Hi,
    As Andre said, instead of processing all the data at once using update_recordset, you can split the data into smaller batches. After processing each batch, you can apply data methods for validation. This way, you can ensure that data is validated periodically without sacrificing too much performance.
    Best regards,
    Kevin

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 885 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans