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

EN Main Home

Constantly the latest news, events and article about Microsoft 365 and Azure.

HubSite 365 - The network about Microsoft 365 and Azure.

EN Main Events

EN Main Copilot

EN Main Dashboard

EN Main Role Pro Office 365

EN Main Role Citizen Developer

EN Main Role Data Analytics

EN Main Role Azure Datacenter

EN Main My365

EN Main Content

EN Main Search

EN Main News

EN Main Know-How

#More-News

Setup Custom Images in D365 with Power Apps Web Resource

Clipchamp Update: Seamless Video Editing Made Easy

Maximize Productivity: Why Use Loop in OneNote?

How To Assign Numbers In Teams At Scale

Create Professional Docs Easily With OneDrive Templates

Create a Free Fabric Sandbox: No Business Email Needed

How to Block Windows 11 Data Collection with Portmaster

Are You Still Using Spreadsheets To Manage Your Phone Numbers?

Enhanced Teams Webinar Chat for Organizers & Presenters

PowerShell Tutorial: ISE, Modules & Roles Guide for Power Platform Admins

Microsoft Copilot Studio  : Create Your Own Custom Copilot: Step-by-Step Guide

Streamlined Power Apps Consent Dialog Launches This Week

#Top-News

Optimizing AI Learning: From One Prompt, Two Prompt, One Shot

Master DP-600: Planning Data Analytics with MS Fabric

New Azure Features Launch: April 19, 2024 Update

How to create a new document from a template in OneDrive for Business

OneDrive Copilot: Streamline File Management Effortlessly

Custom SharePoint Page Templates: A Beginners Guide

Block Personal Computers with Conditional Access in Microsoft 365

Maximize Efficiency: Power Platform & Azure APIM Integration

Dynamics 365 Summit 2024

DynamicsCon LIVE

European Collaboration Summit 2024

European Cloud Summit 2024

Power Platform Developer Summit 2024

DynamicsMinds 2024

TechCon365 and PWRCON - A Microsoft 365 and Power Platform Conference

Events Slider Top 01

Breaking News 01

Footer01

Media of the Month 01

5 Essential Group Policy Tips Every Admin Needs

Maximize Productivity with Microsoft Teams Premium Upgrade

3 Steps: How to Activate Microsoft 365 Copilot

How to Apply Conditional Formatting to Power BI Line Charts

Power BI Update: Enhanced Line Chart Highlights

Explore Microsoft 365s Latest Planner & Premium Features

Enhance Reports with Power BI Popup Windows

Dynamic Sorting in PowerBI: Fixing Measure Formatting Errors

Using Microsoft Lists for a Copilot Prompt Library

HomeAnnouncementSPContent01

#Shorts

Boost Productivity with 3 Expert Microsoft Tips 2024

Mastering Double Quotes in Power Apps: A Guide

Dynamic Folder Naming in Power Automate for SharePoint

Transform Your Reports: Ultimate Power BI Makeover Guide

Maximize Task Management with Microsoft Planner 2024

Maximize Copilot: Key Phrases for Effective Prompts

Quick Document Translation & Conversion Guide 2024

Create Your Personal Plan with Microsoft Planner 2024!

Master Microsoft Copilot: Chat & Get Results - Tutorial

Quick Start Guide to Power Automate Copilot Forms

Mastering Task Organization in Private Plans from Planner

5 Essential Excel Shortcuts to Boost Productivity

Revamp Your Analytics: Modernize Power BI Reports Easily

Copilot Notebook vs Chat GPT: An In-Depth Comparison

Optimize Projects: Eliminate Overlap with New Planner Tool

[URL] German Content Relationship

[URL] EU Content Relationship

WebSite Community - Web EN

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

Everyone

[URL] Luxemburg Content Relationship

[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

TargetApplicationUrlOverwrite

Query

Object in Silder

Object on Page

Request Feature

GraphQL EndPoint

BaseURL

WebSite Community - Web.

WebSite Community - RootSite

Schweiz Community (DE-CH)

Schweiz Community (EN-CH)

WebSite Community - Web DE

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