Hi,
It is possible to list them using the API
You can even use it to delete it.
You could build a simple app and flow such as the below.
1. Create a SharePoint List with things like
---DataSource Name
---DataSource Status (you can get the status from the API
---Action (this is where you could put something like Delete) so the Flow knows to delete it if its set to Delete or None(to do nothing)
---DataSourceActionStatus (you could put like "Deleted" here or Blank/empty string if you haven't done an action
---DeletedBy (the record already captures who created the row but... i like to do it here) capture the email of the person who wrote the record
---DeletedDateTime when the flow successfully deletes a source, have it write the time here
2. Create a Power Automate Flow automated flow (you could make a manual one for testing)
3. Use the Flow to Call the API for Get DataSources
4. Have it write the DataSources it finds into the List. Make sure to have the Flow validate if the Record so you dont add the same thing twice.
5. Create a simple Canvas App (or SharePoint Point), that lets populate the current datasources and lets you select and Mark datasources to be deleted
6. Have a secondary Flow that runs and looks for any Actions that are Delete, it then calls the Gateway to delete it then it updates the DeletedBy and DeletedDateTime and Sets Action to None. That or, simply have the original flow, get all the datasources first to add any new ones, then have the same flow do the deletes. I would make it a scheduled set of Flow(s) and run it every day at some off peak time.
And there you go a way to what you asked.
Share
Report
All responses (
Answers (
53,362
