European Sharepoint 2013 Hosting Blog
Articles about European Sharepoint Hosting Service
SharePoint 2013 Hosting UK – HostForLIFE.eu :: How To Connect To Microsoft Teams Using PowerShell?
Aug 16th
Microsoft Teams PowerShell cmdlets are currently available in beta version and this would be helpful for Microsoft Teams administration and management.
Open PowerShell window and run the following command to Install Microsoft Teams Module.
|
1 2 |
# Install Microsoft Teams Module Install-Module MicrosoftTeams |
Run the following command to add Teams module to the current session.
|
1 2 |
# Add MicrosoftTeams Module to the current session Import-Module MicrosoftTeams |
Run the following command to connect to Microsoft Teams.
|
1 2 3 4 5 |
# Get the credentials $credentials=Get-Credential # Connect to Microsoft Teams Connect-MicrosoftTeams -Credential $credentials |
Run the following command to get all the teams.
|
1 2 |
# Get all the teams Get-Team |
Reference
https://docs.microsoft.com/en-us/powershell/module/teams/?view=teams-ps
Thus in this blog, you saw how to connect to Microsoft Teams using PowerShell for service administration and management.
SharePoint 2013 Hosting UK – HostForLIFE.eu :: How to Overcome Yammer URL Encoding Issues in the Webpart Title?
Aug 14th
In this blog, I will demonstrate how to overcome Yammer URL encoding issues in the webpart title. I have added a content editor webpart to embed a Yammer group feed and it works fine.
Further, we have configured webpart title URL to point to that Yammer group, so that the users can open group conversations in full window. Group link is copied from the address bar of that specific yammer group, as shown below.
https://www.yammer.com/company.com/#/threads/inGroup?type=in_group&feedId=12668139&view=all
Surprisingly, after saving the page webpart, title link didn’t work. After having a close look, I noticed ‘#’ is replaced with ‘%23’.
https://www.yammer.com/company.com/%23/threads/inGroup?type=in_group&feedId=12668139&view=all
Here are some approaches to fix the issue.
URL Formatting
Format yammer group URL as below.
https://www.yammer.com/{network permalink}/groups/{feedId}
Original URL
https://www.yammer.com/company.com/#/threads/inGroup?type=in_group&feedId=12668139&view=all
Formatted URL
https://www.yammer.com/company.com/groups/12668139
Simply Add ‘?’ before ‘#’ (you will like this 🙂 )
https://www.yammer.com/company.com/?#/threads/inGroup?type=in_group&feedId=12668139&view=all
SharePoint 2013 Hosting – HostForLIFE.eu : How To Get All The Lists Which Have Unique Permissions From the Sharepoint Online Site Using PnP PowerShell
Aug 9th
In this blog, you will see how to get all the lists which have unique permissions from the root site as well as sub sites using PnP PowerShell.
You can download setup files from the releases section of the PnP PowerShell repository. Copy the below script and paste it in a notepad. Save the file as GetUniquePermissions.ps1.
Open PowerShell window and run the following command.
|
1 |
>cd "<folderlocation>" |
folderlocation – GetUniquePermissions.ps1 file location
Run the following command
|
1 |
>.\GetUniquePermissions.ps1 |
Thus in this blog, you saw how to get all the lists which have unique permissions from the SharePoint online site using PnP PowerShell.
SharePoint 2013 Hosting – HostForLIFE.eu : Move Site Columns From A SharePoint Site To Another Using PNP PowerShell
Aug 7th
Using PNP, we can retrieve the complete backup of a site but just to move the site columns from one to another, we need to write custom PS scripts. In this article, I am picking a Site Column group and provisioning it to another site using PNP PowerShell. Before proceeding, we need to ensure that the SharePoint Online Management Shell is installed on your machine. If not, use this link to download and install it. Also, we have to make sure that we have enough permissions to retrieve the field schema from the source site and to provision them in the target site.
If we are provisioning inside the same tenant, there won’t be much trouble in provisioning taxonomy fields. If we need to provision the taxonomy fields in a different tenant, we should have term store related permissions. Otherwise, we are not able to create term sets which, in turn, affect the PNP provisioning process.
I am considering PSSamples site from my tenant as source and will proceed to move the site columns from a Site Column group called “My columns”. I will get all the site columns that come under this group, using the below PS script and frame it as a PNP provisioning XML.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
Connect-PnPOnline -Url "https://**********.sharepoint.com/sites/PSSamples" $flds= Get-PnPField -Group "My Columns" $fldsSchema='<?xml version="1.0"?> <pnp:Provisioning xmlns:pnp="http://schemas.dev.office.com/PnP/2018/01/ProvisioningSchema"> <pnp:Preferences Generator="OfficeDevPnP.Core, Version=2.23.1802.0, Culture=neutral, PublicKeyToken=5e633289e95c321a" /> <pnp:Templates ID="CONTAINER-TEMPLATE-0F2053A13C224D369E82C2FA2EC4A736"> <pnp:ProvisioningTemplate ID="TEMPLATE-0F2053A13C224D369E82C2FA2EC4A736" Version="1" BaseSiteTemplate="STS#0"> <pnp:SiteFields>' ForEach($fld in $flds){ $fldsSchema+=$fld.SchemaXml } $fldsSchema+='</pnp:SiteFields> </pnp:ProvisioningTemplate> </pnp:Templates> </pnp:Provisioning>' $fldsSchema |
I enclosed the schema of the XML inside the PNP Provisioning schema format which was released on Jan 2018, so that we can provision the result XML to a target site using PNP core libraries. After running the above code, we will be getting an XML like below.
Save the XML in a separate file and run the below script to provision it to a target site.
|
1 2 |
Connect-PnPOnline -Url "https://*********.sharepoint.com/sites/content1" Apply-PnPProvisioningTemplate -Path "C:\Users\ADMIN\Desktop\fields.xml" |
PowerShell will show some interactive progress bar where we can see the field by field updates. If needed, we can log that the process has been running in the background. After provisioning, go to the target site’s site settings and then go to Site Columns page to see the changes made to the SharePoint site using PNP provisioning.
SharePoint 2013 Hosting – HostForLIFE.eu : How To Update The Hyperlink In The SharePoint Online List Items Using PnP PowerShell?
Jul 31st
I have created multiple views in different lists (approximately 100) across the site and I am storing those list view URL’s in a link list. I have two different environments, INT and QA. When I migrate the link list from one environment to other environment the link list is migrated with all contents but the URLs have to be updated. For example, see the URL format below for each environment.
INT – Link 001 – https://c986.sharepoint.com/sites/dev-int/Lists/Demo/link001.aspx
QA – Link 001 – https://c986.sharepoint.com/sites/dev-qa/Lists/Demo/link001.aspx
In order to overcome this, I have written the below PnP PowerShell script which updates the URLs in the link lists.
You can download setup files from the releases section of the PnP PowerShell repository.
Copy the below script and paste it in a notepad. Save the file as UpdateHyperLink.ps1.
Open PowerShell window and run the following command.
|
1 |
>cd "<folderlocation>" |
folderlocation –UpdateHyperLink.ps1 file location
Run the following command
|
1 |
.\ UpdateHyperLink.ps1 |
Thus in this blog, you saw how to update the hyperlink in the SharePoint Online List Items using PnP PowerShell.
SharePoint 2013 Hosting – HostForLIFE.eu : PowerApps In SharePoint Online
Jul 26th
I will be discussing the features provided by PowerApps and how we can utilize them and customize based on our requirement.
PowerApps is a software to build custom business applications without the knowledge of app development or custom coding. It is included in most Office 365 subscription plans and is yet another feature of Office 365, just like OneDrive, Planner, and others.
PowerApps is independent of SharePoint, however, is tightly integrated with it, being part of the Office 365 suite. While PowerApps is designed to work with a number of different sources, like external databases, you can also easily connect PowerApps to any SharePoint list, library or OneDrive, which allows you to store and retrieve information without a need to know databases or SQL.
As we can see that when we create a list, we get options to customize in PowerApps as:
When we click on “Create an app”, it will create new PowerApps, which will run independently outside of SharePoint context. But it will be using SharePoint list/library internally which was configured at the time of app creation.
But when we click on “Customize form”, it will customize the default list view form of SharePoint like view/edit/new form. So any changes on one form will be visible to all three forms.
So you can click on “Customize forms” if you want to change look and feel of the form but if you want to make some logic/condition which will trigger some event, you need to create an app in PowerApps.
Steps to create PowerApps
- Click on create an app, provide app name and click Ok, it will navigate you to PowerApps studio. I have used Demo as my app name.
- As it opens PowerApps studio, we are presented with 3 options on the left side as by default and our dashboard will display the record from the list we configured PowerApps.
However, we can add multiple screens based on our condition.
For demo purpose, I will be adding new screen which will be redirected based on columns value.
Scenario
I have kept the Status column in my list which contains Approved, Pending and Complete as their value. Now, I want that if the request is in a complete stage, it should be redirected to view page only else it should be redirected to Edit page.
Step 1
Click on New Screen from the top left screen and rename as ViewOnly.
Step 2
Click on Connect to data, give the URL of your SharePoint site, and select the list.
Step 3
Select ViewOnly from the left panel and from top, select Insert > Forms > Display.
As you can see we have by default all columns coming from the list, but we can uncheck columns under Fields in right panel if we do not want those fields to be displayed on our page.
Step 4
Select FormViewer1 under ViewOnly and from the top drop-down, select “Item” and type “BrowseGallery1.Selected” in the textbox next to fx. It will bring records from the list and bind it with controls on the page.
Step 5
Select BrowseScreen1 and select arrow icon on the dashboard and type in the textbox next to fx button as below.
- Select(Parent);
- If(ComplainStatus.Value = “Completed”, Navigate(ViewOnly, ScreenTransition.Cover), Navigate(BrowseScreen1, ScreenTransition.Cover), Navigate(BrowseScreen1, ScreenTransition.Cover))
Click Save and publish. It will be saved to the list and once we click on the view arrow mark on the dashboard, it will redirect us to ViewOnly page if the status is completed; else, it will be navigated on default edit page based on a Status column value.
