How to create a SharePoint List in Tamil | SharePoint Online List in Tamil

 In this video i have given you a short overview on SharePoint List and different ways to create a list, How to create a SharePoint List in Tamil

What You'll Learn: ✔️ what is SharePoint List ✔️ Limitations of SharePoint list ✔️Different Columns of SharePoint List ✔️ Create list from Blank ✔️ List columns rename

Introduction to Microsoft SharePoint Online in Tamil | what is Microsoft SharePoint Online

 In this video i have given you a short overview on SharePoint which is a web-based collaborative platform that integrates natively with Microsoft Office. Launched in 2001, SharePoint is primarily sold as a document management and storage system, but the product is highly configurable and its usage varies substantially among organizations

What You'll Learn: ✔️ what is SharePoint ✔️ History of SharePoint ✔️Best practices of SharePoint ✔️ Evolution of SharePoint ✔️ List and Library ✔️ Site Permissions ✔️ Benefits of SharePoint

Variables in Powerapps in Tamil | 3 types of PowerApps Variables in Tamil | Rank Calculator app

 In this video I have explained step-by-step tutorial on how you can create a Rank Calculator app using Microsoft PowerApps using Variables

Microsoft SharePoint Playlist https://www.youtube.com/playlist?list=PLpPq2RbQHL-3poKwei6tlD2sAML84ETnu How to create a SharePoint List - https://youtu.be/-iDNs5NrxS4 Power Apps Link : https://make.powerapps.com/ What You'll Learn: ✔️ How to create Rank Calculator app using Powerapps ✔️ What is Global Variable ✔️ What is Context Variable ✔️ What is Collections ✔️ How to use Clear ✔️ Usage of SUM Function ✔️ View variables and collections in File Menu

Get Source File here:

https://github.com/JeganBas/PowerApps/blob/main/RankCalculator_20220903124805.zip

Create a Employee Database app using Microsoft PowerApps | Learn PowerApps in Tamil

 Learn PowerApps in Tamil  | Create a Employee Database App   

In this video I have explained step-by-step tutorial, learn how you can create a Microsoft PowerApps from a SharePoint list in a easy way. Empower your team to start building and launching apps right away using prebuilt templates, drag-and-drop simplicity, and quick deployment—then roll out continuous improvements as needed. Microsoft SharePoint Playlist https://www.youtube.com/playlist?list=PLpPq2RbQHL-3poKwei6tlD2sAML84ETnu How to create a SharePoint List - https://youtu.be/-iDNs5NrxS4 Power Apps Link : https://make.powerapps.com/ What You'll Learn: ✔️ How to create a Powerapps from SharePoint list ✔️ Adding new screens in powerapps ✔️ Navigating to other screens ✔️ Overview on Gallery and Form ✔️ Button and Icons ✔️ On success behavior ✔️ Adding images in powerapps

Source File : https://github.com/JeganBas/PowerApps/blob/main/EmployeeDatabaseApp_20220903125934.zip

Introduction on Power Apps | Create your first app | Video in Tamil

What is Power Apps ?

PowerApps is low code platform through which we can create apps for mobile, tablet and desktop. We can make use of almost all kinds of office 365 products as datasource. The following video can help you to understand the basics of PowerApps in Tamil.

Save an output using PowerShell

Most of the times we want to get some report or any such values from our SharePoint using PowerShell, Once we got the output in the PowerShell window, we want to save it as a document, for that we used to copy them and paste it in a new window. 

There is a simple solution for that, we can add a line of code to save the output data in the desired file format. 

Following is an example of code to get the SharePoint list field data as a output.

$site = Get-SPSite "https://mysharepointsite.com/"
$fID = "69xd368d-2f95-4juc-a1f9-8d4324ecb007"
$fields=$site.rootweb.fields | where ID -match $fID
$fields

We will be able to see the output in the PowerShell window now, to save it as output file as text document, please use the following code.

$site = Get-SPSite "https://project-insight.cas.com/"

$fID = "64cd368d-2f95-4bfc-a1f9-8d4324ecb007"

$fields=$site.rootweb.fields | where ID -match $fID

$fields >D:\Field_Details.txt

Now, the output is saved in the D drive automatically. As per the requirement we can change the directory and file format. 

SharePoint - How to view all the Alerts added in your site by different users in various list

Sometimes as a SharePoint we might came across a issue or situation where we have to manage the alerts in our sites.

In order to mange them, we want to view all of the alerts in the sites at one place, else we have to reach out to each users to know the alerts created by them which is not a fair idea.

So let's see the simple steps to view all the Alerts added in your site by different users in various lists.

Go to your Site
Go to  Site Settings à Site Action à User Alerts or  user the below URL format to navigate to the user alerts page. 

https://your site domain/sites/subsite/_layouts/15/sitesubs.aspx

 Here you go, select the drop down with the list of users who created alerts in that particular site.

On selecting a user, we can able to see the alerts in various list created by the user / or tagged to that particular user,

Also, for a Site Admin, they will have the options to Delete those alerts if required.

SharePoint Hacks

Site collection level recycle bin:

/_layouts/15/AdminRecycleBin.aspx

Site level recycle bin (Added by Steve Stewart):

/_layouts/RecycleBin.aspx

Recreate default site sp groups (Added by Neal Bongers):

_layouts/15/permsetup.aspx

Load document tab initial (Added by Dominik Gempeler)

?InitialTabId=Ribbon.Document

Delete user from Site collection (on-premises) (Added by SamDavid):

/_layouts/15/people.aspx?MembershipGroupId=0

Display list in grid view. 'True' is case sensitive (Added by Antoine L.):

?ShowInGrid=True

Quick Launch settings page (Added by Ishani M.):

/_layouts/quiklnch.aspx

Navigation Settings page (Added by Abdur Raheem):

/_layouts/15/AreaNavigationSettings.aspx

Sandboxed Solution Gallery:

/_catalogs/solutions/Forms/AllItems.aspx

Workflow history hidden list:

/lists/Workflow History

Filter toolbar for Lists and libraries (Added by Asimaili):

?Filter=1

Site usage page (Added by @Dnyag):

/_layouts/usage.aspx

Site content and structure  page (Added by @Dnyag):

/_layouts/sitemanager.aspx

Site settings page (Added by Aowworld):

/_layouts/settings.aspx

View all site content page (Site content) (Added by Aowworld):

/_layouts/viewlsts.aspx

Manage site collection features - CASE SENSITIVE -  (Added by Vardhaman):

/_layouts/ManageFeatures.aspx?Scope=Site

Manage site features (Added by Vardhaman):

/_layouts/ManageFeatures.aspx

 Get the version of the SharePoint server (Patch level) (Added by: John Liu):

 /_vti_pvt/Service.cnf

Web Part Maintenance Page (Added by: Ricky):

?Contents=1

Show Page in Dialog View (Added by:Ricky):

?isdlg=1

Application page for registering SharePoint apps

/_layouts/15/appregnew.aspx

Save Site as a template

/_layouts/savetmpl.aspx

Sign in as a different user

/_layouts/closeConnection.aspx?loginasanotheruser=true

Enable SharePoint designer

/_layouts/SharePointDesignerSettings.aspx

Welcome Page (Default page settings)

/_layouts/AreaWelcomePage.aspx

Change Site Master Page

/_layouts/ChangeSiteMasterPage.aspx

Page Layouts and Site Templates

/_Layouts/AreaTemplateSettings.aspx

Master Pages library

/_catalogs/masterpage/Forms/AllItems.aspx

Quick Deploy List

Quick%20Deploy%20Items/AllItems.aspx
 

Open Page in Edit Mode

?ToolPaneView=2

Taxonomy Hidden List (MMS)

Lists/TaxonomyHiddenList/AllItems.aspx

User Information List:

 _catalogs/users

_catalogs/users/simple.aspx

Force displaying the user profile in the site
collection:

/_layouts/userdisp.aspx?id={UserID}&Force=True

Site hierarchy page (lists of sub sites) - (Added by community contributions)

/_layouts/vsubwebs.aspx

/_layouts/1033/vsubwebs.aspx

SharePoint Framework (SPFx) - Step by Step

Fundamental Building blocks of SharePoint Framework

The following are the important software required for creating SPFx

1. Node JS ( to write node based project)
2. npm package ( these are the pre-written library for node based project )
3. Webpack ( to bundle the code and move to production)
4. Yeoman (a Code generation tool :- used to generate project structure, - find new template)
5. Gulp JS ( Task runner - web server )

Create your first SharePoint Framework WebPart

Step 1 : Install Node JS from https://nodejs.org 
Step 2 : Install npm Package from  https://www.npmjs.com/
              cmd: npm install -g npm ( - g : installing globally )

Now we can start creating node projects which is npm based
Lets Install Yeoman a code template generator tool

Step 3 : cmd: npm install -g yo  https://yeoman.io/

Then we need to install Gulp JS https://gulpjs.com/

Step 4 : cmd: npm install -g gulp

Lets create our new project - SPFx Webpart

Step 5 : cmd: md helloworld webpart
             cmd: cd helloworld webpart

Step 6 : cmd: yo @microsoft/sharepoint
Step 7 : cmd: gulp serve

Now, you can able to view the webpart in a browser, displaying from a localhost server 

Step 8 : To Edit the webpart, open the project folder in Visual Code, and inside the folder "src", there will be a typescript file created, like "helloworldwebpart.ts", which we need to edit as per our requirement. 

To deploy the webpart in production, we need to create a package and push it in the app catalog of the destination production site.

Lets create the package file 

Step 9 : cmd: gulp package-solution -ship

Now, the package file "helloworld-webpart.sppkg" has been created inside the solution folder, under the sharepoint folder inside our project folder.

Step 10 : Open your SharePoint site in a browser and go to the app catalogs page, https://sitename.com/site/appcat

Lets upload or drag & drop our sppkg file in this document library. 

Step 11 : Lets Open the site or subsite where you want to add our new webpart, click on "Add an App", now you will be able to find our webpart in the list.

Step 11 : Lets Open the site or subsite where you want to add our new webpart, click on "Add an App", now you will be able to find our webpart in the list.
Step 12 : Go to the page where you want to display your webpart, and click on insert webpart, under the underdevelopment category, you can find our helloworld webpart. which you can save and it will work.

Note: Update the "write-manifest.json" , with the CDN (Content delivery network )URL, where you want host your code

Know About SharePoint Online

SharePoint

In 2001, Microsoft Launched SharePoint, which is mainly focused for Document storage and Maintenance system.

Most people used to say that SharePoint is Microsoft Application like a word, excel or PowerPoint, which is not true.

SharePoint is collaboration platform, it can be hosted in server or in online.

We can access SharePoint through any popular browsers like Edge, IE, Chrome, Opera, etc.

SharePoint now evolved as SharePoint Online, and keep evolving.

SharePoint Online

SharePoint Online is a cloud-based service that helps organizations share and collaborate with colleagues, partners, and customers.

For a O365 subscriber, Microsoft hosted SharePoint in cloud which can be accessed in any browser anywhere.

Now SharePoint Online can be widely used to store any type of contents like word, Excel PDF, docs, image, video, etc.

Quick note: SharePoint Online collaborates extremely well with Microsoft applications

SharePoint Online as collaborative platform, it allows you to share information across the organization thorough pages, blogs, wiki pages, and other web contents so it’s more like website.

SharePoint Online also having work process, it includes

ü  Data Management

ü  Custom Forms

ü  Workflows

ü  SharePoint Online Search

As all these are hosted in SharePoint Online, we can search them easily. it provides an Endless search.

 -To be Continued..