Forum Discussion

Nick_DS's avatar
Nick_DS
Copper Contributor
Jul 25, 2023

Send a mail every month when a field is still empty

Hi,

 

I have a list in Sharepoint with 30 fields (columns). This list needs to be filled in by multiple people and all fields need to be filled with data.

I want to send a mail to 1 person at the end of each month when at least 1 field is still empty.

 

How can I do this?

Be aware, please don't be to cryptic, it has been years since I have created rules/flows in Sharepoint 🙂

Lists
SharePoint Online

12 Replies

  • Vivek Jagga's avatar
    Vivek Jagga
    Copper Contributor
    Jul 25, 2023
    Hi Nick,

    You can use capability of Microsoft Power Automate or Azure Logic App. You can decide the option based on the volume of items in list.
    • Nick_DS's avatar
      Nick_DS
      Copper Contributor
      Jul 27, 2023

      Vivek Jagga I tried, but it makes an APPLY TO EACH every time :

       

       

      But then it sends me a mail per item, and I want 1 mail with all the items ?

       

       

Resources