3
votes
Accepted
Power Automate - Action 'Get_tables' failed
As you are deleting excel file and recreating it daily, there might be issue related to file identifier when you are selecting file from file picker in "Get tables" action.
Instead of above ...
- 42.9k
3
votes
Accepted
Specific custom made SharePoint permissions to read only and save as a copy online
Unfortunately, Save as - Save a copy online option is available only if you have Edit permissions on the files (default behavior in SharePoint).
Workaround:
If you want to allow users to create a ...
- 42.9k
2
votes
Accepted
open pdf files in acrobat reader from sharepoint online
At this stage I have not found a way to open PDF files directly in Adobe Reader, however Microsoft have recently announced that the Edge Browser will start using Adobe Acrobat PDF engine soon.
To ...
- 945
2
votes
Get all the document excluding Document sets using REST API In SharePoint
You can get items from document library except document sets using SharePoint REST endpoint like below:
https://contoso.sharepoint.com/sites/SPConnect/_api/web/lists/getbytitle('DocumentSets')/items?$...
- 42.9k
2
votes
Get all the Document set title in the library using REST API in SharePoint
Use REST endpoint like below:
https://contoso.sharepoint.com/sites/SPConnect/_api/web/lists/getbytitle('DocumentSets')/items?$select=Title
Where DocumentSets is the name of your document library.
...
- 42.9k
2
votes
Can we depend on Metadata and eliminate folders ? will this work for large document libraries
It is true that using metadata to organize and filter large amounts of content in a SharePoint document library can have some limitations, such as the 5,000 item limit for views and the 100,000 item ...
- 9,572
2
votes
Accepted
Document Library Web Part size reseting to Medium size
I just tried testing this on our SharePoint online site and I am able to reproduce this issue related to document library web part on modern experience site pages.
When I am selecting Autosize - fit ...
- 42.9k
2
votes
Accepted
Can we allow users to rename files but prevent them from deleting those files inside SharePoint online
Unfortunately, this is a default behavior in SharePoint. You need Delete permissions on items/files if you want to rename those.
This behavior corresponds to user's experience on Windows file servers ...
- 42.9k
2
votes
Accepted
Inheriting metadata upward?
Upward metadata inheritance is not possible automatically using the SharePoint Online out of the box features.
Here are few options you can try:
Update folder metadata manually:
You cannot update the ...
- 42.9k
2
votes
Accepted
Break role inheritance for a specific folder
You have to use the Set-PnPFolderPermission PnP PowerShell command instead of Set-PnPListItemPermission.
Example:
Set-PnPFolderPermission -List 'Shared Documents' -Identity 'Shared Documents/Folder' -...
- 42.9k
2
votes
Accepted
SharePoint check in error
The moment you have required properties, the checkin mechanism will start to kick in.
You can upload a document but if the required property is not filled-in, it will be uploaded as a checkedout draft ...
- 5,457
1
vote
Can we define a default value for the number of major versions inside our SharePoint libraries for new and existing libraries
To new libraries: No
To existing libraries: Make an automated powershell script that iterates over all of your existing libraries and makes sure that the number of versions matches the one you want.
...
- 176
1
vote
how to insert file in library and insert data from that file in sharepoint online in SPFX react
Here is a sample code snippet that demonstrates how to upload a file to a library and insert data from that file in SharePoint Online using SPFX React and File Upload API:
import { sp } from "@...
- 2,299
1
vote
Accepted
Modern pages: impossible to set as default view anything else than grouped by author?
Follow below steps to set the All Pages view as default view in Site pages library:
Go to site pages library
Switch to "All Pages" view using drop down from top right corner
Select Set ...
- 42.9k
1
vote
SharePoint 2013 : Get-PnPFile: No digest found!
PnP PowerShell is officially not supported for being used in an on-premises context.
As per the PnP PowerShell documentation:
Connect-PnPOnline -Url "https://portal.contoso.com" -...
- 42.9k
1
vote
Accepted
Getting the URL from a Link file (.url file) on JSON Column Formatting?
Yes, it is possible to get the URL from a Link file (.url file) using JSON Column Formatting.
You can get it using this property: [$_ShortcutUrl]. This is an internal name of field which stores the ...
- 42.9k
1
vote
Flow for copying attachments from SharePoint Online List to SharePoint Online Library not working
Yes, use the Get attachment content and Create file instead of Copy file.
Here is a sample flow below:
- 286
1
vote
Power Automate - Workflow to update properties of new file only
Recommended solution:
If you want to run the flow and update date column only when a new file is created, you should use When a file is created (properties only) trigger in Power automate flow.
If ...
- 42.9k
1
vote
Accepted
SP Online Library conditional data selection
There are two ways to achieve this requirements in SharePoint online.
Using JSON formatting (as you tagged your question with json-formatting tag):
You can build cascading drop down fields using ...
- 42.9k
1
vote
Retrieving files from sharepoint returns empty value array
I had the same issue when I used "siteAbsoluteUrl".
let siteUrl = _spPageContextInfo.siteAbsoluteUrl;
let url = siteUrl + "/_api/web/getFolderByServerRelativeUrl('<relative path to ...
- 21
1
vote
Accepted
How to hide columns of subfolders inside a library?
It's not possible in Folder in SP Library. However, you can use Document Sets instead of folders. You can create content types for Document Sets and you can add/edit columns as per your need
- 369
1
vote
Accepted
Customizing PnP Search results
You need to create managed properties for your column from SharePoint Admin Center. You can follow steps from below link:
https://sharepointmaven.com/how-to-create-a-managed-property-in-sharepoint-...
- 2,180
1
vote
Accepted
Unable to get the file which have '.lock' extension inside PnP PowerShell script
Try below code to fetch .lock extension file:
$LibraryName = "Documents"
$LibraryItems = Get-PnPListItem -List $LibraryName -PageSize 500 -Fields "FileLeafRef" | Where {$_....
- 1,463
1
vote
Accepted
SharePoint Online - Can we restrict a user from copying files/documents?
I think this is not possible using SharePoint permissions as you want to allow users to move files but not copying the files.
For moving files from document library, you need Contribute or higher ...
- 42.9k
1
vote
Accepted
How document's metadata/property sync behaves - SPO To MS Office Files (Word, Excel, PPT) and MS Office Files (Word, Excel, PPT) to SPO
Default / OOTB behavior of SharePoint Document’s Metadata Sync / Document Parser
Sync is enabled by default in every SharePoint library. Document
metadata sync is bi-directional (SharePoint Online to ...
- 369
1
vote
Accepted
SharePoint 2013 REST API Methods to Get File Names from Folders
You can use SharePoint REST API endpoint in below format to get the files from specific folder inside document library:
https://contoso.sharepoint.com/sites/SPConnect/_api/web/...
- 42.9k
1
vote
SharePoint 2013 REST API Methods to Get File Names from Folders
You need to provide the "Folder URL" which is a server relative path of a folder. Let's say you need the file names from "Folder1" folder of "ABCLibrary" document library....
- 1,463
1
vote
"Sorry, your files couldn't be uploaded. The upload might be too large or the server might be experiencing high network traffic." uploading large file
Saw the same error across multiple sites but not in our lower environments. On a hunch, reached out to network team before opening a Microsoft ticket.
We narrowed down the cause to be a network load ...
- 21
1
vote
open pdf files in acrobat reader from sharepoint online
I would recommend that users use the "Sync" button in the document library so that they can access the library from Windows Explorer via the OneDrive for Business desktop app. By accessing ...
- 3,760
1
vote
SharePoint Test Site
You can either create a SharePoint site in your tenant for testing purposes or you could apply for the Microsoft 365 developer program which would give you a developer tenant where you can test:
...
- 3,760
Only top scored, non community-wiki answers of a minimum length are eligible