Forum Widgets
Latest Discussions
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?SolvedJTG99Sep 24, 2025Copper Contributor79Views0likes3Comments
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.SolvedPerASep 19, 2025Copper Contributor48Views0likes2Comments
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.SolvedMasPAN74Sep 03, 2025Brass Contributor46Views0likes1CommentHow 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.SolvedMasPAN74Sep 03, 2025Brass Contributor66Views0likes2CommentsHow 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?Solved136Views0likes4CommentsDate 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!SolvedibmtomatoeAug 22, 2025Copper Contributor57Views0likes1Comment
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!SolvedCoachChris1984Aug 21, 2025Copper Contributor64Views0likes2CommentsHow 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 columnSolvedSandra TibbsAug 18, 2025Copper Contributor103Views0likes3Comments
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?SolvedAndrewCromptonAug 14, 2025Copper Contributor63Views0likes2CommentsAutomated 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.SolvedW_AT_HAug 14, 2025Copper Contributor96Views0likes3Comments
Resources
Tags
- SharePoint Online18,107 Topics
- Document Library3,169 Topics
- Lists3,090 Topics
- Sites2,554 Topics
- admin2,225 Topics
- sharepoint server2,022 Topics
- Permissions1,962 Topics
- files1,689 Topics
- developer1,586 Topics
- microsoft lists1,538 Topics