Niklas Wilhelm (hubsite365.com)

Pro User MyRole

Hot News Focus

SharePoint Online

[URL] Worldwide Content Releastionship

<div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;1,&quot;sectionIndex&quot;&#58;1,&quot;sectionFactor&quot;&#58;12,&quot;controlIndex&quot;&#58;0&#125;,&quot;controlType&quot;&#58;3,&quot;id&quot;&#58;&quot;e9e7afef-5365-428f-8c4d-73401bad44e8&quot;,&quot;webPartId&quot;&#58;&quot;d1d91016-032f-456d-98a4-721247c305e8&quot;,&quot;rteInstanceId&quot;&#58;&quot;bb0abac5-05fa-4cec-aa88-0e5a5ac28820&quot;,&quot;addedFromPersistedData&quot;&#58;true,&quot;reservedHeight&quot;&#58;288,&quot;reservedWidth&quot;&#58;1178&#125;"><div data-sp-webpart="" data-sp-webpartdataversion="1.11" data-sp-webpartdata="&#123;&quot;id&quot;&#58;&quot;d1d91016-032f-456d-98a4-721247c305e8&quot;,&quot;instanceId&quot;&#58;&quot;e9e7afef-5365-428f-8c4d-73401bad44e8&quot;,&quot;title&quot;&#58;&quot;Image&quot;,&quot;description&quot;&#58;&quot;Add an image, picture or photo to your page including text overlays and ability to crop and resize images.&quot;,&quot;audiences&quot;&#58;[],&quot;serverProcessedContent&quot;&#58;&#123;&quot;htmlStrings&quot;&#58;&#123;&#125;,&quot;searchablePlainTexts&quot;&#58;&#123;&#125;,&quot;imageSources&quot;&#58;&#123;&quot;imageSource&quot;&#58;&quot;/sites/M365-CDN/SiteAssets/SitePages/Content-8123/2587856225-ezgif.com-gif-maker.gif&quot;&#125;,&quot;links&quot;&#58;&#123;&#125;,&quot;customMetadata&quot;&#58;&#123;&quot;imageSource&quot;&#58;&#123;&quot;siteId&quot;&#58;&quot;40ef054e-5ec7-4552-ac92-09bbd4faa5e1&quot;,&quot;webId&quot;&#58;&quot;35f81bac-1b1d-4f8c-a038-0302a1a6ae55&quot;,&quot;listId&quot;&#58;&quot;870ffa3e-eb32-4905-82ab-9e57adb99968&quot;,&quot;uniqueId&quot;&#58;&quot;eb613f18-cf01-4982-ace3-3c8bccc3f642&quot;,&quot;width&quot;&#58;600,&quot;height&quot;&#58;262&#125;&#125;&#125;,&quot;dataVersion&quot;&#58;&quot;1.11&quot;,&quot;properties&quot;&#58;&#123;&quot;id&quot;&#58;&quot;4af2c0f1-52ca-4b9f-bac6-61794a73963e&quot;,&quot;linkUrl&quot;&#58;&quot;&quot;,&quot;isInlineImage&quot;&#58;true,&quot;siteId&quot;&#58;&quot;40ef054e-5ec7-4552-ac92-09bbd4faa5e1&quot;,&quot;webId&quot;&#58;&quot;35f81bac-1b1d-4f8c-a038-0302a1a6ae55&quot;,&quot;listId&quot;&#58;&quot;870ffa3e-eb32-4905-82ab-9e57adb99968&quot;,&quot;uniqueId&quot;&#58;&quot;eb613f18-cf01-4982-ace3-3c8bccc3f642&quot;,&quot;imgHeight&quot;&#58;262,&quot;imgWidth&quot;&#58;600,&quot;imageSourceType&quot;&#58;2,&quot;alignment&quot;&#58;&quot;Center&quot;,&quot;fileName&quot;&#58;&quot;ezgif.com-gif-maker.gif&quot;,&quot;fixAspectRatio&quot;&#58;false,&quot;overlayText&quot;&#58;&quot;&quot;,&quot;altText&quot;&#58;&quot;&quot;,&quot;overlayTextStyles&quot;&#58;&#123;&quot;textColor&quot;&#58;&quot;light&quot;,&quot;isBold&quot;&#58;false,&quot;isItalic&quot;&#58;false,&quot;textBoxColor&quot;&#58;&quot;dark&quot;,&quot;textBoxOpacity&quot;&#58;0.54,&quot;overlayColor&quot;&#58;&quot;light&quot;,&quot;overlayTransparency&quot;&#58;0&#125;&#125;&#125;"><div data-sp-componentid="d1d91016-032f-456d-98a4-721247c305e8"></div><div data-sp-htmlproperties=""><img data-sp-prop-name="imageSource" src="/sites/M365-CDN/SiteAssets/SitePages/Content-8123/2587856225-ezgif.com-gif-maker.gif" data-sp-cust-siteId="40ef054e-5ec7-4552-ac92-09bbd4faa5e1" data-sp-cust-webId="35f81bac-1b1d-4f8c-a038-0302a1a6ae55" data-sp-cust-listId="870ffa3e-eb32-4905-82ab-9e57adb99968" data-sp-cust-uniqueId="eb613f18-cf01-4982-ace3-3c8bccc3f642" data-sp-cust-width="600" data-sp-cust-height="262" /></div></div></div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;controlType&quot;&#58;4,&quot;id&quot;&#58;&quot;bb0abac5-05fa-4cec-aa88-0e5a5ac28820&quot;,&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;1,&quot;sectionIndex&quot;&#58;1,&quot;sectionFactor&quot;&#58;12,&quot;controlIndex&quot;&#58;1&#125;,&quot;addedFromPersistedData&quot;&#58;true&#125;"><div data-sp-rte=""><p><br></p><div tabindex="-1" data-cke-widget-wrapper="1" data-cke-filter="off" class="cke_widget_wrapper cke_widget_block cke_widget_inlineimage cke_widget_wrapper_webPartInRteInlineImage cke_widget_wrapper_webPartInRteClear cke_widget_wrapper_webPartInRteAlignCenter cke_widget_wrapper_webPartInRte" data-cke-display-name="div" data-cke-widget-id="1" role="region" aria-label="Inline image in RTE. Use Alt + F11 to go to toolbar. Use Alt + P to open the property pane."><div data-webpart-id="image" class="webPartInRte webPartInRteAlignCenter webPartInRteClear webPartInRteInlineImage cke_widget_element" data-cke-widget-data="%7B%22classes%22%3A%7B%22webPartInRteInlineImage%22%3A1%2C%22webPartInRteClear%22%3A1%2C%22webPartInRteAlignCenter%22%3A1%2C%22webPartInRte%22%3A1%7D%7D" data-cke-widget-upcasted="1" data-cke-widget-keep-attr="0" data-widget="inlineimage" data-instance-id="e9e7afef-5365-428f-8c4d-73401bad44e8" title=""></div></div><p>Did you ever wanted just a quick overview on the current site to get an idea on the structure? Well I've got your inner SharePoint Architect covered ;).</p><p>This Page Web Part pulls all lists and lookups on a site and translate it into an interactive (GoJS) ER Diagram. Additionally it shows a few alerts which might help you to discover issues with your site or lists.​​​​​​​</p><p><strong>Core features are&#58;</strong></p><ul><li>the Data gets cached, to see changes made to the lists/lookups a &quot;refresh&quot; is needed</li><li>alerts/warnings for the lists are displayed as well (Versioning/ItemCount/Threshholdlimit/..)</li><li>easy opt/in/out of alerts and fields</li><li>easy switch between Internal-/DisplayName</li><li>Download current canvas as image</li></ul><p><strong>Github Link (official /pnp/sp-dev-fx-webparts)&#58;</strong>&#160;<a data-cke-saved-href="https&#58;//github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-pnpjs-spsite-er-diagram" href="https&#58;//github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-pnpjs-spsite-er-diagram">https&#58;//github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-pnpjs-spsite-er-diagram</a></p><p><strong>Steps to Install&#58;</strong></p><ul><li>download the repo</li><li>npm install</li><li>gulp bundle --ship</li><li>gulp package-solution --ship</li><li>upload sharepoint/solution/react-pnpjs-spsite-er-diagram.sppkg to your SharePoint AppCatalog</li><li>Add App &quot;react-pnpjs-spsite-er-diagram-client-side-solution&quot; to your site</li><li>Add Page (Apps/SPSite ER Diagram)</li></ul><p><strong>For development&#58;</strong></p><ul><li>steps above +</li><li>/ER-Diagram.aspx?loadSPFX=true&amp;debugManifestsFile=https%3A%2F%2Flocalhost%3A4321%2Ftemp%2Fmanifests%2Ejs<ul style="margin-left&#58;40px;"><li>on your new Page</li></ul></li></ul></div></div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;controlType&quot;&#58;0,&quot;pageSettingsSlice&quot;&#58;&#123;&quot;isDefaultDescription&quot;&#58;true,&quot;isDefaultThumbnail&quot;&#58;true,&quot;globalRichTextStylingVersion&quot;&#58;0&#125;&#125;"></div></div>

SharePoint Lists to ER Diagram

DE Main Home

Aktuelle News, Events, Know-How, MVPs, Unternehmen und vieles mehr!

HubSite 365 - Das Netzwerk über Microsoft 365 und Azure.

DE Main Events

DE Main Copilot

DE Main Dashboard

DE Main Role Pro Office 365

DE Main Role Citizen Developer

DE Main Role Data Analytics

DE Main Role Azure Datacenter

DE Main My365

DE Main Know-How

DE Main News

DE Main Search

DE Main Content

#More-News

Create Copilot Agents with BizChat: A Step-by-Step Guide

Git Integration in Power Platform: Preview Now Available

The Underrated Excel Tool You’re Missing Out On (Saves Time)

Vorstellung des Storage Optimizer für Microsoft 365

Storage Optimizer PRO is here

10 Microsoft Teams Policy Best Practices

Migration to and from the Cloud

Optimize Apps: Use Named Formulas and Ditch OnStart

Guide to Business Rules in Dynamics 365 CRM/CE

Create a Compliance Checker in Teams with Azure OpenAI

Share a Microsoft Teams Shared Channel: Step-by-Step Guide

Coming Soon – Storage Optimizer PRO

#Top-News

AI Update: Copilot Agents in Outlook Set as Default

Create a Monthly Budget & Forecast Model in Excel

Unlocking SharePoint Command Bar: Hidden Features Revealed

Protect Your Power BI Items!

Enhance User Sharing in Power Apps Canvas App

The Benefits Of Multi-Tenant Shared Calling

What is Teams Phone Mobile?

Boost SharePoint User Engagement with Engaging Design Tips

TechCon 365 Dallas 2024

.NET Conf 2024

Microsoft Ignite 2024

ESPC 2024

Dynamics 365 Summit 2025

European Collaboration Summit 2025

European Cloud Summit 2025

Events Slider Top 01

Breaking News 01

Footer01

Media of the Month 01

Explore the Enhanced Chat & Channels on Teams!

Create a STUNNING Entry Level Data Resume in 2024 (with free template 📃)

6 Amazing Ways Microsoft Copilot Can Automate Your Work!

The Newest SharePoint Feature Is Rolling Out NOW!

New Excel and Microsoft Forms Integration Features

Optimized Power Apps V2 Trigger Guide for Flow Calls

PowerPoint: Master Unfolding Path Animation Guide

Continuous Access Evaluation Deep Dive - Securing Your Tokens!

Microsoft Business Solutions & Incentives Tutorial Guide

HomeAnnouncementSPContent01

#Shorts

Enhance Your Power BI Report: Expert Tips & Tricks

Why Excel Remains Unstoppable in 2024

Enhance Power BI Reports with Themes: A How-To Guide

Enhance RAG Scale: Boost Quality & Cut Costs

Optimize AVD Host Settings for Performance

Join the Exciting 25-Day DAX Fridays Challenge! 🎉

Set Default Skin Tone for Emojis in Microsoft Teams

Manage M365 & Security Groups with PowerApps Tools

Cut Search Costs with Smart Quantization Techniques

Using Microsoft 365 Copilot in IT: Enable self-service agents

Optimize and Manage Your Networks Effectively

Pre-Populate Fields in Power Apps: A Step-by-Step Guide

Game-Changing AVD Feature: Heres Whats New and Why

Discover Hidden Excel Tips for Enhanced Productivity

Optimizing Windows Autopilot: Device Preparation Tips

[URL] EU Content Relationship

[URL] German Content Relationship

[URL] Luxemburg Content Relationship

WebSite Community - Web DE

/crm-pages/sharepoint-lists-to-er-diagram.htm

Everyone

[URL] Swiss Content Relationship

IT Manager

Administrator

Developer

Project Manager

Community

Teams App

365HubSite App

Pro Office 365

Citizen Developer

Data Analytics

Azure  DataCenter

Microsoft

Packt

Nubelus UG (haftungsbeschränkt)

NetForce 365

ICT Solutions AG

Rencore

WebSite Community - Web.

WebSite Community - RootSite

Schweiz Community (DE-CH)

Schweiz Community (EN-CH)

WebSite Community - Web EN

SharePoint Lists to ER Diagram

Check out how Niklas Wilhelm from hubsite365 transform SharePoint Site Listdata into a beautifull Entity Relationship Diagram with SFPx. Now with Video