Skip to content
Import Export PowerTool app iconImport Export PowerToolUpdate and delete

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

  1. Set the Operation to Update or Delete and enter the table and filter.
  2. Open the preview.
  3. Check the records, as formatted filter data or raw table data.
  4. 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.

Import Export PowerTool app icon

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.

Ask a product question

Product Questions