Answered

Trouble Sending Emails Based on List Item Criteria

(2) Share

Report

Posted on by GK-04081917-0

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:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi

What's the field type in SharePoint email field?

Thanks

Was this reply helpful? Yes No
GK-04081917-0 10 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No
GK-04081917-0 10 on at

Like (2)

Report

Switched 'current item' to 'assigned to' and that did the trick! Thank you!

Was this reply helpful? Yes No