In this article, we will see how we can develop the power automate to get the email address from the person and group field and update it in a single line of text field.

Scenario:

1. We have a SharePoint list having more than 4000 records. It has a people picker field.

2. If we cross the list threshold, we won't be able to apply the filter on the people picker column, To fix this issue we need to set the email address from the people picker field to a single line of text.

3. When the threshold exceeds, we can apply the filter on a single line of text as well and will solve our problem.

Below is the power automate which I have developed and it worked successfully.

Power automate to get and set email from people field to single line of text in SharePoint list:

In the parse JSON, we have used the below schema:

{
    "@@odata.type": {
        "type""string"
    },
    "Claims": {
        "type""string"
    },
    "DisplayName": {
        "type""string"
    },
    "Email": {
        "type""string"
    },
    "Picture": {
        "type""string"
    },
    "Department": {
        "type""string"
    },
    "JobTitle": {
        "type""string"
    }
}

Power automate:


Output: