I'm working in SharePoint Online document library and trying to display detailed approval metadata in a hover-triggered card. The data is generated dynamically via Power Automate and stored in a plain text column called Approval Summary. Each item may have a variable number of approvers.
For each approver, I want to show:
- Approver name
- Response date and time
- Response Lead time
- Approval outcome
- Comments
This card should appear when hovering over a choice-type column called "Approval Status", which reflects the overall approval outcome. The hover card's goal is to visualize individual approver responses and track who has/hasn't responded, when, and what they said.
The content stored in the "Approval Summary" column might look like this:
Jane Doe
Response: Approve
Received: 2025-07-14 10:32 AM
Lead Time: 2d 4h
Comments: Looks good to me.
------------------------------
John Smith
Response: Request Edits
Received: 2025-07-15 3:18 PM
Lead Time: 3d 1h
Comments: Needs clarification on section 3.
------------------------------
Alex Rivera
Response: Pending
Received: —
Lead Time: —
Comments: —
My question: Can I apply column-formatting JSON on the "Approval Status" column that:
- Parses the structured text from "Approval Summary"
- Styles each individual field (bold names, colored outcomes, etc.)
- Uses hover interaction to trigger the display
Or, alternatively: Is there a way to simulate this formatting without relying on dynamic JSON parsing (e.g., using white-space: pre-wrap or injecting pre-styled lines via Power Automate)?
Has anyone successfully rendered per-approver hover cards like this without splitting the data into multiple static columns? Would love insights or creative workarounds that hold up in document libraries. Thanks!
