web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send Reminder Email bu...
Power Automate
Suggested Answer

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

(2) ShareShare
ReportReport
Posted on by 1,176
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:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,963 Moderator on at
    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.
     
     
     
     
     
  • Suggested answer
    AnthonyAmador Profile Picture
    2,557 Moderator on at
    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

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 780

#2
Valantis Profile Picture

Valantis 668

#3
Haque Profile Picture

Haque 601

Last 30 days Overall leaderboard