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 / HTTP request gives wro...
Power Automate
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 🙂

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,195 Most Valuable Professional on at

    Hi @AussieD,

     

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

  • AussieD Profile Picture
    on at

    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?

  • Verified answer
    Expiscornovus Profile Picture
    33,195 Most Valuable Professional on at

    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

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

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 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard