User Profile
SteveKnutson
MVP
Joined Mar 10, 2017
User Widgets
Recent Discussions
Re: Attachments and approvals
If you configure different content types, then could include a link to a form for the second approval (assuming these are sequential approvals e.g. separate actions). You can make the List Form open with a content type that includes just the fields you need e.g. attachments and any other additional info using a URL like this: https://<site-url>/_layouts/15/EditForm.aspx?List=<List-ID>&ID=<Item-ID>&ContentTypeId=<Content-Type-ID>Sharing Links - People with Existing Access Defaults to View Access
Hi there, I have noticed in SharePoint that when I set the default Sharing Link type to "People with Existing Access", links default to View even when the policy specifies Edit links. There doesn't seem to be anyway to create an Edit link by default. Generates a View Link The problem occurs in Office 365 Group based sites and Communication sites. I have confirmed the behavior in multiple Tenants. For other Link types, the Edit option does work. Am I missing something here?Re: Linking Contents from SharePoint List to an Existing Excel Sheet
You can't reference a SharePoint List from an Excel lookup, but you can use Power Automate to update Excel and could trigger this when an item is created or updated in the SharePoint List. https://sharepains.com/2020/06/08/super-fast-update-excel-using-power-automate/Re: Check-in/ check out when creating a new doc in a team site
Check the version settings as follows: - Go to the Document Library - Click the Cog icon (top right of the page) - Choose Library Settings - Versioning settings - Check the Check In / Out options This can also happen if you have a required metadata field in the Document Library. If the metadata is not filled in, it will cause the document to automatically check out.Re: Use calculated column to perform calculation on the "Name" column in a SharePoint library
There are some string functions that can extract parts of a string. If the different sets of characters are the same length, then you could use LEFT and RIGHT functions. Here is a reference guide: https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3 The alternative approach is to use a Power Automate Workflow to split the name into the parts and update the metadata fields.Re: Having SharePoint Search Bar search a specific site
Two things you could try Adding a custom Search Vertical https://learn.microsoft.com/en-us/MicrosoftSearch/manage-verticals Using PnP Modern Search webparts to create a custom search page and specifying the sites in the query filter. https://searchexplained.com/pnp-modern-search/Re: Windows service on local server needs to consume files from SharePoint folder
There is an option of using WebDav to map a drive, however this is old technology, and the session will timeout. https://learn.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/troubleshoot-mapped-network-drives Power Automate or PowerShell (https://pnp.github.io/powershell/cmdlets/Get-PnPFile.html) can be used to copy files down to the File Server.Re: Instructions on configuring a customized Search Page in SharePoint
Hi Kim, Microsoft doesn't provide customizable search webparts for modern pages. You can still use the classic webparts, but this is only available for classic pages. Here is some detail on the API's used by PnP Search that may help answer the security concerns. https://github.com/microsoft-search/pnp-modern-search/discussions/2381 The source code is also available to review. I have worked with several companies who have reviewed the source code before approving the use of PnP Search. https://github.com/microsoft-search/pnp-modern-search I hope this helps.Re: Access to Excel spreadsheet error
Hi Chris, Can the user see the file if they browse the document library in the web browser? If they can't see the file, it could be checked out. There is a file URL length limit of 400 characters when opening in the browser. It can be less if the file is opened from the desktop app.Re: Sync comment in two list
For question 1, do you mean List comments or is this a field in the List itself? If it is a column, then copying with a Workflow is possible. You can access List comments using the Rest API. You could use Power Automate to call the API and copy the values. SharePoint Online: All you need to know about Commenting in Lists – Ganesh Sanap Blogs (wordpress.com) Question 2. If the user is view only, then they cannot update the item or make comments.
