cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BleandroDaSilva
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

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (60,097)