I think this could work for other Data Sources like dataverse as well.
Case Use: I used this to make sure duplicate appointment records did come over from the MS Bookings platform when I needed to do a large migration of the data  using power automate and the Microsoft Graph API.  Flow would bomb out and I think started again at the record it left off causing around 100 dups.

This flow helped me ID the duplicates and since there wasn't too many I went it and deleted in the list itself.  You could add a "Delete Item" action to this flow to do it for you.

Use case: Verify mailing addresses are valid with the Unites States Postal Services before mailing out large quantities of piece mail or check payments.  Thus reducing mailing returns.
In this flow I am doing a bulk address standardization. You would really only need to do that once and then maybe use an "Update" row after that.

First you will need a Smarty Streets account. You can try a trial version to test if this solution is best for you.

 Cannot be used as a child workflow because it is missing a response action

Follow these instructions

Add the action "Respond to a Power App or flow"

Add "Text" output

First Field: Status

Second Field: Done

Part 4

Power Platform Custom Connector
(I always build my stuff in Solutions, click here for more information about PowerPlatform Solutions)

1. Create and Name the Custom Connector

2. Scheme = HTTPS

3. Host is 

Part 3

Create a Bearer Token to make API calls using PostMan 

(You should have your newly installed plugin available to copy and paste Client ID and Client Secret)

Part 2

Install the Plugin in PowerSchool

1. Log in to your PowerSchool Admin account 
2. Select System under Setup in the main menu 
3. Select System Settings under the Server section 
4. Select Plugin Management Configuration 
5. Click Install 
6. Select the plugin file (XML) you just created to install 
7. Click Install 

Part 3>

Part One

Create the Plugin for PowerSchool for Office
(Thank You BlayneC )