Answered

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

(0) Share

Report

Posted on by Kubiaka

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:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yujincui-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @Kubiaka ,

I have made a simple test for your reference.

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>

Result Screenshot:

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
Kubiaka 16 on at

Like (0)

Report
Copy link

Link copied!

Charlie,

You are the best! That worked perfectly!

Thank you very much for the help!

Was this reply helpful? Yes No