Share via

How to set up a automate rule to delete SharePoint site contact when it is expired.

Jason Tang 0 Reputation points
2024-07-09T04:39:08.8066667+00:00

Hi all,

May I ask if there a way to create a Automate Flow to delete a site contact depends on the expire date?

For example, I have added a column called Expire:

User's image

Is there any way to get this file deleted when it is expired and send a notification out?

Thank you in advance.

Regards,

Jason

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,282 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,185 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,212 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
547 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenXu-MSFT 18,046 Reputation points Microsoft Vendor
    2024-07-09T06:57:43.47+00:00

    Hi @Jason Tang,

    To automatically delete list items depends on the expire date, please create a Power Auto mate flow like below.

    1.Create a Scheduled cloud flow. Start from today or tomorrow 12:00AM and repeat every day.

    User's image

    2.Add an action "Get items". Set the filter query to Expire le'utcNow()'.

    User's image

    3.Add an action "Delete item" like below.

    User's image

    Save it and you will get what you want.

    Thanks.

    If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.