User Profile
DenisT
Iron Contributor
Joined 9 years ago
User Widgets
Recent Discussions
Connection SharePoint List/DocLib to (Azure) SQL data
I'm not a SharePoint dev, but have some experience with SharePoint lists and also SQL. However not in combination. While researching this, I notice "Business Connectivity Services" seems to be the answer. However it seems BCS isn't really actively worked on?Is using this future proof? Lets take this simple example: In a Azure SQL database we have a list of clients. In a SharePoint list I want a choicefield with a dropdownlistpopulated with the names of these clients.Custom View Formatting: How to use a custom message when there are no items in doclib
Hello, I'm using a simple JSON to create a nice view for our users on a doclib. However when there are no items in the library, I would like to set my own custom message for the users to indicate that currently there are no items.(now we just get some icon that asks to drag items here) Is this possible? { "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json", "hideSelection": true, "hideColumnHeader": true, "rowFormatter": { "elmType": "div", "attributes": { "class": "sp-row-card" }, "children": [ { "elmType": "div", "style": { "text-align": "left" }, "children": [ { "elmType": "div", "attributes": { "class": "sp-row-title" }, "txtContent": "[$Naam_x0020_vacature]" }, { "elmType": "div", "attributes": { "class": "sp-row-listPadding" }, "txtContent": "[$Beschrijving]" }, { "elmType": "button", "customRowAction": { "action": "defaultClick" }, "txtContent": "Bekijk Vacature", "attributes": { "class": "sp-row-button" } } ] } ] } }How 'groupify' a Restored SharePoint site that still has link to old deleted group?
A user deleted an Office 365 group. We only noticed this after 30 days so restoring the group is not possible. However the SharePoint site was still in the recyclebin. I've been able to restore the SharePoint site. But how can I now recreate the Office 365 group and link it to the existing SharePoint Site? I do not get the "groupify" option on the restored SharePoint site (it still thinks it's connected to a deleted Group)Best practices: small communication sites
Does anyone have any insights on when a seperate communicationsite is viable? Sometimes topics seem a bit small to justify creating a seperate communicationsite and link it to the hub. Instead I could just create documents and pages in the hub itself instead. Or is that bad practice in the long run?Problem with page metadata
I added some columns to the "Site Pages", using fieldstypes like choice and boolean. Works perfectly for all the users who have edit permissions on the site. However, I'm seeing real weird behaviour for users with read permissions. (I'm testing using the default view /sitepages/forms/ByAuthor.aspx) The columns show up in the view, but the values are empty. (even after long wait and reindexing) If I give the user write permissions and hit F5 I can see all the metadata values. If I remove write permissions and hit F5 : all fields are empty again. Some permission related bug? Did anyone experience the same behaviour?Content in HUB sites: best practice
Is it bad practice to place doclibs in a HUB site? I have the feeling it should contain nothing but associations and rollups, not actual data. However I have a lot of scenario's where I'd like to put documents in the HUB site itself instead of creating an extra communicationsite.Renaming AAD Group doesn't reflect in SharePoint Online
When renaming a group in AAD, it is not automatically changed in SPO. For instance when looking them up in a permissionslist. When using lookupfields, it even displays the old and the new name in the list as separate entities How to solve this? I guess a manual action is also needed in SPO?
