web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums 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) Share

Report

Report

Posted on by Kubiaka

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)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee 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

Join the conversation