Merging SharePoint list content onto a SharePoint Page

CindyZ there isn't a way to merge information onto a page as far as I am aware. What I do if I want to display the content of a list in a nice format on a SharePoint page, include other text where necessary, links etc is to use custom JSON view formatting then display the formatted list on the page with the List web part.

For example:

That list of countries is on a page on our intranet with the List web part pointing to the formatted view. However in this case a flow in Power Automate gets a random country from the list each day, but as with the examples above you don't have to do that and can just display the whole list in a nicely-formatted way.

The JSON code for that countries list view formatting is attached.

I learnt to do this by looking at the examples on GitHub then copying, pasting and experimenting. Some of the column examples are a bit old now and can be done with out-of-the-box column formatting. But it's a very useful resource, particularly for view formatting.

View formatting: https://github.com/pnp/sp-dev-list-formatting/tree/master/view-samples

Column formatting: https://github.com/pnp/sp-dev-list-formatting/tree/master/column-samples

If you have a specific example you'd like help with to see how it would look with JSON view formatting post or PM me the details and I'll have a look.

Rob
Los Gallardos
Microsoft Power Automate Community Super User