New answers tagged

0

Alternative 1: Folder folder = web.GetFolderByServerRelativeUrl(web.ServerRelativeUrl + "/MyRecordLibrary/Folder1/"); clientContext.Load(folder); clientContext.ExecuteQuery(); CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = @"<View Scope='Recursive'> ...


1

We recommend that you use SharePoint Online OOB to implement your design. Please following steps: 1.Go to the source Document library as an admin >> Library settings >> (General Settings) Save document library as template 2.On the Save as Template page, please select "Include Content" option 3.When you click list template gallery, you ...


0

Usually if you set the default value, the default value will only be filled when adding a new item. For the previous item, I suggest you try to use json formating. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=...


0

See if the below solution meets your requirement. Add an app named File Uploader by Virto from SharePoint Store to your SharePoint site. Find it in Site Contents library and click it to run the app. Cpoy the url of upcoming page. Add a Button web part on your home page, edit the web part and paste the url you copied above into Link. Test on my end. ...


0

I had this issue, most of the solutions in the web did not work, but luckily, there was a hint in the error message which helped to resolve. It is to do with the Metadata/column. When I created a column of multiple options, I accidentally selected "Unique" value option as Yes. When I disable this, then it works as charm! Hope this helps! Thanks,


0

In a situation like this I would consider moving all files to a new library without ratings, then enable the ratings on the new library with a fresh start.


0

Do you mind getting the ID from the SharePoint UI instead of using PnP PowerShell? If no, you can show the OOB ID column in the view. If you have a nested folder structure, you can search on the top search box by the folder name and you can easily get the folder ID from UI.


0

As I am not sure about the type of "CQUniqueID", just assume it to be a number from its name. The most straightforward way will be like adding a new flow. Triggered when item is created/modified in the list. As you mention there is some kind of relationship between the item and file in library. If you can get the file ID from the list item, just ...


0

I ended up creating a ticket with Microsoft on the issue and per the 2 agents I spoke with, this is a new bug that many customers are reporting. They are currently working on a fix with no ETA. Super.


1

You can create a img control to show the file type icon using JSON formatting. You need to set the src property of img element based on [$File_x0020_Type]. In SharePoint online, default icon URLs are in below format: Example: Word document Icon URL: https://spoprod-a.akamaihd.net/files/fabric-cdn-prod_20201207.001//assets/item-types/20/docx.svg You can get ...


1

Try below solutions: Solution 1: Use CamlQuery.CreateAllFoldersQuery method in CSOM which will retrieve all folders in document library. Example: public static void GetAllFolders(List list) { var ctx = list.Context; var folderItems = list.GetItems(CamlQuery.CreateAllFoldersQuery()); ctx.Load(folderItems, icol => icol.Include(i => i.Folder));...


0

Solution1 Create a Calculated column: When the focument Title is Driver Captain, the value is CT0000DC; when the document Title is Driver Instructor, the value is CT0000DI. =IF(Title="Driver Capatain","CT0000DC",IF(Title="Driver Instructor","CT0000DI","")) Solution2: Create a MS Flow: When the document Title ...


0

We cannot use file name in calculated column formula. It's a known limitation of SharePoint. There is a SharePoint UserVoice for this. You can vote here: Use filename in calculated field Workaround: Create a new text field & populate its value using workflow/Power automate flow on item creation/update. Hide this field from property forms. Use workflow ...


0

so actually I had find the solution..i will get files (properties) --> put filter ----> get file content by path ---> create item with the file content .For me get file content by path worked .


0

It seems you are trying to modify file content via Power Automate. You can get file content via the action Get File Content. However if you are trying to modify the content, that is well supported in Power Automate. You can update the file content with the Update File action. However it is needed to provide the content in a format Power Automate can ...


0

There is no straight forward action using SharePoint connector to get the all files in a document library. You can find all available actions at SharePoint actions or SharePoint connector - Actions. But there are some workarounds to get the files in a particular folder or by using SharePoint REST APIs like below: Microsoft Flow – Retrieve All Files from ...


0

Maybe you have saved the default library view with the sorting. So, try this: Go to SharePoint document library where files are saved. Click on Switch view options at the top & select Edit current view. If you are not using SharePoint online, go to library settings & then select the default library view at the bottom. Set the sorting settings as ...


0

Create the Library with the short name you want the URL to be, then in the Library Settings you can change the Title of the Library. You can't change the Doc Lib URL post-creation.


1

Seems like you are passing wrong payload. Make sure you are passing correct server relative URL of your document library where you want to create a folder. You should pass the payload in below format: { "__metadata": { "type": "SP.Folder" }, "ServerRelativeUrl": "/document library relative url/folder ...


1

If you are trying to upload a file to SharePoint library & update it's item properties, use below code: import { sp } from "@pnp/sp"; sp.web.getFolderByServerRelativeUrl(newurl).files.add(file.name, file, true).then(f => { f.file.getItem().then(item => { item.update({ Title: "A Title", ...


1

It's a known limitation of SharePoint. We cannot use file name in calculated column formula. There is a SharePoint UserVoice for this. You can vote here: Use filename in calculated field Workaround: Create a new text field & populate its value using workflow on item creation/update. Hide this field from property forms. Use workflow to updated the Title ...


1

The Title field is not always automatically populated, and it is different than the filename which is displayed in the screenshot. To view the filename, title (and add more fields) you can edit the following script Get-PnPListItem -List "Documents" | %{Write-Host "$($_["FileLeafRef"]), $($_["Title"]), $($_.ID)"} There ...


1

No. Custom Script enabling is not required for using PnP PowerShell. It seems your documents don't have any value in Title field (Name field is different). Document properties in library: Output: Documentation: Get-PnPListItem


0

This is a default behavior of SharePoint. When you upload a new file with same name as existing file & replace the existing file, SharePoint will retain all the metadata/column values of existing file. SharePoint will not set blank values to columns automatically after replacing existing file/document.


0

This is absoultely standard behaviour. By adding a "new" document, you are not adding a new document, just a new version of the existing document, and you are only updating the content not the attributes of it. If you want to clear those values you need to write a flow to handle that.


0

Setting Recursive to Scope works fine for me. It shows all the files in folders & it's subfolders. You might want to check the filters if all expected files are not shown in library view. Possible values for Scope: FilesOnly — Show only the files of a specific folder. Recursive — Show all files of all folders. RecursiveAll — Show all files and all ...


1

Query text in highlighted content web part uses KQL. I don't think there is any way to enforce sorting within the Query text box. Workaround: Go to site collection settings --> Search Schema Search for managed property which starts with RefinableString You should be able to get the list pre-created refinable managed properties like RefinableString00, ...


2

You can use Highlighted content web part for your requirements like: Query text: contentclass:STS_List_DocumentLibrary Title:"cars-*" Output: Optional: Optionally you can set the layout & no. of items you want to show as per your requirements like:


0

I ran your code and it executes fine, therefore if you were using an ootb documents list, it should be ok, so I suspect you made some changes. The name you should be using in your query parameter, $Query = "<Where><Eq><FieldRef Name = 'Title' /><Value Type = 'Text'>Active</Value></Eq></Where>" Should match ...


2

Here is a workaround which may be easier to carry out. Select all items with the toggle selection. Click edit button, then you will be edit the column value in bulk. Note: This operation also has the list view threshold. So it may not work when you have over 5k items.


4

There is no direct way to remove all values vertically in particular column in Grid view. As a workaround, follow steps given below: Click on column cell in first row. Remove its value (Click Delete on keyboard directly or click again in cell & use "Backspace" to delete value). Select the small dot at the bottom right of column cell. Drag ...


Top 50 recent answers are included