web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I have an Excel sheet ...
Power Automate
Answered

I have an Excel sheet in SharePoint and want to select items by month and send them in email using power automate

(0) ShareShare
ReportReport
Posted on by 16

I have an Excel sheet in SharePoint that we use to track responses to a Microsoft form submission for employee of the month.  I have a column that is a numeric month value (1-12) as to what month the employee was nominated for. What I want to do is on the first day of the month get all the rows that are from last month only, then email a list of those rows so that HR can choose the employee of the month. What I am stuck on is how to filter it and drop it in an email.  I am fairly new to using power automate so any assistance is greatly appreciated.

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    on at

    Hi @Kubiaka ,

     

    I have made a simple test for your reference.

    vyujincuimsft_0-1665641690447.png

    add(int(formatDateTime(utcNow(),'MM')),-1)
    <style>
    table {
     border: 1px solid #1C6EA4;
     background-color: #EEEEEE;
     width: 100%;
     text-align: left;
     border-collapse: collapse;
    }
    table td, table th {
     border: 1px solid #AAAAAA;
     padding: 3px 2px;
    }
    table tbody td {
     font-size: 13px;
    }
    table thead {
     background: #1C6EA4;
     border-bottom: 2px solid #444444;
    }
    table thead th {
     font-size: 15px;
     font-weight: bold;
     color: #FFFFFF;
     border-left: 2px solid #D0E4F5;
    }
    </style>

    vyujincuimsft_1-1665641764126.pngvyujincuimsft_2-1665641772410.png

    vyujincuimsft_4-1665641829027.png

    vyujincuimsft_3-1665641778210.png

    Result Screenshot:

    vyujincuimsft_5-1665641871312.png

     

     

    Best Regards,

    Charlie Choi

  • Kubiaka Profile Picture
    16 on at

    Charlie, 

     

    You are the best!  That worked perfectly!

     

    Thank you very much for the help!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 223 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 205 Most Valuable Professional

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard