Skip to main content

Notifications

Announcements

Upwork and Microsoft Power Platform Partnership
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 / Send Reminder Email bu...
Power Automate - Building Flows
Suggested answer

Send Reminder Email but using the Get Item function in a New Flow

(2) ShareShare
ReportReport
Posted on by Chris1968 1,101
Hi,

My goal is to send a reminder email to potentially a number of people depending on the Request Status and the Modified date.

I'm getting that the flow ran successfully but not receiving an e-mail.









I'm hoping someone can give me details of what I've done wrong or what I haven't included....


Updated 09/09/2024 11:30 GMT

Here is the full flow



Output from Get Items



SharePoint list / columns

Categories:
Business Process Flows
  • Suggested answer
    AnthonyAmador Profile Picture
    AnthonyAmador 2,553 Super User 2025 Season 1 on at
    Send Reminder Email but using the Get Item function in a New Flow
    Hi,

    I think you need to remove the “For each” action and only use the “Apply to each” action that is automatically created when you set up the Switch action. Make sure that the strings you are comparing in the cases and the Request status are exactly the same, as these comparisons are case and space sensitive.

    Let me know if that helps.
    Anthony
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 43,417 Super User 2025 Season 1 on at
    Send Reminder Email but using the Get Item function in a New Flow
    Hi,
     
    Without seeing a full flow run, with data in and out of each Action, then all I can go on is that you aren't returning any records.
     
    looking at your partial flow run, it doesnt seem to have done anything inside the loop.
     
    Can you please share your entire Flow Run, with all steps opened up.
     
    Again my guess is you have no records to loop through, so you need to verify that the data is a match. To verify the match, add a Compose above your Get Items.
    In the compose put your Filter so that you can see what values are being used.
     
    My guess is your Date format/value is probably off so pick a row that you know should be XYZ details. And then you can see exactly what is there.
     
    Now another thing you can do, is add another Get item not items, specifically make it pull the 1 row that you have the SharePoint ID for. Then you can see the Date values etc for that row. Now you use that to compare the format against what you did for formatting in your Get Items.
     
     
     
     
     

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

Upwork and Microsoft Power Platform Partnership
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 > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans