From Get Items outputs

Question

Hi,

I have used GetItem SharePoint action,

I need to take only one particular field value that is Email

Can anyone help how to get that particular field value from GetItems action

Answer 1

Hi @Vijay

Is this what you want to accomplish:

1- select the sharepoint site
2 - select the list name
3 - add the "ID" field from the trigger "When an item is create or modified"
4- The "get item" should have the field you need

Running that extracted only one field:

Answer 2

Hi @Vijay ,

Welcome to Microsoft Q&A Platform. Thank you for the question.

You can use parse json with the output of previous step and then in compose get the value of required field.

Refer the below dummy LA for the reference,

Expression: body('Parse_JSON')?['value'][0]?['Author']?['Email']

Regards,
Kamlesh Kumar

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is How

Want a reminder to come back and check responses? Here is how to subscribe to a Notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators