Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

HTTP request gives wrong email format

(0) ShareShare
ReportReport
Posted on by

As part of an automatic notification system I'm developing i want to use an HTTP request for SharePoint which gives me a list of user emails in a group. i followed this thread (Guide)  to set up the HTTP request, check the outputs, and get everything working:

 

AussieD_0-1705600303536.png

Everything succeeds except for later at the very bottom where an email action errors out because of the format that the emails are spat out in from the join function:

AussieD_1-1705600368449.pngAussieD_2-1705600410727.png

AussieD_3-1705600642757.png

 

Emails Blurred for privacy, the issue is that the join function is adding or keeping the "{\" components from the HTTP request, and the Email action just wants emails separated by Semicolons.

AM i going about this in the right way? and if i am is there something i can change to format the end result of the join action to be something the email action accepts.

 

Thank you 🙂

  • AussieD Profile Picture
    on at
    Re: HTTP request gives wrong email format

    Agh i see! that fixed it. I'll need to do more reading into the difference between Text and Key/Value mode.

  • Verified answer
    Expiscornovus Profile Picture
    31,732 Most Valuable Professional on at
    Re: HTTP request gives wrong email format

    Hi @AussieD,


    Yes, that could be the issue. Like @tom_riha has mentioned in his blog:

    … and select only the email addresses. Don’t forget to switch to the Text only mode!

     

    You can switch the Map field of the Select action to text mode with the 't' button on the right side of the value column.

     

    After that you should have a Map field with only one column (text mode) instead of two columns (key/value mode).

  • AussieD Profile Picture
    on at
    Re: HTTP request gives wrong email format

    AussieD_0-1705610408276.png

    i was thinking this is where the root of the issue was, is there a way i can specify the format of the output? like in the Map value?

  • Expiscornovus Profile Picture
    31,732 Most Valuable Professional on at
    Re: HTTP request gives wrong email format

    Hi @AussieD,

     

    How did you configure your Select action? Can you share a screenshot of that action expanded/with parameters as well?

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

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 >