Recent Discussions
How to perform Windows Update for SharePoint 2019 DB Cluster
Hello, We have SharePoint 2019 with two database server in HA. So, i need to update both Windows Server 2019 where DB services hosted, on separated days for each server. I'm wondering if installing patches on separated days may impact SharePoint services, also i need to know the steps to follow before restart each server after installing the patch.Solved34Views0likes1CommentHow to perform Windows Update for Exchange 2016 DAG Cluster
Hello, I need to install windows server security update on Exchange 2016 DAG which require reboot the server. I will install the updates on the first server Tuesday, and the seconde server on Wednesday. I'm wondering if installing patches on separated days may impact Exchange services, also i need to know the steps to follow before restart each server after installing the patch.Solved52Views0likes2CommentsHow to get Calculated Column Microsoft List appear in Power AutomateSharepoint Dynamic Content
Hi, I need advise on current issue I'm having. I have an Inventory List in Sharepoint. 1 of the column is calculated column. When the quantity in this column is less than 10, I would like to set rules - send email reminder to top up. However, I couldnt find Dynamic Content in the Power Automate flow. Can anyone help?Solved104Views0likes4CommentsCalculated Column Exctract text between characters
Hi I have a column with a text such as: SOS_name_subname_version_type_requester or just name_subname_version_type_requester and from this column I'd like to extract in a new column just "name_subname_version" so if it's SOS it's between the first appearance of "_" and the fourth appearance of "_". If it's not SOS then it's from the beginning until the third appearance of "_" (so ends up being "name_subname_version" as well). I tried multiple ideas and while the if statement works I haven't found something to extract between multiple appearances of the same character. Any help is very much appreciated! Example: Column Release: SOS_hello_world_1.0.0.0_initial_me hello_world_1.0.0.1_update_me Calculated Column should show: hello_world_1.0.0.0 hello_world_1.0.0.1 Thank you!Solved48Views0likes2CommentsHow can we use SharePoint list to fill a Choice Column
I imported a list of items from Excel into a SharePoint List. I’d like to use this list as the source for a Choice column across different libraries. Do I need to build a Power App to populate the column, or is there a way in SharePoint to link the Choice values directly to the list? If Power Apps is required, could you point me to resources on how to set this up? I would like this to go in the following columnSolved81Views0likes3CommentsCreate SPO list from csv with schema with calculated columns
Hi, I am trying to create a new SPO list from csv with schema. (I take the standard route: New, List, CSV. Then upload the csv file from my pc.) In general it is working ok, but I am unable to process calculated columns correctly. The column is imported, but as values rather than a formula. Here is an example of a column-definition from my schema (I have omitted various other columns which are unproblematic): ListSchema= { "schemaXmlList": [ "<Field Type=\"Calculated\" DisplayName=\"ProgrammeID_Space_ProgrammeName\" EnforceUniqueValues=\"FALSE\" Indexed=\"FALSE\" Format=\"DateOnly\" LCID=\"2057\" ResultType=\"Text\" ReadOnly=\"TRUE\" ID=\"{65de5fda-ea99-4829-ae88-c71d6d1cb2e0}\" StaticName=\"ProgrammeID_Space_ProgrammeName\" Name=\"ProgrammeID_Space_ProgrammeName\"><Formula>=ProgrammeID&\": \"& Programme</Formula><FieldRefs><FieldRef Name=\"Programme\" /><FieldRef Name=\"ProgrammeID\" /></FieldRefs></Field>" ]} All the formula does is produce a text column consisting of ProgrammeID & " " & ProgrammeName so nothing complicated. Can anyone suggest how to resolve this issue, please? Thanks, Andrew PS Why does the schema have Format=\"DateOnly\" when this field has nothing to do with dates?Solved54Views0likes2CommentsAutomated Lists numbering in PowerAutomate
Hi All, I could use some advice on a automated stream I created which is coupled to an online Microsoft List on a Sharepoint site. I want this stream to act when a new list item is created through a form to lookup the numbers in the first column. Determine the highest number that is already present and then assign a new number to the new item that is 1 higher than the highest present number. If the column has 185, 272, 284 already present, I want the stream to fill in 285 with the new item. The problem is that I keep getting this error for the last step 'edit item' The 'inputs.parameters' of workflow operation 'Item_bijwerken' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/CVB_x0020_nummer' is required to be of type 'Number/double'. The runtime value '"float(add(coalesce(int(outputs('Samenstellen')), 0), 1))"' to be converted doesn't have the expected format 'Number/double'. For this last step I use the output of the previous step which has this as it's input parameters. All the additions added to make sure that the output is a number. But with or without 'float', 'int' 'coalesce', I keep getting the same error: float(add(coalesce(int(outputs('Samenstellen')), 0), 1)) When I ask the AI what the output of this step is, it correctly states that this is a number. The EDIT ITEM step is trying to edit the correct item id. The Lists column is set to 'number'. If I switch that to text than the stream fails outright when fetching data so the input is number as well. I can't seem to figure out what is going wrong. And I hope someone here can help. Thank you.Solved83Views0likes3CommentsIssue with Sub Folder Permission Inheritance Not Breaking Properly
We are experiencing unexpected behavior in our SharePoint Online environment regarding permission inheritance on subfolders. Our document library has the following folder structure: Document Library > Common (folder) > Home (subfolder). We followed the standard procedure to stop permission inheritance on the Home subfolder, expecting it to have unique permissions separate from the Common folder. However, after stopping inheritance on Home, when we add or modify permissions on the Common folder, these permission changes still appear on the Home folder. We have verified multiple times that inheritance was stopped on Home, but changes to Common’s permissions still propagate to Home, which contradicts the expected behavior. Could you please help us understand why the Home subfolder is still inheriting permissions from the Common folder even after breaking inheritance? Is this a known issue or limitation in SharePoint Online? Are there any workarounds or fixes we can apply to ensure subfolder permissions are truly unique once inheritance is broken?Solved85Views0likes2Commentscan PnpOnline script move files to a different library and retain same created and modified dates?
Hi there, Is it possible to move Sharepoint files to a different library and retain the created & modified dates using a PowerShell script? I've only been able to do it with a PowerAutomate flow which is tedious to set up. The method I'm trying with the PowerShell script downloads the file temporarily and then uploads it but treats it as a new file - which it is - and even with steps to match the metadata - which works for all other custom columns doesn't seem to work for modified and created date fiels. I've also gone down the path of TEST API call - doesn't error but doesn't achieve end goal of moving over the created and modified dates from original file. Any pointers would be greatfully appreciated. Am I wasting my time and should I give up and use PowerAutomate?Solved127Views0likes4CommentsFind all columns internal names in SharePoint list
Hello! Is there a way I can find all internal names of columns in a SharePoint site? Rather than having to go into each column individually and check the URL? I have 20+ fields and I would like to hope there's a way to run a report of some kind to tell me what all the field names are in one list! TIA!Solved157Views0likes3CommentsCreated By column on a SharePoint list picking up wrong info
I have a general user account and another account (DAS Power Automate) that I use for Power Automate flows. I am logged in with my user account as usual but when I create an item on one SharePoint list, SharePoint enters DAS Power Automate in the Created By column. If I look at the users for the list, it shows my account as the user in the list, so I am a little confused as to why it picks up the other account. I have tested other SharePoint lists on the same site and all others correctly show my user account name in the Created By columns. Does any one have any ideas? Thank youSolved545Views0likes2CommentsJSON in hyperlink formatted column
I just need to know if it's possible to have this JSON work for a hyperlink column. The hyperlink button works but the color if the column is populated does not. The color coding works on other columns in other formats, but doesn't seem to work for a hyperlink unless my coding here is incorrect? { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=join(@currentField, '\n')", "style": { "background-color": { "operator": "?", "operands": [ { "operator": "==", "operands": ["@currentField", "SessionSchedule"] }, "", "#FFCE33" ] } }, "children": [ { "elmType": "a", "txtContent": "Edit", "attributes": { "http://URL redacted for security ": "='https://example.sharepoint.com/Lists/Button Demo/editform.aspx?ID=' + [$ID]" }, "style": { "padding": "0px 25px", "cursor": "pointer", "border": "none", "color": "white", "font-weight": "550", "background-color": "#0078d4", "text-decoration": "none", "font-size": "14px", "text-align": "center", "width": "25px" } } ] }Solved104Views0likes2CommentsCan default permission groups be restored in SharePoint Online? (Owners, Members, Visitors)
Hi everyone, In a SharePoint Online site, someone with permissions modified the default site groups (Owners, Members, and Visitors), replacing the users and groups that were originally there. This also affected several subsites and lists that inherited permissions from the main site, and even some lists with broken inheritance were unexpectedly modified. I’m not sure if that’s directly related. I have Site Collection Administrator permissions, but I’m not a SharePoint global admin, so there may be things I can’t see or do. Should I escalate this to a global admin? Is there any way to check or recover how those groups were configured a few days ago? Any advice or shared experience would be greatly appreciated. Thanks!Solved168Views0likes1Commentsite Members vs site Members
In the advanced site permissions of a team site (not associated with a Teams team), there is an item for "site-name Members". There is also a group (SharePoint Group? Microsoft 365 Group?), "site-name Members". This group contains the members that are added to the site from the Add Members button. I know this should be elementary, but can someone please explain what the difference is and what the first "site-name Members" represents (label, purpose) and the other? Why does there have to be two and why do I have to add "site-name Members" to the "site-name Members" permission item? Bonus, how does this differ for a communication site? Permissions are so confusing; I'm willing to read details if someone wants to share a link and tell me "you just need to read the MS documentation".Solved107Views0likes3CommentsSPFX call gets error "interaction required" after turning on function's System Assigned Identity
I have an spfx web part that is connected an Azure Function. All was working until I turned on the System Assigned Identity for the function. Below is my configuration while it was working: Function app: contoso-fn App Service authentication enabled Unauthenticated requests get a 302 HTTP code Microsoft is the identity provider, with app registration "contoso-fn-auth" It allows token audiences from api://<id-contoso-fn-auth> and from <my-tenant>.sharepoint.com Allowed client applications include 08e18876-6177-487e-b8b5-cf950c1e598c and <id-contoso-fn-auth> CORS: https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte and https://<my-tenant>.sharepoint.com App registration "contoso-fn-auth" (used above when setting up identity provider) Authentication > Web > Redirect URI: https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte ID tokens issued only accounts in the tenant can access this API API permissions > contoso-fn-auth > user_impersonation ; Delegated; Status: granted for tenant Expose an API: Scopes api://<id-contoso-fn-auth>/user_impersonation The code in the SPFX to request the function is something like this: this.context.aadHttpClientFactory .getClient('<id-contoso-fn-auth') .then((client: AadHttpClient): void => { client.get(<url-to-the-fn>/api/upload)...}); In the SharePoint Admin Center, under Advanced > API Access, the user_impersonation permission is approved for contoso-fn. I then changed the Function app identity, turning on "system assigned", as I needed the function to authenticate against the Azure Blob Client, and now I'm getting the following error: interaction_required: Seamless single sign on failed for the user. This can happen if the user is unable to access on premises AD or intranet zone is not configured correctly I read something about turning on the function's system assigned identity affecting how I requests tokens using the aadHttpClientFactory, but I haven't been too successful in finding how to solve the issue (including internet search and asking several LLMs). I don't need my function to have user context (I could send that from the spfx) but I need this to work without any redirects. I would appreciate help to be able to call the function from the spfx seamlessly, while keeping the function secured with Microsoft identity. (porting from a https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte, as requested)Solved121Views0likes1CommentClassic Site With Modern Libraries Not Templating To Modern Libraries
Users have one main site collection and create multiple sub sites using classic site template. Users converted libraries to modern experience in site used as template. After saving the site as template and creating new site using that template, we expected the new site would retain libraries modern experience and custom formatting settings but these settings/configurations are not templating over to new site. Wondering if somebody has similar experience and share any workarounds. Currently we are looking at either using script to modify the configuration or manually doing it after creating new site from classic site template. Any thoughts?Solved71Views0likes2CommentsUnable to Create a Rule on a Library with Contribute Permission
Hi the community, I tried to create a rule on a document library where I have Contribute permission. However, when I click on "Create a rule", I get a blank window. Strangely, with the same permission level on a list, it works as expected. Do you know if this is a known limitation? Do you have any workaround to suggest? Thanks in advance.Solved137Views0likes3CommentsSP Migration from On prem file share which was synced to Azure Files
Greetings we are migrating quite a few on prem file shares that have been backed up via Azure File Sync to Azure File shares for quite some time. The migration is going well, but the Azure File Sync had tiering in place due to the on prem servers being low on disk. So for one of the Migrations I am in the process of doing there are quite a few files that did not migrate because they have a status of ALOM and are sitting in Azure cold storage. Is there anyway to tell The SharePoint Migration tool to attempt to open the files which would pull them out of cold storage? Like I said I could issue a Hydrate command to pull them all back to the on prem file server but that server does not have enough free disk space fot this. I want to selectively do this for only some of the folders.Solved52Views1like2CommentsI can't publish content types with template from HUB anymore
We have a Content type HUB for our content types. There is 1 parent and many child content types. The template library is listed on the same HUB site. The templates are used in the content types. The existing URL is: /sites/contentTypeHub/Templates/[Name of the template].docx. Everything worked fine until I try to publish an update on 22 may 2025. The error: The operation failed on one or more Metadata web service application proxies: Taxonomy_HrstGnW7grNsmI2m437TvQ==. Please contact your administrator and check the log files for more error details. Content type publishing list error: If I try to publish the content type in 'classic SharePoint' I get an access request page. If I fill in this form, I get the acces request myself, because I am site owner. Accept this access request does not help to solve the problem. Detailed information: Publication with template = Error, access denied. Without template, I am able to publish the content type. (But we need the template) Use of managed metadata field: We use 4 term store sets. Permissions: I'm site collection admin and site owner of the HUB site. I'm Admin on the term store admin center. I'm site collection owner of the sites where the content types are published. I have full control on the HUB site and all libraries including the template library. Last successfully published date: 12 may 2025 (With template) Note: The templates are stored in the template library on the HUB site. They required version history. That's why we don't use the 'upload a template function'. But the function 'use an existing template'. Does anyone have any idea to solve this?Solved140Views0likes3Comments
Events
Recent Blogs
- 1. Capacity Scenario One of the most common scenarios for Microsoft Graph Data Connect (MGDC) for SharePoint is Capacity. This scenario focuses on identifying which sites and files are usin...Sep 05, 2025369Views2likes5Comments
- As the global dataverse of Microsoft 365 continues to grow in scale and importance, so does the threat of cyberattacks targeting this vital data. That’s why we’ve teamed up with Veeam on an upcoming ...Sep 04, 2025122Views0likes0Comments