Articles about European Sharepoint Hosting Service
Other Related Post
SharePoint 2013 Hosting – HostForLIFE.eu :: Format The SharePoint Modern Site List Form Using JSON Formatting
Mar 3rd
We can configure the SharePoint modern site list form using JSON formatting, which has the following use cases:
- If you want to implement multiple column forms rather than existing single column look and feel
- If you want to hide and show field/column-based forms in a simple and easy way
- If you don’t have Power App license but still want to change some look and feel of list forms
- If you want to group the fields/columns in the list form
Steps to use JSON formatting to change the form look and feel follows the below steps:
- Open the New form of list
- See the form is showing only one column view
- Click on the highlighted icon and choose the below option
- The below screen will appear, It will shows a dropdown with three options namely
- Header
- Body
- Footer
- Copy the JSON and paste in the field for header
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556{"debugMode": true,"elmType": "div","attributes": {"class": "ms-borderColor-neutralTertiary"},"style": {"width": "99%","border-top-width": "0px","border-bottom-width": "1px","border-left-width": "0px","border-right-width": "0px","border-style": "solid","margin-bottom": "16px","background-color": "#026d70"},"children": [{"elmType": "div","style": {"display": "flex","box-sizing": "border-box","align-items": "center"},"children": [{"elmType": "div","attributes": {"iconName": "Group",-Use icon as per your requirement "class": "ms-fontSize-42 ms-fontWeight-regular ms-fontColor-white","title": "Details"},"style": {"flex": "none","padding": "0px","padding-left": "5px","height": "36px"}}]}, {"elmType": "div","attributes": {"class": "ms-fontColor-neutralSecondary ms-fontWeight-bold ms-fontSize-24"},"style": {"box-sizing": "border-box","width": "100%","text-align": "left","padding": "21px 12px","overflow": "hidden","color": "white"},"children": [{"elmType": "div","txtContent": "New Form" - This is the Form Title}]}]}
The above JSON is self-explanatory, which has three div.’s, first div is for main container div for header and next two for below…
-
- For Icon
- For Title
Click on preview button to see the applied JSON configuration to header.
- For Body, copy and paste the below JSON, choose Body from dropdown first
Here in the above JSON, Section is used to divide the fields in multi column views. Use the column display name to put that column section if any field not mention the section then that field/column will automatically display in the last section.You can see the JSON is self-explanatory so you can add any number of sections here in the JSON.
- For Footer copy and pasting below JSON, buttons will not be associated with any part; i.e. it is not associated with Header, Body or Footer section.
1234567891011121314151617181920{"debugMode": true,"elmType": "div","style": {"width": "100%","text-align": "left","overflow": "hidden","border-top-width": "1px"},"children": [{"elmType": "div","style": {"width": "100%","margin-top": "20px","margin-bottom": "10px","height": "4px","background-color": "#026d70"}}]}
The above JSON is just to add some border margin below the body, and you can refer the header JSON to add div children in this section if you want. Just complete all these steps and your list form will look better than the default list form, just click on Save button as highlighted in the below screen.
This formatting will apply to all three forms of SharePoint list form.
For more information please visit the Microsoft site.
SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Search Script in SharePoint 2013?
Jan 22nd
This article will explain the PowerShell script that searches for files within document libraries in SharePoint (farm level, site collection level, web level etc.) based on the search parameters you provide. It can also be used for searching in SharePoint for any files with specified extension. The results are returned in .CSV format.
Examples of scenarios
Search the entire farm for files that have names like “Training Copy”.
Search the site collection http://sharepoint.mydreambox.com/sites/site1 for all PDF files, RDL files, etc.
Search the web http://sharepoint.mydreambox.com/sites/site1/web1 for the file named “AXL8rt.docx”, etc.
Usage of the Script
Replace the $webApp, $sites, etc. with appropriate values
Replace the $searchKey with the desired search queries or file extension that is to be searched for
Make sure the account that is running these scripts have necessary privileges in SharePoint
Script use cases
The code is presented for four different cases,
Searching for an entire farm
Searching within a web application
Searching within a site collection
Searching within a web
Output
The output will be in the form of a CSV file, as displayed below. It will contain all the file location URLs.
Case I – For searching within the entire farm
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } $sites = Get-SPSite -Limit All $searchKey = ".rdl" $results = @() foreach ($site in $sites) { foreach ($web in $site.AllWebs) { Write-Host Searching within $web.Url foreach ($list in $web.Lists) { if($list.BaseType -eq "DocumentLibrary") { foreach($item in $list.Items) { if($item.Name.Contains($searchKey)) { $RowDetails = @{ “File Location” = $web.Url + "/" + $item.Url } $results += New-Object PSObject –Property $RowDetails } } } } } } $results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation Case II - For searching within a Web Application if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } $webApp = "http://sharepoint.dreambox.com" $sites = Get-SPSite -WebApplication $webApp -Limit All $searchKey = "Self Improvement" $results = @() foreach ($site in $sites) { foreach ($web in $site.AllWebs) { Write-Host Searching within $web.Url foreach ($list in $web.Lists) { if($list.BaseType -eq "DocumentLibrary") { foreach($item in $list.Items) { if($item.Name.Contains($searchKey)) { $RowDetails = @{ “File Location” = $web.Url + "/" + $item.Url } $results += New-Object PSObject –Property $RowDetails } } } } } } $results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation |
Case III – For searching within a Site Collection
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } $site = Get-SPSite “http://sharepoint.dreambox.com/sites/site1” $searchKey = ".docx" $results = @() foreach ($web in $site.AllWebs) { Write-Host Searching within $web.Url foreach ($list in $web.Lists) { if($list.BaseType -eq "DocumentLibrary") { foreach($item in $list.Items) { if($item.Name.Contains($searchKey)) { $RowDetails = @{ “File Location” = $web.Url + "/" + $item.Url } $results += New-Object PSObject –Property $RowDetails } } } } } $results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation |
Case IV – For searching within a Web
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } $web = Get-SPWeb “http://sharepoint.dreambox.com/sites/site1/web1” $searchKey = ".pdf" $results = @() foreach ($list in $web.Lists) { if($list.BaseType -eq "DocumentLibrary") { foreach($item in $list.Items) { if($item.Name.Contains($searchKey)) { $RowDetails = @{ “File Location” = $web.Url + "/" + $item.Url } $results += New-Object PSObject –Property $RowDetails } } } } $results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation |
SharePoint 2013 Hosting – HostForLIFE :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?
Jan 7th
In this blog, we are going to learn how to copy the attachments from a single list item to SharePoint library using PnP PowerShell. The following snippet helps, you to get the attachments from a list item and uploads to the shared Documents library in a current context site.
|
1 2 3 4 5 6 7 |
$cred = Get-Credential Connect-PnPOnline -Url https://ktskumartenant.sharepoint.com/sites/dev -Credential $cred $listitem = Get-PnPListItem -List Employee -Id 2 $attachments = ForEach-Object{Get-PnPProperty -ClientObject $listitem -Property "AttachmentFiles"} $attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl –TargetUrl “Shared Documents/$($_.FileName)” |
After running the powershell command, it asks us to confirm the sourceurl and target url. If the file already exists in the targeturl, we have to add -OverwriteIfAlreadyExists $true to avoid the file already exists error.
Below is the example copies the two attachments from the single list item to the folder within a SharePoint library.
SharePoint Hosting – Change SharePoint Online List Or Library Internal Name
Dec 17th
Recently we have provided a build and guideline document to our client and by mistake they have set up a library with the wrong internal name. In the beginning it worked well but as the additional functionality was added, it broke. As the users have started working on that, we needed to fix the internal name anyway.
Our library internal name is “TrainingDocuments” and display name is “Training Documents”. While Client has set up “Training Documents”
Solution
Initially we thought it might be not possible. But then we found 2 ways to do it,
Approach 1 – Using SharePoint Designer 2013
Follow the below steps to fix this using SharePoint Designer 2013,
- In SharePoint Designer, Open your site.
- Navigate to All Files navigation node (not List and Libraries node),
Note
you will need “Site Collection Administrator” permission in the site collection to see “All Files” option. - Find your list there
- Right-click list
- Rename.
Approach 2 – Using PNP PowerShell
In case you are not able to connect the site in the SharePoint designer or you do not have it installed in your machine, you can do this using PNP PowerShell as well.
PowerShell to change Library Name,
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
#Set Parameters $<span class="attribute">SiteURL</span> = <span class="attribute-value">"Site URL"</span> $<span class="attribute">ListName</span> = <span class="attribute-value">"Library Internal Name"</span> $<span class="attribute">NewListURL</span> = <span class="attribute-value">"New Library Name"</span> #Connect to PNP Online Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential) #this will change URL #Get the List $<span class="attribute">List</span>= <span class="attribute-value">Get</span>-PnPList -Identity $ListName -Includes RootFolder #sharepoint online powershell change list url $List.Rootfolder.MoveTo($NewListURL) Invoke-PnPQuery #this will change library title Set-PnPList -Identity $ListName -Title $NewListURL |
PowerShell to change List Name
For list, we don’t need to execute command for root folder changes. So, the updated powershell is as follows:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
#Set Parameters $<span class="attribute">SiteURL</span> = <span class="attribute-value">"Site URL"</span> $<span class="attribute">ListName</span> = <span class="attribute-value">"Library Internal Name"</span> $<span class="attribute">NewListURL</span> = <span class="attribute-value">"New Library Name"</span> #Connect to PNP Online Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential) Set-PnPList -Identity $ListName -Title $NewListURL |
SharePoint Hosting – Delete A List In SharePoint Online Using PnP Powershell
Aug 6th
Today, we’ll look at deleting a SharePoint List in Office 365 using PowerShell PnP. First we need to connect the SharePoint Online site using the below command,
Step 1
Open SharePoint Management Shell as an Administrator in your machine.
Step 2
Run the following command to import PnP to install the PowerShell cmdlets,
|
1 |
Install-Module SharePointPnPPowerShellOnline |
Step 3
To use the library you first need to connect to your tenant using the below cmdlets.
|
1 |
connect-PnPOnline –Url https://fortunestrikes.sharepoint.com –Credentials (Get-Credential) |
Syntax – https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/remove-pnplist?view=sharepoint-ps
|
1 2 3 4 5 6 |
Remove-PnPList -Identity <ListPipeBind> [-Recycle [<SwitchParameter>]] [-Force [<SwitchParameter>]] [-Web <WebPipeBind>] [-Connection <PnPConnection>] |
Syntax – Remove List item
|
1 2 3 4 5 6 7 |
Remove-PnPListItem -List <ListPipeBind> -Identity <ListItemPipeBind> [-Recycle [<SwitchParameter>]] [-Force [<SwitchParameter>]] [-Web <WebPipeBind>] [-Connection <PnPConnection>] |
Now that we’re logged into the site collection, let’s create our List/document library.
Remove List/ document library
|
1 |
Remove-PnPList -Identity DemoList |
Remove-Pn
|
1 |
Remove-PnPListItem -List "Demo List" -Identity "5" -Force |
Thanks for reading my blog.
SharePoint Hosting – Resolving The “Out Of Date Nintex Forms” Error In SharePoint Online
Jul 16th
Now, I will tell you about how to Resolving The “Out Of Date Nintex Forms” Error In SharePoint Online. While working with Nintex Form for Office 365, you may get this error. Thus, let’s learn all the possible solutions for this error. I have customized my SharePoint Online custom list add Form, using Nintex Forms for Office 365. It worked perfectly. Subsequently, I thought of adding some validations, using JavaScript code. Hence, I followed the steps given below.
– Click on Form Setting on Nintex Form designer screen.
– Under Custom JavaScript option, I simply wrote alert (‘Hello’).
– Subsequently, I published the form.
– Now, when I try to add a new item in my custom list, it opens Nintex Form and I get the error given below.
Once I clicked on OK, the list form closed and default list view was displayed.
Hence, I thought that maybe my Nintex Form for Office 365 app was outdated. I searched how to update Nintex Forms for Office 365 app. I found so many links but I found that my Nintex Form is up to date.
Thus, it gave me trouble. I kept on searching. Finally, I found the solution. When I found the solution, I was really disappointed with Nintex Forms error message, as it is misleading.
The problem was with my JavaScript code and not with the app.
What did I do wrong? I wrote the wrong syntax.
|
1 |
alert('Hello') |
Instead, write the code given below.
|
1 |
alert('Hello'); |
The only mistake was I missed the semicolon (;) and I got this error message. I corrected the code and everything was fine and I got an alert message with “Hello”.
Thus, I thought of sharing this, because the error message is somehow misleading in finding the solution.
Thus, when you get the error like this, then do the checks given below.
If you have injected any kind of JavaScript code to Nintex Forms, then please make sure that the code has proper syntax.
If you don’t have any JavaScript code, go for updating Nintex Forms for Office 365 app.
It saved my time to a phenomenal extent. I hope, this will save time for others also.
If you have any query regarding this or you need more information, please feel free to ask in the comment section.
SharePoint Hosting Recommendation
HostForLIFE.eu’s SharePoint 2016 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2016 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2016 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2016 plans as well as dedicated SharePoint 2016 Foundation options.
