Flow app in SharePoint Office 365

Flow:    

We can create automated workflows between your favorite apps and services to get notifications, synchronize files, collect data, and more. See how it works. Introducing multiple environments — distinct spaces to store and manage your organization's flows.
Navigate to Office 365.
Office 365 new app Flow -> Click on Flow App                                                                     
                                                                
 Here we can create Flow in two ways

Create from blank

  We can choose our own template to create  flow.


Crete from template
   We can choose from existing template to create flow

Now we are going to create flow using Create from blank -> Click on create from blank


 Search for triggers and select, here we are selecting "Blogger when Post is created".


Add  Blog Id & Post Status
Here I selected my blog & Post status is All. It will get data from under all section in blog.
-> Click on New Step






-> Click Add an Action



       Search for triggers and select, here we are selecting "SharePoint Create item"
Enter SharePoint Site url & select list where you want to store blog                   details                                                                                                                                                         

Select the title on Dynamic Content -> Click on Create flow      
                                                                                                                              
Now Flow created successfully.



Now create a article in Blog & Publish. Finally check the SharePoint list what we selected in flow, Item was created successfully.         

Hope it's help.

Cannot connect to the server at this time. Changes to your data cannot be saved



  I Export to Excel SharePoint custom list, when I am trying to open that excel sheet it’s showing the below error.


Error:


Resolution:

I added the SharePoint site URL in Compatibility view.

Navigate to IE settings -> click on compatibility view settings.

 


Add SharePoint site url and close the settings.


Now refresh the page and check. Hope it will help.

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Get Random values from SharePoint list using PowerShell

In this article we are going to learn how to Get Random SharePoint items using PowerShell.
PowerShell is a Powerful scripting language, we can do our work/tasks easily, having so many built-in commands are available in PowerShell. In that we are using Get-Random command to get the random SharePoint list items.




add-pssnapin microsoft.sharepoint.powershell
$web = get-spweb -identity "http://dotnetsharepoint.com /sites/sharepoint/getrandom "
$Employeelist = $web.lists["Employee"];
$listitemsTotal = $Employeelist.Items.Count
$getvalues = $Employeelist.Items
if($listitemsTotal -gt 0)
{
$Random=Get-Random -Count $listitemsTotal -InputObject(1..$listitemsTotal)
}
for($j=0;$j -lt $listitemsTotal;$j++){
$RandomVal=$Random[$j]
$EmpNameName=$getvalues[$RandomVal]["EmployeeId"];
Write-host $RandomVal
write-host $EmpNameName

}

Hide “Edit Links” in quick launch SharePoint 2013

Here you can see how to hide “Edit links” in quick launch left navigation in SharePoint 2013.
This option is useful to drag and drop links in the quick launch, but how ever having access to create a new item they can able to see this option and can also modify these options , we are hiding the Edit Links to restrict all the users, using the CSS  as shown below.
Add the Content Editor or Script Editor in the home page or in any page that you want to hide the “Edit Links”

<style>
.ms-displayInlineBlock
{
display: none;
}
</style>


Move site collection from one content database to another content database

In this article we can able to see how to move site collection from one content database to another content database using PowerShell.
 Using Move-SPSite , this is used to move a site collection from one content database to another content database.
We have to execute the below command.

 Move-SPSite -Identity "http://dotnetsgharepoint.com/sites/movesitecollection"-DestinationDatabase "WSS_AnotherDBName"
-Identity is used to identify the site collection

Once Move-SPSite command executed, have to restart the IIS, run the iisreset command on all the servers in the farm to reflect changes in the IIS.

Create SharePoint sub site using Rest API

In this article you are able to see how to create sub site using Rest API.
We created a custom page and designed UI as per the below, Add this code in the script editor web part.
Create SharePoint Sub site using Client object model

<html>
<head>
<script type="text/javascript" src="https://code.jquery.com/jquery-2.1.0.min.js"></script>
<script type="text/javascript" src="https://ajax.aspnetcdn.com/ajax/4.0/1/MicrosoftAjax.js"></script>
<script type="text/javascript">
$(document).ready(function () {
               bindButtonClick(); 
 });
 function bindButtonClick() {  
            alert('startbtnclick');
            $("#register").on("click", function() {  
                var name = $("#txtSiteTitle").val();  
                var id = $("#txtSiteDescription").val();  
                var URL = $("#txtSiteURL").val();
                if (name == '' || id == '' || URL == '') {  
                    alert("Please fill all fields...!!!!!!");  
                } else {  
                    createSite();  
                }  
            });  
        } 
function createSite()
{
      var siteTitle = $("#txtSiteTitle").val();  
            var siteDesc = $("#txtSiteDescription").val();  
            var siteUrl =  $("#txtSiteURL").val();
  $.ajax({
   url: "https://dotnetsharepoint.com/Test/_api/web/webinfos/add",
   type: "POST",
   headers: {
    "accept": "application/json;odata=verbose",
    "content-type": "application/json;odata=verbose",
    "X-RequestDigest": $("#__REQUESTDIGEST").val()
   },
   data: JSON.stringify({
    'parameters': {
     '__metadata': {
      'type': 'SP.WebInfoCreationInformation'
     },
     'Url': siteUrl ,
     'Title': siteTitle ,
     'Description': siteDesc ,
     'Language': 1033,
     'WebTemplate': 'sts',
     'UseUniquePermissions': false
    }
   })           
  });
 }
</script>


</head>

<body>  
    <div class="container">  
        <div class="main">  
            <form class="form" method="post" action="#">  
                <h2>Create Client sub Site</h2>
                 <label>Client Site Name :</label> <input type="text" name="dname" id="txtSiteTitle"> 
                 <label>Client Site Description:</label> <input type="text" name="demail" id="txtSiteDescription"> 
                 <label>Client Site URL: </label> <input type="text" name="durl" id="txtSiteURL">
                 <input type="button" name="register" id="register" value="Submit"> </form>  
       </div>  
</body>
  
</html>




Create SharePoint Sub site using Client object model

In this article we can able to see how to create a sub site in SharePoint using Client object model.
Create a custom page and add the below code in the Script Editor Web part.


<html>
<head>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.12.3.js"></script>
<script type="text/javascript" src="https://ajax.aspnetcdn.com/ajax/4.0/1/MicrosoftAjax.js"></script>
 <script src="../_layouts/15/sp.runtime.js" type="text/javascript"> </script>
 <script type="text/javascript"> 
        $(function() { 
            bindButtonClick(); 
        }); 
        function bindButtonClick() { 
           $("#register").on("click", function() { 
                var name = $("#txtSiteTitle").val(); 
                var id = $("#txtSiteDescription").val(); 
                var URL = $("#txtSiteURL").val();
                if (name == '' || id == '' || URL == '') { 
                    alert("Please fill all fields...!!!!!!"); 
                } else { 
                    createSite(); 
                } 
            }); 
        } 

        function createSite() { 

            var siteTitle = $("#txtSiteTitle").val(); 
            var siteDesc = $("#txtSiteDescription").val(); 
            var siteUrl =  $("#txtSiteURL").val(); 
            var clientContext = new SP.ClientContext('https://rptj.sharepoint.com/Test/'); 
            var collWeb = clientContext.get_web().get_webs(); 
            var webCreationInfo = new SP.WebCreationInformation(); 
            webCreationInfo.set_title(siteTitle); 
            webCreationInfo.set_description(siteDesc); 
            webCreationInfo.set_language(1033); 
            webCreationInfo.set_url(siteUrl); 
           webCreationInfo.set_useSamePermissionsAsParentSite(true); 
            webCreationInfo.set_webTemplate('STS#0'); 
            var oNewWebsite = collWeb.add(webCreationInfo); 
            clientContext.executeQueryAsync(Function.createDelegate(this, onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed)); 
        } 
        function onQuerySucceeded() { 
            alert('Site successfully Created!'); 
        } 
       function onQueryFailed(sender, args) { 
            alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace()); 
        } 
    </script> 
</head>



<body> 

    <div class="container"> 
        <div class="main"> 
            <form class="form" method="post" action="#"> 
                <h2>Create Client sub Site</h2> 
               <label>Client Site Name :</label> <input type="text" name="dname" id="txtSiteTitle">
                 <label>Client SIte Description:</label> <input type="text" name="demail" id="txtSiteDescription">
                 <label>Client SIte URL:</label> <input type="text" name="durl" id="txtSiteURL">
                 <input type="button" name="register" id="register" value="Submit"> </form> 
       </div> 
</body>
  </html>




Filtering & Sorting using SharePoint online List with Angular JS & Rest API

In this article we can learn how to do Filtering & Sorting in SharePoint List with Angular JS & Rest API
In a page added the script editor and place the below code.
<style>
        th {
            background-color: blue;
            color: white;
        }
    </style>
    <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.0.1/angular.min.js"></script>
    <script src="http://code.jquery.com/ui/1.10.3/jquery-ui.min.js"></script>

    <script>

    var myAngApp = angular.module('SharePointAngApp', []);
    myAngApp.controller('spCustomerController', function ($scope, $http) {
        $http({
            method: 'GET',
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('InfoList')/items?$select=Title,Employee,Company",
            headers: { "Accept": "application/json;odata=verbose" }
        }).success(function (data, status, headers, config) {
            $scope.customers = data.d.results;
$scope.mySortFunction = function(customer) {//Sorting Iteam
                                    if(isNaN(customer[$scope.sortExpression]))
                                                return customer[$scope.sortExpression];
                                    return parseInt(customer[$scope.sortExpression]);
                        }
        }).error(function (data, status, headers, config) {

        });

    });

    </script>

    <h1> Filtering and sorting in SharePoint List using AngularJS-REST-API !!</h1>
    <br /><br />
    <div ng-app="SharePointAngApp" class="row">
        <div ng-controller="spCustomerController" class="span10">
            <div>
                Sort by:
                <select ng-model="sortExpression">
                    <option value="Title">Title</option>
                    <option value="Employee">Employee</option>
                    <option value="Company">Company</option>
                </select>
            </div>

            <br />
            Search By Any:
            <input type="text" ng-model="search.$" />
            <br />
            <br />
            <table class="table table-condensed table-hover">
                <tr>
                    <th>Title</th>
                    <th>Employee</th>
                    <th>Company</th>

                </tr>
                <tr ng-repeat="customer in customers  | orderBy:mySortFunction | filter:search">
                    <td>{{customer.Title}}</td>
                    <td>{{customer.Employee}}</td>
                    <td>{{customer.Company}}</td>
                </tr>
            </table>
        </div>
    </div>  


Get data from SharePoint Online list using Rest api & Angular JS


In this article you can see how to bind data from list using Rest API and Angular JS.
We are having a list with name "InfoList”, in the page we added the script editor and added the below code.
What is difference between AngularJS and Angular 2
<style>
table, td, th {
    border: 1px solid blue;
}

th {
    background-color: Green;
    color: white;
}
</style>
<script type="text/javascript"  src="https://ajax.googleapis.com/ajax/libs/angularjs/1.0.1/angular.min.js"></script>
<script type="text/javascript" src="http://code.jquery.com/ui/1.10.3/jquery-ui.min.js"></script>
<script>
   
    var myAngApp = angular.module('SharePointAngApp', []);

    myAngApp.controller('spCustomerController', function ($scope, $http) {
        $http({
            method: 'GET',
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('InfoList')/items?$select=Title,Employee,Company",
            headers: { "Accept": "application/json;odata=verbose" }
        }).success(function (data, status, headers, config) {
            $scope.customers = data.d.results;
        }).error(function (data, status, headers, config) {
      
        });
    });
   

</script>

<h1> Angular JS SharePoint REST API !!</h1>

<div ng-app="SharePointAngApp" class="row">
    <div ng-controller="spCustomerController" class="span10">
        <table class="table table-condensed table-hover">
            <tr>
                <th>Title</th>
                <th>Employee</th>
                <th>Company</th>
              
            </tr>
            <tr ng-repeat="customer in customers">
                <td>{{customer.Title}}</td>
                <td>{{customer.Employee}}</td>
                <td>{{customer.Company}}</td>
                </tr>
        </table>
    </div>
</div>

      
        });
    });
     
</script>




What is difference between AngularJS and Angular 2


AngularJS 1:


·         AngularJS is a structural Framework for dynamic web apps. It can be added to an HTML page with a <Script> tag.

·         It extends HTML attributes with directives & binds data to HTML with expressions.

·         It is fully open source & free to use.

AngularJS has different directives, provides various functionality in the application.

ng-app: This directive initializes an AngularJS application

Ex: <div ng-app = ""></div>

ng-model: This directive is used to bind the values from AngularJS application to HTML input controls.

Ex: <input type = "text" ng-model = "name">

ng-bind: This directive bind AngularJS application data into HTML tags.

Ex: <span ng-bind = "name"></span>

 ng-repeat: This directive is used to repeat html element.

Angular 2:


·         Angular 2 implements unidirectional tree based change detection which again increases performance.

·         It implements web standards like components, and it provides better performance than AnguarJS 1.

·         In Angular 2, local variables are defined using hash (#) prefix.

Ex: <div *ngFor="# customer in customers” >


Difference between AngularJS 1.x & Angular 2:


AngularJS 1 .x
Angular 2
It was not built with mobile support.
Mobile oriented
Languages support: ES5, Es6, and Dart.
More choice for language.
Languages support:  Es5, ES6, Typescript or Dart.
Easy to setup, we need to add reference of the library.
It is not easy to setup.It is dependent of other libraries and it requires some efforts to set up it.
Controllers
Angular 1.x Controller:
var myApp = angular
.module("myModule", [])
.controller("productController", function($scope) {
         var prods = { name: "Prod1", quantity: 1 };
         $scope.products = prods;
});
Controllers are replaced with Components
Angular 2 Components using Typescript:
import { Component } from '@angular/core';
@Component({
    selector: 'prodsdata',
    template: '<h3>{{prods.name}}</h3>'
})
export class ProductComponent {
    prods = {name: 'Prod1', quantity: 1 };
}
Structural Directives
ng-repeat
Example:
<ul>
   <li ng-repeat="technology in technologies">
     {{technology.name}}
   </li>
</ul>
Structural Directives
*ngFor
Example:
<ul>
  <li *ngFor="#technology of technologies">
    {{technology.name}}
  </li>
</ul>
Asterisk (*) sign is used as prefix for structural directives & camel case syntax is used.
It is not used camel case syntax for built-in directives.
Example:
ng-class, ng-model
Uses camel case syntax for built-in directives.
Example:
ngClass , ngModel
Angular 1 not directly used valid HTML DOM element properties and events.
Example:
ng-href , ng-src, ng-show & ng-hide
Events:
ng-click, ng-blur
<button ng-click=”Showdata()”>
Directly uses the valid HTML DOM element properties and events.
Example:
href, src & hidden
Events:
click
<button (click) =”Showdata()”>
ng-bind is used for One-way data binding directive
Example:
<input ng-bind=”my.name”></input>
One-way data binding directive replaced with [Property]
Example:
<button (click) = “showdata()”>
ng-model is used for two-way data binding
Example:
<input ng-model=”my.name”></input>
Two way data binding is replaced with [(ngModel)]
Example:
<input [(ngModel)]=”my.name”></input>
AngularJS 1.x using ng-app for Bootstrapping.
Example:
<script>
   angular.element(document).ready(function() {
      angular.bootstrap(document, ['myApp']);
   });
</script>
Angular 2 using bootstrapping via code.
Example:
import { bootstrap } from 'angular2/platform/browser';
import { ProductComponent } from '-/product.component';
bootstrap(ProductComponent);

Labels

.Net Interview Questions add custom button in sharepoint using javascript Add custom column property into a PageLayout in SharePoint Add Page Title on their browser's title bar in SharePoint Customly add zip files in blogger Add-SPOSiteCollectionAppCatalog : Must have Manage Web Site permissions or be a tenant admin in order to add or remove sites from the site collection app catalog allow list Advance SmartObject An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL. Angular 2 Angular JS Angularjs Angularjs 1 anonymous users accessing lists and libraries App Permissions for SharePoint 2013 asp.net membership unique email Asp.net TreeView Control asp.net. Attendees in SharePoint Auto refresh list using Content Editor WebPart in SharePoint 2013. Auto Refresh SharePoint list using JavaScript Block and unblock of attachment types in SharePoint Blogger C# Callouts in SharePoint 2013 Cascading Dropdown list in SharePoint change onenote to another location. change SuiteBarLeft in SharePoint 2013 check if userid exists in database c# click node text to expand/collapse in Treeview client object model Close webpart CQWP crate chart using BI site in PPS Create a modern team site collection in SharePoint online Create BI chart in PPS SharePoint 2013 create filter in dashboard designer. create kpi's in dashboard designer create kpi's in SharePoint 2013 dashboard designer Create List Create List In SharePoint Create List using Power Shell Script Create Lookup Field in List using Power Shell Script Create lookup field in List create SharePoint List custom view. create SharePoint List views in List Schema create site collection in site collection in SharePoint using powershell created Date Time calculated field in SharePoint Cross site Collection in SharePoint 2013 Crud Operation in Asp.net Using Stored Procedure Custom MasterPage Approval in SharePoint custom view for survey list Customly add SharePoint List view in Page. delete items in sharepoint using powershell Difference between Angular 1.x & Angular 2 difference between Office 365 and Windows Azure difference between Windows Azure and Office 365 in sharepoint? DifferenceBetween discussion board Display Data in Grid View display radio buttons and choice fields horizontally in SharePoint 2013 Document library DotNet Drag and drop documents in document library in SharePoint dynamically populating values from one list to another list using jquery in sharepoint edit and delete buttons in datagridview Edit Links email notification using Nintex enable anonymous access in SharePoint 2013 enable app catalog sharepoint online site collection powershell Enable appcatalog site collection level using PowerShell based on Input file Enable versions for list and library except the hidden lists using PowerShell Script Error occurred in deployment step 'Recycle IIS Application Pool': Cannot resolve model for the project package Errors&Solutions Export document library in sharepoint using powershell Export particular Group in Term Store Management in SharePoint 2013 Export to Excel first release Flow Flow features free disk space on servers using powershell Friendly URLs and Managed Navigation in SharePoint 2013 get a list of site collection with template in web application using PowerShell Script in SharePoint Get attachments in SharePoint custom list using c# get current list item id sharepoint programmatically Get current url using jquery Get data from SharePoint list using Rest api & Angular JS Get Random Get Random SharePoint items using PowerShell Get Random values from SharePoint list using PowerShell Get url of the last value using jquery Get-SPOSite : The managed path sites/yoursitename is not a managed path in this tenant. Getting Email From User Hide “Edit Links” in left navigation SharePoint 2013 hide button in sharepoint based on permissions Hide column in SharePoint List view hide fields using client side object model Hide list in Quick Launch in SharePoint using PowerShell How to add Custom Tiles to SharePoint site Page. How to add extension files in Search Navigation in SharePoint 2013 How to Add Multiple users Using SharePoint People Picker How to add SharePoint list view in Page using C# How to Approve MasterPage using PowerShell in SharePoint How to bind Multiple users Using SharePoint People Picker how to change indicators on kpi performance how to check if an email address already exists in the database in asp.net how to configure workflow manager platform for SharePoint 2013 how to create calculated value using powershell how to create certificate in SharePoint How to create flow. how to create gantt chart webpart in sharepoint how to create KPI indicators in Dashboard designer How to create moden communication site in SharePoint online How to create Multi selected filter in Dashboard How to create nintex workflow in sharepoint how to create rdlc reports in asp.net How to Display Data Grid View in ASP.net How to enable anonymous access in SharePoint How to find data in datagridview in c# How to get image names from the folder using C# how to get particular list content type id in SharePoint 2013 How to get QueryString value in SharePoint WebPart Programatically how to get the current item id for newly created item using REST API and JQuery how to hide list in sharepoint how to know who created list in sharepoint How to make a Site Collection Read-Only in SharePoint 2010 How to overlay Office 365 shared calendar on SharePoint Site how to pass jquery value to asp.net textbox control How to pass pagename as a browser's title bar in the page how to remove unused Application Pool in SharePoint how to remove zone using powershell script How to send mail to particular group of people using PowerShell how to update modified by and created by using powershell how to uplaod RAR files in blogger import csv data into sharepoint import data using powershell Import group to term store management using SharePoint 2013. InfoPath InfoPath Cascading Dropdown list Insert update delete in datagridview in C# winforms Integration from SharePoint to k2. K2 Smart Forms for SharePoint JavaScript Injection jquery K2 blackpearl K2 Designer K2 Designer Workflow. K2 smartform cascading dropdown list k2 Workflow K2 workflow to send a mail with PDF left navigation Local Term Set in managed meta data Managed meta data navigation in SharePoint 2013 Managed metadata service in SharePoint 2013. Managed Navigation in SharePoint 2013. Managed Promoted Sites. meta data navigation Microsoft Flow New Features New-SPConfigurationDatabase The user does not exist or is not unique NintexWorkFlow Office 365 OneNote overwrite existing document in sharepoint using javascript PDF Converter PDF Method in K2 Performance Point Service in SharePoint 2013 PerformancePoint Services Configurtion PerformancePoint Services Configurtion for SharePoint 2013 PerformancePoint Services in SharePoint Server 2013 Popularity trends in SharePoint 2013 Pages populate dropdown list dynamicallyusing jquery Power Shell Power shell script to get SharePoint site size. powershell read xml PowerShell Script PowerShell script to get list of users from SharePoint groups PowerShell Scripts in SharePoint 2013 Powershell to set the masterpage in SharePoint Promoted Links Promoted Sites psconfig.exe quick launch Rdlc reports Readonly Column in SharePoint Editview Realtime DotNet Interview Questions Recent Dotnet interview questions Recent SharePoint interview questions recover deleted OneNote page. OneNote content is missing Regional Settings in SharePoint 2013 Replace New Item text in SharePoint Rest API Schedule PowerShell Script Search in SharePoint 2013 Search navigation in SharePoint 2013 Secure store service SecureStore Services SecureStore Services configuration for SharePoint 2013 self-signed certificate on IIS Server Send email to members of SharePoint Group using PowerShell sharepint2010 sharepoin2010 SharePoint 2013 SharePoint 2010 SharePoint 2013 SharePoint 2013 Dashboard Designer SharePoint 2013 features SharePoint 2013 Interview Questions SharePoint 2013. SharePoint 2013.disable views from user to create SharePoint 2013.Power shell SharePoint 2013.SharePoint 2010 SharePoint 2016 SharePoint Administration SharePoint Alerts and Reminders SharePoint App Configuration SharePoint Apps SharePoint Bulk upload SharePoint Calculated field SharePoint Calendar View sharepoint interview questions SharePoint online training SharePoint Onprem vs Online SharePoint RealTime Online Training SharePoint2010 SharePoint2013 SharePoint2016 SharePointInterview SharePointOnline SharePointOnline;Restore deleted site;SharePoint 2013 show data in datagridview in C# Simple Insert update Delete Retrieve Clear in asp.net. Site Collection Operations in SharePoint 2013 Site Collection Read-Only in SharePoint 2013 site contents Sorting & Filtering SPSite Site Collection Operation parameters in SharePoint 2013 Step by step to create rdlc report in .Net Store names in text files in C# Sub site Subsite Term store management. The server was unable to save the form at this time. please try again UI New look update created by using client side object model update field values in SharePoint using powershell update items in SharePoint list using client object model update modified by field using client side object model upload zip files in blog use IsNullOrEmpty in PowerShell VirtoSoftware VirtoSofware vitrosoftware WebParts what is Document Set in SharePoint 2010 What is Filter in SharePoint Dashboard what is Limited-access user permission lock down mode feature What is Modern Team site What is Target Audience in SharePoint Who Created Site Using PowerShell Workflow in SharePoint 2013 Workflow management platform in SharePoint 2013 Workflow manager for SharePoint 2013 XSL-Template.