Preview Before Update or Delete for Microsoft Dynamics 365 Business Central
A filter that looks right can still catch more records than intended, and an update or delete across the wrong set is hard to reverse. Import Export PowerTool shows the records a filter will affect before you run an update or delete. This is a completely free app from Insight Works for Business Central.
How Preview before update or delete works in Import Export PowerTool
- Set the Operation to Update or Delete and enter the table and filter.
- Open the preview.
- Check the records, as formatted filter data or raw table data.
- Adjust the filter if needed, then run the operation.
Key capabilities
Exact record set
Preview lists exactly which records the current filter selects, so the count and the records can be checked before anything changes.
Two views
View the selection as formatted filter data, or as raw table data with every field.
Before every risky operation
Use preview before an update or a delete, then adjust the filter if the result is not what you expected.
Adjust and preview again
Change the filter and preview again until the selection matches what you intend, then run the operation.
Details that matter on the floor
Check raw data for hidden fields
The raw table view shows fields a page may hide, which helps when working with protected tables that have no page of their own.
Who uses Preview before update or delete
Business Central consultants
Confirm a filter before a data fix.
Business Central administrators
Check the scope of a cleanup before approving it.
Questions about Preview before update or delete
Can I see which records will change before a bulk update?
Yes. Import Export PowerTool previews the records a filter selects, before an update or delete runs.
What does the preview show?
The selected records, either as formatted filter data or as raw table data.
Does preview change any data?
No. Preview only shows the records the filter selects; nothing changes until you run the update or delete.
Related Import Export PowerTool features
All Import Export PowerTool features →Part of Import Export PowerTool
Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.
Have a question about Preview before update or delete?
Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.