If column is hidden, its value doesnt get displayed in Header or footer

[NWH-SAmin5]

Target SharePoint environment

SharePoint Online

What SharePoint development model, framework, SDK or API is this about?

Declarative list formatting

Developer environment

Windows

What browser(s) / client(s) have you tested

• 💥 Microsoft Edge
• 💥 Google Chrome

Describe the bug / error

When a column is unchecked to hide from a View/Edit view. That particular column value does not get displayed when used in Header or footer json.

Steps to reproduce

1. Create a list
2. Add Title, FullName columns to the list
3. Edit column > uncheck FullName
4. Configure layout > Header > add json
   { "elmType": "div", "txtContent": "[$FullName]" }
5. FullName value will not get displayed in header.

Expected behavior

We should be able to hide the field from view/edit form, but use its value to display in header or footer

Thank you for reporting this issue. We will be triaging your incoming issue as soon as possible.

[michaelhan-1]

In JSON formatting, we could only be able to reference columns that are being returned by the view.

The similar issue has been discussed here: #1250

Michael Han
Microsoft SharePoint Community Support

[NWH-SAmin5]

I have all the columns added in the view. I am only trying to hide the column in Edit form as editable field and display its existing value in the header

This is my scenario
List view: Title, FullName, Phone

Form configuration:
Show: Title, Phone
Hide: FullName

Header JSON:
{ "elmType": "div", "txtContent": "[$FullName]" }

Body JSON:

{
    "sections": [
        {
            "displayname": "",
            "fields": [
                "Title",
                "Phone"
            ]
        }
    ]
}

With above configuration value for FullName is not getting displayed

[NWH-SAmin5]

@shagra-ms do you know if anyone can help on this?

[taylora3]

Hello 👋 I have been able to get field values to display in the header and footer. The trick is to have the field ticked and set it's visibility to false in the "Edit Columns" Conditional formula.

[github-actions]

Thank you for taking the time to file an issue. We periodically archive older or inactive issues as part of our issue management process, which automatically closes them once they are archived.

If you’d like to understand more about why and how we handle archived (closed) issues, please see Our approach to closed issues.

We appreciate your contribution and if this is still an active issue with the latest SPFx versions, please do resubmit the details. We needed to perform a cleanup, so that we can start with a clean table with a new process. We apologize for the inconvenience this might cause.