Power Automate Flow Template to ID & Remove Duplicate Phone Numbers

Question

Hello,

Does anyone have a Power Automate Flow template to ID and remove duplicate phone numbers from RE?

My current process is exporting a query that looks for records that have multiple phone types on the record, ID'ing duplicate phone numbers in Excel, importing the duplicate phones with the "Delete" phone type, then running the Delete Phones plug in.

I'd love to streamline/automate this process. I started to build out a Flow for this (since I wasn't able to find a post about this in the Sky Developer general discussions) and was curious if anyone already had a template that I could adapt.

Thank you!

Adelle

Adelle Mantle · Answer

Thank you both! I think I'll do an initial clean of dupe phones manually then set up a Flow to check phones added in the last 24 hours.

Austen Brown · Answer

Rather than running against your entire database, you could set this to run against phones added in the last 24 hours and then run a search for each through API, and if returns a potential duplicate evaluate it with a series of conditional controls to determine if you want to be notified or automatically delete the dup.

Alex Wong · Answer

I don't think using API and power automate will be better unless you have Azure SQL backend to persist the data. If you do:

You can use the get all phone api endpoint, which can be a LOT depending on size of your database, and if there are more than 5000 (limit of phone returned per API call), you will need to use LOOP to get all of it.

Once you have all the phone data in Azure SQL, you can identify dup phone number by per constituent and get the phone system record id to issue a delete phone operation.