Category: Content Management | Microsoft Community Hub

Recent Discussions

How to filter document library web part by a page property column
Dear community members, i am looking for a way to filter my document library web parts inside a sharepoint page by a column that i have added to the page properties. I have tried to add the that has this column as a webpart list and filter against it, and this working fine but i dont want to filter this way. The idea is to create a page for each project in my main list and filter the document library webparts inside of it automatically. is this a possible solution? And if not feasible via page properties, is there any other solutions for this? Thank you in advance for anyone who could help in this. Ali
Solved
Aalghoul
Copper Contributor
Oct 08, 2025 Place SharePoint
Document Library
Lists
86Views
0likes
2Comments
Why Is SharePoint’s Priority Column Free Text and Not a Choice Field?
While https://bluesite.consulting/en-us/articles/sharepoint-site-template-projecthome-review.html, I noticed something unusual in the work action tracker list—a column setting that seemed out of place. Specifically, the Priority column isn't set up as a typical choice column with selectable options. Instead, the available choices are entered as free text in a single text field (left image) I saw this years ago in the old SharePoint. where options for a choice column are defined within a text field rather than as a standard list of choices (right image). Does anyone know why this might be happening or what could be causing this behavior?
Solved
Dennis-Scherrer
Brass Contributor
Oct 08, 2025 Place SharePoint
Lists
microsoft lists
SharePoint Online
52Views
0likes
3Comments
SharePoint pages - multiple folders
Hello. Is it possible to store SP pages in different libraries and/or document folders? I have created several pages in my SP site and rather than having to wade through a long list of pages, I would like to organise them in folders with different names. Is this possible?
Solved
JTG99
Copper Contributor
Sep 24, 2025 Place SharePoint
Document Library
files
Microsoft365
SharePoint Online
103Views
0likes
3Comments
Sorting a SharePoint List alphabetically it Swedish
Hi! I'm working on a ShrePoint site for my organisation and have run into an issue with a SharePoint list. The entire site is in Swedish and I've run inte issues when Grouping/Sorting. In the list i have a column (lets call it "Letter") that uses a formula =LEFT(Title) to extract the first letter from the Title of each list item for the purpose of being able to group by letter. So the list is first grouped by "Letter" and the Sorted alphabetically by "Title". The issue is how SharePoint handles "alphabetical order" of the Swedish alphabet. The Swedish alphabet is the same as English, but with 3 additional letters, "Å", "Ä" and "Ö". While they could be considered A's and O's with diacritics, in Swedish they are considered their own letters. And alphabetically they come after Z. I want my list sorted "A, B, C, ... X, Y, Z, Å, Ä, Ö", but SharePoint sometimes sorts it "A, Ä, Å, B, ... N, O, Ö, P, Q, ..., X, Y, Z" The strange thing, however, is that this problem only arises when i load the list on a SharePoint page as a Web part. So in short: Problem only occurs when grouping or sorting the column "Letter", and i only occurs when using the list in a web part. Has anyone run into anything similar? I've looked thourgh all the setting i can access for both the site and the list. All Language settings are set to Swedish as well.
Solved
PerA
Copper Contributor
Sep 19, 2025 Place SharePoint
Lists
SharePoint Online
61Views
0likes
2Comments
Recommendations for SharePoint Accessibility Training
Hello everyone, I'm looking for recommendations for good accessibility training courses or resources that are specifically focused on SharePoint. My team wants to ensure our sites are as accessible and inclusive as possible. Has anyone taken a course or used a particular resource that they found valuable? We are open to any format (e.g., online courses, workshops, documentation, etc.). Any suggestions would be greatly appreciated! Thank you.
Solved
Ebru
Copper Contributor
Sep 19, 2025 Place SharePoint
accessibility
sharepoint embedded
Sites
55Views
0likes
1Comment
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.
Solved
MasPAN74
Brass Contributor
Sep 03, 2025 Place SharePoint
sharepoint server
50Views
0likes
1Comment
How 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.
Solved
MasPAN74
Brass Contributor
Sep 03, 2025 Place SharePoint
2016
75Views
0likes
2Comments
How 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?
Solved
mhasfia
Copper Contributor
Aug 25, 2025 Place SharePoint
App
developer
microsoft lists
Microsoft365
SharePoint Online
156Views
0likes
4Comments
Date field shows one day earlier in SharePoint document preview (Word Online)
Hi everyone, we’re experiencing an issue with custom date field in SharePoint Online when previewing Word documents in the browser. Context Displayed Position Word Desktop (opened locally 28.07.2025 left SharePoint Preview (Word Online) 27.07.2025 middle SharePoint library (column view) 28.07.2025 right Additional details: Both the site and user profile time zones are set to: (UTC+02:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna. The issue affects multiple documents and users. The moment the document is opened locally in Word Desktop, the date is displayed correctly again. Thanks in advance for any insights or guidance!
Solved
ibmtomatoe
Copper Contributor
Aug 22, 2025 Place SharePoint
Document Library
SharePoint Online
65Views
0likes
1Comment
Calculated 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!
Solved
CoachChris1984
Copper Contributor
Aug 21, 2025 Place SharePoint
microsoft lists
SharePoint Online
65Views
0likes
2Comments
How 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 column
Solved
Sandra Tibbs
Copper Contributor
Aug 18, 2025 Place SharePoint
Document Library
Lists
SharePoint Online
109Views
0likes
3Comments
Create 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?
Solved
AndrewCrompton
Copper Contributor
Aug 14, 2025 Place SharePoint
microsoft lists
67Views
0likes
2Comments
Automated 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.
Solved
W_AT_H
Copper Contributor
Aug 14, 2025 Place SharePoint
SharePoint Online
98Views
0likes
3Comments
Multiple Lines Using Power App
Hello, Likely a simple one I have designed a form in power apps for my sharepoint list but when it comes to entering information into the multiple lines field, it just types and types as one line and unable to tab\enter to a new line
Solved
Dazza2025
Copper Contributor
Aug 12, 2025 Place SharePoint
SharePoint Online
138Views
0likes
3Comments
Issue 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?
Solved
Kanchana112
Copper Contributor
Aug 10, 2025 Place SharePoint
admin
Document Library
files
Microsoft365
Permissions
102Views
0likes
2Comments
can 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?
Solved
catereilly
Copper Contributor
Aug 01, 2025 Place SharePoint
powershell
SharePoint Online
158Views
0likes
4Comments
Find 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!
Solved
RMDUser1
Brass Contributor
Jul 30, 2025 Place SharePoint
admin
developer
Lists
microsoft lists
powershell
232Views
0likes
3Comments
Created 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 you
Solved
Ann_DAS
Copper Contributor
Jul 29, 2025 Place SharePoint
SharePoint Online
555Views
0likes
2Comments
JSON 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" } } ] }
Solved
kellyhickman14096
Brass Contributor
Jul 24, 2025 Place SharePoint
SharePoint Online
125Views
0likes
2Comments
Can 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!
Solved
AS400
Copper Contributor
Jul 24, 2025 Place SharePoint
admin
Permissions
security
SharePoint Online
208Views
0likes
1Comment

Recent Discussions

How to filter document library web part by a page property column

Why Is SharePoint’s Priority Column Free Text and Not a Choice Field?

SharePoint pages - multiple folders

Sorting a SharePoint List alphabetically it Swedish

Recommendations for SharePoint Accessibility Training

How to perform Windows Update for SharePoint 2019 DB Cluster

How to perform Windows Update for Exchange 2016 DAG Cluster

How to get Calculated Column Microsoft List appear in Power AutomateSharepoint Dynamic Content

Date field shows one day earlier in SharePoint document preview (Word Online)

Calculated Column Exctract text between characters

How can we use SharePoint list to fill a Choice Column

Create SPO list from csv with schema with calculated columns

Automated Lists numbering in PowerAutomate

Multiple Lines Using Power App

Issue with Sub Folder Permission Inheritance Not Breaking Properly

can PnpOnline script move files to a different library and retain same created and modified dates?

Find all columns internal names in SharePoint list

Created By column on a SharePoint list picking up wrong info

JSON in hyperlink formatted column

Can default permission groups be restored in SharePoint Online? (Owners, Members, Visitors)

Events

Recent Blogs

MGDC for SharePoint FAQ: Which dates to use for the Files dataset?

SharePoint Showcase: Governance and Security Essentials for Admins in the AI Era

Resources

Tags