Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

E-mail Reminder based on Due Date from SharePoint List

(0) ShareShare
ReportReport
Posted on by 6

I already have a flow setup but I can't seem to make the HTTP request function to send an email work.

 

These are the actions I have right now:

 

delete.png

 

 

 

delete2.png

 

 

delete3.png

 

 

delete4.png

 

I don't know what I'm doing wrong. Please help 😥

  • annetoal Profile Picture
    1,934 Super User 2025 Season 1 on at
    Re: E-mail Reminder based on Due Date from SharePoint List

    Would you please show the outputs of Next Act... and stringDaysOut
    Did you get this error when you tried running it with the HTTP request to SharePoint to send email? If not, what else changed?

     

     

  • nabiang Profile Picture
    6 on at
    Re: E-mail Reminder based on Due Date from SharePoint List

    So I followed what you said and just used the Outlook Send Email action. However, now I'm getting this error on the Email action:

     

    nabiang_1-1684511888194.png

     

    Also, this action automatically added itself when I selected the 'person' field email from the dynamic contents list:

     

    nabiang_2-1684512107545.png

     

    BTW, the field on the SharePoint List allows multiple selection. Could this be the reason? 

  • Verified answer
    annetoal Profile Picture
    1,934 Super User 2025 Season 1 on at
    Re: E-mail Reminder based on Due Date from SharePoint List

    Okay, that's a different problem. If you don't want the approval to appear to come from your account, you have to use the "Add new connection" function found on the three horizontal tods in the lower right corner. You must have another account available to connect the action to. This is typically a "service account."

    You will have to get a service account (or work with someone who managed a service account). 

    Share the ownership of the Flow with the service account.

    Log in under the service account (or get the account owner to do it) and go to the approval step and add the service account connection to that action.

     

    If this helped, please mark it as a solution.

    Anne

  • nabiang Profile Picture
    6 on at
    Re: E-mail Reminder based on Due Date from SharePoint List

    Initially, that is what I did. However, it is sending the email reminder from my account. 

     

    The main error I'm getting is on the part where it's extracting the e-mail address from the SharePoint list. The type of field it's coming from is a 'person ' from our org's directory. 

  • annetoal Profile Picture
    1,934 Super User 2025 Season 1 on at
    Re: E-mail Reminder based on Due Date from SharePoint List

    Suggest you use one of the Outlook connectors for sending mail instead. You would address the mail to the variable stringEmailTo.

     

    If this helped, please mark it as a solution.

    Anne

     

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June 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 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1