Dynamics Community Forum Thread Details

Delete Multiple History Records Based on List of email addresses

Hello, I created a large amount of history records for conference registrations, but about 30% of the registrations did not participate.

We have an external list of the email addresses that did not participate, and I am wondering if there is a way to use an external CSV of email addresses (which can be used to look up the contacts tied to the emails) to bulk delete those records?

Thanks!

Hi,

To bulk delete history records for non-participating registrations using an external CSV of email addresses, you can follow these steps using Power Automate:

1.Parse the CSV:
Use the Parse CSV action to read the email addresses from your CSV file you got from external sources.
2.Retrieve Records:
Use the List rows present in a table action to retrieve the history records from Dataverse based on the email addresses.
3.Filter and Delete:
Apply a filter to match the retrieved records with the email addresses from the CSV.
Use the Delete a record action to remove the matched records from Dataverse.
4.Bulk Deletion:
For a large number of records, consider using the BulkDelete unbound action.

Hope this helps...if this solved or helped you, please feel free to mark this as verified so as to help other community members.

Cheers,

PMDY

Quick Links

Subscribe to this forum!