I have the following Get Items action:-

enter image description here

where the response body will be as follow:-

enter image description here

now i need to extract the email address from the claim field as follow, where i need the email to be added inside "Grant access to item or file"? any advice how i can do such an extract?

  • Is ResponsiblePerson column of type "Person or Group" (I think so)? If yes, you should get the email address in response of "Get items" action similar to this. Jun 16, 2021 at 15:48
  • @GaneshSanap i tired this but the email will be empty.. and yes the ResponsiblePerson is of type People or group
    – John John
    Jun 16, 2021 at 16:18
  • @GaneshSanap as you can see from the picture i provided there is no email field inside the returned json
    – John John
    Jun 16, 2021 at 16:20
  • Strange...I just tried this by creating a flow & I am getting email address in response of "Get items" action. Jun 16, 2021 at 16:34

1 Answer 1


I just tested it. I currently get an item with a filter query by executing a Get Items step in Flow.

Another thing to note is that i just created the list and added a list column. as you can see from the below screenshots i get all of the attributes that are about a person field.

flow screenshot

flow JSON results

You might not be getting the properties if the list or column was created a long time ago OR (something else that i have noticed) if you created your list from the "add an app" button, which is classic experience.

Another thing that might be in place is that the Get Items actions is somehow stuck(this has occured to me, not all the time, but it has). In this case, please delete the step and recreate it.

Have you tried making a new list and trying the flow on the new list? How was the list created?

[Edit] i'm just stressing out the fact that the list was just created with a certain way because i had faced an unexplained bug when trying to publish an infopath form to a list, which i described here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.