cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
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!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (6,869)