News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Delete Multiple Histor...

Customer experience | Sales, Customer Insights,...

Answered

Delete Multiple History Records Based on List of email addresses

(0) Share

Report

Report

Posted on by Community member

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!

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

pavanmanideep 1,329 on at

Like (1)

Report

Delete Multiple History Records Based on List of email addresses

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans