SOLVED

Merging SharePoint list content onto a SharePoint Page

%3CLINGO-SUB%20id%3D%22lingo-sub-1589888%22%20slang%3D%22en-US%22%3EMerging%20SharePoint%20list%20content%20onto%20a%20SharePoint%20Page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589888%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20SharePoint%20list%20of%20events%20that%20has%20all%20the%20detail%20about%20the%20events.%26nbsp%3B%20I%20want%20to%20do%20several%20things%20with%20it%20such%20as%20create%20a%20registration%20for%3B%20a%20calendar%2C%20survey%2C%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20also%20like%20to%20be%20able%20to%20%22merge%22%20that%20same%20SharePoint%20list%20content%20into%20a%20SharePoint%20page%20--%20the%20same%20as%20you%20would%20do%20with%20a%20PowerPoint%20or%20a%20Word%20document.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20done%20some%20quick%20searches%3B%20nothing%20extensive%20but%20I%20feel%20there%20must%20be%20a%20way%20to%20do%20that%20but%20it%20escapes%20me.%26nbsp%3B%20I%20really%20don't%20want%20to%20have%20to%20add%20all%20that%20information%20to%20a%20list%20AND%20then%20put%20much%20of%20the%20very%20same%20information%20onto%20a%20page%20--%20even%20if%20it%20will%20look%20fancier!!%20%3A).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20--%20please%20tell%20me%20I'm%20just%20missing%20the%20obvious!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20in%20advance%2C%20for%20your%20help!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1589888%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590374%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20SharePoint%20list%20content%20onto%20a%20SharePoint%20Page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F34014%22%20target%3D%22_blank%22%3E%40Cindy%20Zalme%3C%2FA%3E%26nbsp%3Bthere%20isn't%20a%20way%20to%20merge%20information%20onto%20a%20page%20as%20far%20as%20I%20am%20aware.%20What%20I%20do%20if%20I%20want%20to%20display%20the%20content%20of%20a%20list%20in%20a%20nice%20format%20on%20a%20SharePoint%20page%2C%20include%20other%20text%20where%20necessary%2C%20links%20etc%20is%20to%20use%20custom%20JSON%20view%20formatting%20then%20display%20the%20formatted%20list%20on%20the%20page%20with%20the%20List%20web%20part.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22BandBList.png%22%20style%3D%22width%3A%20972px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212580i65321663733906E8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22BandBList.png%22%20alt%3D%22BandBList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22countriesList.png%22%20style%3D%22width%3A%20678px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212579iA19A29E7BAEA63C5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22countriesList.png%22%20alt%3D%22countriesList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThat%20list%20of%20countries%20is%20on%20a%20page%20on%20our%20intranet%20with%20the%20List%20web%20part%20pointing%20to%20the%20formatted%20view.%20However%20in%20this%20case%20a%20flow%20in%20Power%20Automate%20gets%20a%20random%20country%20from%20the%20list%20each%20day%2C%20but%20as%20with%20the%20examples%20above%20you%20don't%20have%20to%20do%20that%20and%20can%20just%20display%20the%20whole%20list%20in%20a%20nicely-formatted%20way.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22randomItemList.png%22%20style%3D%22width%3A%20717px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212581iFFB43068791723A1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22randomItemList.png%22%20alt%3D%22randomItemList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20JSON%20code%20for%20that%20countries%20list%20view%20formatting%20is%20attached.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20learnt%20to%20do%20this%20by%20looking%20at%20the%20examples%20on%20GitHub%20then%20copying%2C%20pasting%20and%20experimenting.%20Some%20of%20the%20column%20examples%20are%20a%20bit%20old%20now%20and%20can%20be%20done%20with%20out-of-the-box%20column%20formatting.%20But%20it's%20a%20very%20useful%20resource%2C%20particularly%20for%20view%20formatting.%3CBR%20%2F%3E%3CBR%20%2F%3EView%20formatting%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fpnp%2Fsp-dev-list-formatting%2Ftree%2Fmaster%2Fview-samples%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fpnp%2Fsp-dev-list-formatting%2Ftree%2Fmaster%2Fview-samples%3C%2FA%3E%3C%2FP%3E%3CP%3EColumn%20formatting%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fpnp%2Fsp-dev-list-formatting%2Ftree%2Fmaster%2Fcolumn-samples%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fpnp%2Fsp-dev-list-formatting%2Ftree%2Fmaster%2Fcolumn-samples%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20a%20specific%20example%20you'd%20like%20help%20with%20to%20see%20how%20it%20would%20look%20with%20JSON%20view%20formatting%20post%20or%20PM%20me%20the%20details%20and%20I'll%20have%20a%20look.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1592931%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20SharePoint%20list%20content%20onto%20a%20SharePoint%20Page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592931%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BThat%20information%20is%20SUPER%20Helpful!%26nbsp%3B%20I%20did%20not%20realize%20I%20could%20get%20a%20decent%20looking%20view%26nbsp%3Bto%20include%20all%20the%20content!%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20will%20attempt%20to%20tackle%20this%20option%20and%20get%20back%20with%20you%20if%20I%20still%20need%20guidance!%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThank%26nbsp%3B%20you!%20Thank%20You!%20Thank%20You!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have a SharePoint list of events that has all the detail about the events.  I want to do several things with it such as create a registration for; a calendar, survey, etc. 

 

I'd also like to be able to "merge" that same SharePoint list content into a SharePoint page -- the same as you would do with a PowerPoint or a Word document. 

 

I've done some quick searches; nothing extensive but I feel there must be a way to do that but it escapes me.  I really don't want to have to add all that information to a list AND then put much of the very same information onto a page -- even if it will look fancier!! :). 

 

Any thoughts -- please tell me I'm just missing the obvious!  

 

Thanks, in advance, for your help!  

2 Replies
Best Response confirmed by Cindy Zalme (Contributor)
Solution

@Cindy Zalme 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:

 

BandBList.png

 

countriesList.png

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.

randomItemList.png

 

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

@RobElliott That information is SUPER Helpful!  I did not realize I could get a decent looking view to include all the content!  

I will attempt to tackle this option and get back with you if I still need guidance!  

Thank  you! Thank You! Thank You!