cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jupie354
Frequent Visitor

Use Power Automate to send email to person in Excel file

I'm new to Power Automate and am looking for some advice on the best way to do this.  I receive an email weekly with an Excel spreadsheet attached.  I would like to filter it by department, and then by items that are due in 14 days, and send an email automatically to the person(s) listed in the Project Owner(s) column, to remind them the date is coming up.  I have Office 365, so Excel Online and SharePoint are options, if using SP would be any easier.  

 

I've been playing around with it, so I can show what I've tried if that would help, but they always end up with errors or, if "successful,"  I still don't get an email.  If anyone is willing to walk me through the best way to do this, it would be greatly appreciated!  Thank you. 

3 REPLIES 3
v-bacao-msft
Community Support
Community Support

 

Hi @Jupie354 ,

 

Could you share a screenshot of the current configuration of Flow?

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jupie354
Frequent Visitor

Ok, here's what I have.  The issue I'm currently having is searching Office 365 by user ID or name.  I started out by putting my email address into the Project Owners column on the spreadsheet just to make sure I had the rest working, and it did work then.  The Project Owners column will come in the email with the names formatted like this:  Thomas, Bob F (THOMABF). Sometimes it has more than one name in the cell, separated with a semi colon.  I tried to follow some steps I found here for searching for users in Office 365, but I don't quite understand how to fit that in with what I already had working, so this is probably a mess.  I put my own name in that format in all the rows on the spreadsheet and when I run it, it says it's successful but I don't get anything.  Any ideas?  Thank you!

 

 

2019-11-25 - 1.jpg2019-11-25 - 2.jpg

 

Hi @Jupie354 ,

 

According to the situation you describe, there are two situations that will cause Flow to run successfully but you will not receive an email.

  1. The result of the Condition judgment is false, and there are no eligible rows in the table.
  2. The Body for Search for users is empty, and related users cannot be searched in the tenant.

Please check it.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,529)