Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Send email notification from SP server list depends of date

(0) ShareShare
ReportReport
Posted on by

Hi team,

 

Please can you advise me how to solve this little puzzle.

 

I have a Share point list for patching servers. In SP list I have columns server name, date ...

So, I need to create email report day before, depends of date, for every server name  on that date.

I hope you understand what I want to say 🙂

 

recap:

I need email report day before, for all servers on 4/13/2022 date

SP_Servers.png

 

Please give me a help

Thank you 

 

best regards

Niko

  • nmacesic Profile Picture
    on at
    Re: Send email notification from SP server list depends of date

    Hi Wearsky,

    sorry for my unclear explanation,

    First of all, I need to create a flow that needs to get all items from Share point list and send HTML reports to email.

    The HTML report needs to be in the format 

    server name, ticket number, patching date.

    but reports need to be sent by email for all servers on the same date. (consider that date is changed every month)

    HTML table reports example:

    schedule, server name, patching date

    00-TH-1000-L,servername01, 4/13/2022 10:00

    00-TH-1000-L,servername02, 4/13/2022 10:00

    00-TH-1000-L,servername03, 4/13/2022 10:00

    00-WE-1000-L,servername01, 4/13/2022 10:00

     

    I hope is now I explain clearly what I need 🙂

    please if you have some idea

     

    best regards 

    Nikola

     

  • v-xiaochen-msft Profile Picture
    on at
    Re: Send email notification from SP server list depends of date

    Hi @nmacesic ,

     

    Sorry I can't understand your needs. Could you clarify it?

    Besides, you could try adddays() function and formatdatetime function/

     

    Best Regards,

    Wearsky

  • nmacesic Profile Picture
    on at
    Re: Send email notification from SP server list depends of date

    not only for 4/13/2022 date, but also for every date one day before.

     

    servers.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492