Site page auto saves and creates multiple duplicates under site page library.
I have many subsite/site, issue is with one particular. When I try to choose a saved template to create a new page, page auto saves which creates multiple duplicates in site page library. When i click on save as draft It throws error box: Changes not saved We're sorry, we encountered an unexpected error. Please refresh the page and try again. This is happening when i choose saved templates only and under one specific subsite/site. Working by choosing blank template does not give any error. If i try to save as template from the blank page/template save as template option gives me same error as mentioned above. versioning is enabled under library setting server side publishing is also enabled. note: this is happening with specific subsite/site only and not in other subsite/site within.
Access rights to viewing a video in a Sharepoint Site
Hello, I created a SharePoint site and invited some of my colleagues (i.e. internal users) to the site. See image below. Even though this person is an internal user, he still has to request access to the video. Can you tell me why? The goal is for all users who have access to the Sharepoint site to not have to request permission to view videos. Thanks.
How to make URLs open in new tab in adaptive cards
We have created one Spfx adaptive card extension to use in Viva dashboard. We need to show some hyperlinks in the card. We have used the markdown language as shown below to show this. But the hyperlinks are opening in the same tab. { "type": "TextBlock", "text": "**[${Title}](${URL})**", "wrap": true } Also we tried using Action.OpenUrl as shown below. With this also the links are opening in the same tab. "actions": [ { "type": "Action.OpenUrl", "title": "View More", "url": "${URL}" } ] Is there way we can force the links in adaptive cards to open in new tab. Thanks.
JSON View Formatting - Count total number of items in SP list
Hi, I want to modify the groups footer of a custom view that is grouped by a metadata column named Response/Actionv2. In the Totals section of the view settings I enabled Count for this column, which now displays the number of items (rows) for each of the groups. However, I would like to use this number in the JSON formatting to calculate and display the proportion (in percentage %) of total number of decisions. As you can see in the code below, I've included the static number 31, but I'd like to be able to dynamically reference the total number of items in the list? Basically, do you have an idea on how to implement this formula: (@columnAggregate.value / TOTAL NUMBER OF ITEMS) * 100 { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "groupProps": { "hideFooter": false, "footerFormatter": { "elmType": "div", "children": [ { "elmType": "div", "attributes": { "iconName": "CalculatorPercentage" }, "style": { "color": "=if(@columnAggregate.type == 'Count' && @columnAggregate.value < 50, '#d13438', '#107c10')", "font-weight": "600", "margin-top": "10px" } }, { "elmType": "div", "style": { "color": "=if(@columnAggregate.type == 'Count' && @columnAggregate.value < 50, '#d13438', '#107c10')", "font-weight": "600", "margin-top": "10px", "font-family": "Segoe UI" }, "txtContent": { "operator": "*", "operands": [ 100, { "operator": "/", "operands": [ "@columnAggregate.value", 31 ] } ] } } ] } } }Changing choice fields choices dynamically in list form
I have a question about managing ticket status in Sharepoint list. 'New, In Progress, Pending, Resolved, Cancelled' values are defined as possible options for a Choice type field. How can I restrict the options of the same field based on the value the field contains? For example, when a user first creates a record, the status field has the value 'New'. When another user wants to change this record that has a 'New' value in the Status field, all 5 values listed above should appear as options. But if the saved record has 'Pending' value for example, only Resolved and Cancelled values should be listed as selectable values. If there is a Resolved value, there will be only Resolved option (So its value cannot be changed with a value other than 'Resolved'), if there is a Cancelled value, there will be only Cancelled option etc. Is it possible to dynamically change the field choices without diving into PowerApps and custom forms using JSON? Or any other way?
Sharepoint Online uses MS Editor for spell checking, gets errors with Swedish text
Hello, For a few weeks now, SharePoint Online has been using Microsoft Editor for spell checking. The SharePoint pages that were created with the basic language English then show errors in everything that is written in Swedish. I can not find a way to turn off the spelling checker or change it so that the spelling checker is in Swedish. Since it is not possible to change a SharePoint site from the language in which it was once installed, it must be possible to solve it in some other way. The sites that are installed with Swedish as the basic language work with MS Editor. How do I solve being able to write in Swedish on English SharePoint pages without all text being marked in red as misspelled? I have tried to install MS editor addon to Edge, and tried different settings without any progress.
Embedding Excel into Website requires login
Hello All, I am attempting to embed a file into our website, and am running into issues. I found another post here that seems to talk about PPT but this trick did not work for me. https://techcommunity.microsoft.com/t5/sharepoint/embedding-ppt-requires-sharepoint-login/m-p/265418 Maybe Matt Coats will see this below and have some other idea 🙂 Also this Microsoft post tells me to do something that doesnt seem available to me: https://support.microsoft.com/en-us/office/embed-files-directly-into-your-website-or-blog-ed07dd52-8bdb-431d-96a5-cbe8a80b7418 I created a link to an excel file where anyone can view it: https://troutvalleyassociation.sharepoint.com/:x:/s/TVAFileShare2/EbF7YhLzn2BGrLjwuk5ris8BP1TH99k62sEH8pKDEbwE9A?e=1qz1Oo This link works fine for anyone logged in or not logged in. But when I attempt to use this link as an embedded view it does not work without logging in <p></p> <div style="text-align: center;"> <p> <iframe width="1000" height="600" frameborder="0" scrolling="no" src="https://troutvalleyassociation.sharepoint.com/:x:/s/TVAFileShare2/EbF7YhLzn2BGrLjwuk5ris8BP1TH99k62sEH8pKDEbwE9A?e=1qz1Oo&action=embedview&wdHideSheetTabs=True&wdHideHeaders=True&wdDownloadButton=False&ActiveCell=A2"></iframe> </p> </div> <p></p> here is a page it is embedded on: https://www.troutvalleyil.com/test.html I can access the excel file without any issues If I use my browser that is logged into O365 then the web page works But when anyone who is not logged into O365 attempts to access this web page it does not work for them Any thoughts / ideas / suggestions?SharePoint Online: DocID link downloads documents (.msg only) instead of opening it in client app
When the DocId feature is enabled the link looks like this: https://intranet.company.local/sites/test/_layouts/15/DocIdRedir.aspx?ID=H5QDD2XCJXV4-1303922799-9727. When I click on the link for .msg file, it downloads the document, the expected behavior is, it should open the document. The .pdf file works as expected. Is there any specific settings for this?
SPOL Calculated Column Formula Help - Working Days
Hi, I’m trying to find the solution to 2 calculated column requirements. I have searched quite extensively and have only found partial, or partially working answers. The two requirements are: Work out the number of working days between a query being received and acknowledged, and based on that number set a text line to “met” if 2 days or less or “not met” if over 2 days. Based on the status of another column, working out the number of working days between either the date a query was received and closed, or if it is not closed, the number of working days between the date it was received and TODAY. I am UK based and weekend days are Saturday and Sunday. On 1, I’ve been playing with a formula like this, but it doesn’t seem to work consistently over weekends. Some seem to calculate correctly, and others don’t. So if a query is received Friday and closed Monday, it gives me 2 days on some (correct) and 4 on others. https://social.technet.microsoft.com/Forums/lync/en-US/2c450b0a-4e7b-41f5-88bf-42a43fb34d8b/networkdays-in-sharepoint-calculated-column?forum=sharepointgenerallegacy I haven’t found anything on 2. My columns are: Date received | Date acknowledged | Date closed | Status In “Status” I have two closed status of “Closed” and “Closed Transferred” along with 3 classed as open which are “Open”, “Pending Info” and “Tracking Only” Examples for 1 Date received - 1 March 2022 Date acknowledged - 2 March 2022 Output - “Met” (2 working days so SLA met) Date received - 1 March 2022 Date acknowledged - 4 March 2022 Output - “Not Met” (4 working days so SLA not met) Date received - 4 March 2022 Date acknowledged - 7 March 2022 Output - “Met” (2 working days as weekend days excluded so SLA met) Examples for 2 Date received - 1 March 2022 Status - Closed Date closed - 3 March 2022 Output - 3 Days (as status is closed, date closed - date received in working days) Date received - 1 March 2022 Status - Pending Info Date closed - BLANK (Assume today is 4 March 2022) Output - 4 Days (as status is pending info, TODAY - date received in working days) Date received - 4 March 2022 Status - Closed Date closed - 8 March 2022 Output - 3 Days (as status is closed, date closed - date received in working days and weekend days are excluded) I hope the question is appropriate. I have all these working in excel using NETWORKDAYS but am no familiar with the syntax for SPOL. So I really would appreciate any help or information at all. Thank you very much in advance for any help!
