Select Data Operation

[apeawakening]

I want to retrieve user from Sharepoint group , I used http request , which is working fine.
But I'm getting hull value in compose and select action.
Formula I used for Select : From - body('outputofhttprequest')['d']['results']
Map- Email : ['Emails']

Want Am I missing here.
I'm new to power automate

[AndrewR1 · Accepted solution]

Hi @apeawakening can you show me the result of the Send HTTP request is this being passed back as JSON? If so then you will need to add a Parse JSON before the select then you will be able to access all the required fields in your select. 

You will need to generator the schema for the JSON form an example of the results being passed form the HTTP request I suggest putting what you have in your select in the JSON schema running it and then copying the inputs as the example for the schema to generate for you

Give this a try and see how it goes in your select will have to be updated like this(Mine isn't using the get Users its getting all lists but its the same concept to what you will need to do): 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

[apeawakening]

Ohh yes, thanks alot.I was struggling on this.

[apeawakening]

Hi , Andrew , I successfully got all email id but they're in array , how do I separate and remove them from array so that I can get only the email in - To send an email connection.

[AndrewR1]

Hi @apeawakening Use other solution (Replace) 
Andrew

[apeawakening]

Holy crap, I had used parse json the way you guided in the example above , so basically I have to use apply for each just to send mail.
I myself used selection operator to store them in array which was not require in my scenario .

[AndrewR1 · Accepted solution]

@apeawakening You can use replace expression and warp you email array in: 

replace(replace(variables('EmailArray'),'{"Email":"',''),'"}','')

Here is my example working:(this way you wont need to use the for each loop to send the email)

This will then take out the parts of the email Item that you do not wish to pass and will just supply Andrew@email.com; Apeawaking@email.com; etc which the email will allow ; separated items.  

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up.

Andrew

@apeawakening