web

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

News and Announcements icon

Power Platform CommunityForums Power Automate automate emails based ...

Power Automate

Unanswered

automate emails based on dates 30 days prior to date in excel

(0) Share

Report

Report

Posted on by RD-08041721-0

8

This is my first time posting here; I tried searching but still need help. Here is what I'd like to do;

1. setup to run automatically every Monday at 9 am EST

2. open the Excel file and check dates to see if any are 30 days before what is listed.

3. Add yes to an Email sent column

3. send email to multiple users that the expiration date is coming up

I've had some luck getting it to open the excel file but that's where it all falls apart.

Thanks in Advance

Screenshot 2025-04-08 133515.jpg

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

David_MA 14,078 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

When posting, please share a screen shot of how the action that failed is configured, and the error message. I would also suggest that you use the Outlook for Microsoft 365 send mail actions rather than the one you are using, which is probably why the e-mail action is failing. Once you provide the requested information, someone will probably be able to assist.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!
1. Make sure the data in your spreadsheet is formatted as table

2. Use the Power Automate action List rows present in a table

3. Use a Select action to visualise the data. When mapping, you must use the exact column names in the spreadsheet.

I'm mapping the Title and Date columns in my spreadsheet, so my Map looks like this:

{ "Holiday Title": @{item()?['Title']}, "Holiday Date": @{item()?['Date']} }

See how you get on with the above and let me know if you need more help

Was this reply helpful? Yes No
RD-08041721-0 8 on at

Like (0)

Report
Copy link

Link copied!

@DJ_Jamba

I don't see the Select Columns option. The only option is Select.

Was this reply helpful? Yes No
RD-08041721-0 8 on at

Like (0)

Report
Copy link

Link copied!

@David_MA

I had deleted my original flow prior to posting here. Thanks for the tip on using outlook 365 for the email.

Was this reply helpful? Yes No

Join the conversation