I am creating a modern SharePoint site to display some detailed content, such as data element formats and definitions for review. The content is currently stored in rows of an excel document for each data element, but the audience is not technical and not familiar with excel or SharePoint lists.
I would like to be able to name and link the data elements on the SharePoint site, and when the name is clicked on it would display a “list properties” type view of the excel row in a lightening box or on another page.
How can I do this?
An example:
My SharePoint site would list data elements such as:
DATA ELEMENTS
- Allergy
- Provider
- Facility
When clicked on, the element would be connected to the excel document and show the full row vertically that matches the data element name in a list properties type view, such as:
Data element:
Allergy
Definition:
Immune response by the body to a substance
Format:
String
Value set:
SNOMED-CT
etc…
I have over 1000 data elements so I prefer to not do this manually page by page. Any help or suggestions are appreciated!!
