Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Trouble Sending Emails...
Power Automate - Building Flows
Answered

Trouble Sending Emails Based on List Item Criteria

(2) ShareShare
ReportReport
Posted on by GK-04081917-0 10
So, I have a list in which various projects are tracked.  Columns in the list include things like the staff member(s) assigned, the date it will take place, a calculated column that has the date by which a page for the project must be published on a website, and a column that tracks that pages status. I am trying to build a flow that runs once in the morning and emails the staff assigned to a project if the page has not been published and today is the deadline. So far I have successfully gotten the list of items that do not have a 'Published' status (screenshot: 
and checked if today is their deadline date (Screenshot:
.
The problem is that when I then try to send an email to the staff assigned to that item, I get an error message:
Clearly I've mis-stepped somewhere, but I only really started using PowerAutomate maybe a week ago, and am not sure how to figure out what I've done wrong. 
Categories:
Business Process Flows
  • GK-04081917-0 Profile Picture
    GK-04081917-0 10 on at
    Trouble Sending Emails Based on List Item Criteria
    Switched 'current item' to 'assigned to' and that did the trick! Thank you!
  • Verified answer
    abm abm Profile Picture
    abm abm 32,472 Most Valuable Professional on at
    Trouble Sending Emails Based on List Item Criteria
    Thanks for the quick reply. The issue is the Apply to Each 2 where the value mapped as Current Item which is wrong. Try deleting the apply to each 2 and add the send email step then map the Email. That will create another apply to each but it will set the right mapping automatically. Let me know how it goes.
     
    Thanks
  • GK-04081917-0 Profile Picture
    GK-04081917-0 10 on at
    Trouble Sending Emails Based on List Item Criteria
    Person Or Group. When I made a flow to send an email when an item was added to the list, I was able select Assigned to Email from Dynamic Content and it sent the emails just fine no matter how many people were assigned, and have tried to do the same thing here, but it doesn't seem to be working the same way.
  • abm abm Profile Picture
    abm abm 32,472 Most Valuable Professional on at
    Trouble Sending Emails Based on List Item Criteria
    Hi
     
    What's the field type in SharePoint email field?
     
    Thanks

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans