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

Notifications

Announcements

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,148
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,362 Super User 2025 Season 2 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,553 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard