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:
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:
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 🙂
Agh i see! that fixed it. I'll need to do more reading into the difference between Text and Key/Value mode.
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).
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?
Hi @AussieD,
How did you configure your Select action? Can you share a screenshot of that action expanded/with parameters as well?