I have a main list 'Actions Types', where to each type of 'Action Type ID' is assigned a Person (using Person of Group field).

Using a JSON code, I created a single text column (named 'Owner Email Address') column where the email address of that person is extracted.

Now I have a second list: Actions.

Each action has an 'Action type' lookup column so that when the type value is selected (from the 'Action Type ID' list) then the related 'Owner Email Address' is pulled in .

No value is added though, the field remains blank. If I add default additional fields such as 'Modified' or 'Created' those appears correctly.

Has anybody some clue while the 'Owner Email Address' values , which is a single text column, are not being pulled in?

1 Answer 1


The first JSON you are using to show the email address in 'Owner Email Address' field is written using SharePoint JSON formatting and SharePoint JSON formatting only customizes the display of columns/views. It does not store/save any value in the column the itself.

Hence, you cannot refer the "displayed" values of 'Owner Email Address' column using the SharePoint lookup column in the second SharePoint list (Actions).

Documentation: Use column formatting to customize SharePoint

enter image description here

You will have to store the actual email addresses in 'Owner Email Address' column using Power Apps customized forms or using Power automate flow (on item creation and/or item update).

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.