cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BleandroDaSilva
Level: Powered On

Approval request to Delete a team site on premises

Hello Y'all, 

I hope everything is going well. 

I have an Excel sheet with 3000+ SharePoint team site on-premises that have not beings used in my organization for the last 90 days.

So, I want to use a flow to gather information from this Excel sheet, based on team site owner and team site URL and email it individually to each team site owner asking permission to close the team site, the answer should come to me directly via Outlook or somehow update a spreadsheet.

Any advice is more than welcome. Thank you in advance. 

1 REPLY 1
Super User
Super User

Re: Approval request to Delete a team site on premises

Hi @BleandroDaSilva 

 

Depending on how automated you want this process to be, you could either start the process from a manual trigger e.g. a Flow Button, or you could run this on a schedule to keep sending emails out on a regular basis.

 

If you have your Excel spreadsheet within cloud storage, and you've set up your data as a table, then you can use the "List rows present in a table" action to get back the rows.

 

I would then use the "Send email with options" action to fire out an email with two push buttons allowing them to either say "Yes" or "No" to the deletion.

 

DeleteSite1.PNG

 

Flow will then capture the response and you can process from there as you like.

 

DeleteSite2.PNG

 

 

 





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,828)