Skip to main content

Posts

CSOM in SharePoint

We have to refer the Client side DLL firstly using sp = Microsoft.SharePoint.Client; Creating sample JSON PriceValuesJSON = @"[                                                             {                                                             ""Title"": ""SN"",                                                             ""value"": 41.4                                                         ...
Post a Comment
Read more

SharePoint REST API

You can perform CRUD operations like Create, Read, Update and Delete. REST means Representational State Transfer SP introduces client side object model and then similar or corresponding other solution is REST API. Users can intact with application remotely with SharePoint data that support REST web requests. It supports OData syntax which means standard open data protocal Firstly we need to create Restfull HTTP  request by using OData standard which is corrosponding to the CSOM API. After interacting with SharePoint database with HTTP request, it retries or gives the data back in JSON format which is also called as Javascript Object Notation. GET, POST, PUT or MERGE, DELETE are the HTTP requests used in REST API _spPageContextInfo . webAbsoluteUrl  +  "/_api/Web/Lists/GetByTitle('ListName')/Items While create a list item, var data = { __metadata: { ' type' : ' SP.Data.SpTutorialListItem' }, Title: ' Some title' , S...
Post a Comment
Read more

Auto Chase site workflow using SharePoint designer

Scenario: When ever a list item has not approved after one day, that means when ever modified date exceeds 1 day and compare with today date eg: Modified date+1 = 28-Aug + 1 day = 29 Aug is the modifiedPlusone date and todaydate is 29 Aug Now if modifiedPlusone >= todaydate then send email to the user. In the above scenario, you can create a site workflow and you can use certain actions and run the workflow daily. Workflow: Stage:Stage 1 Build {...} Dictionary (Output to Variable: JSonRequestHeader ) Call https://team.uat.sp.wp.corpintra.net/... HTTP web service with request (ResponseContent to Variable: JSonResult |ResponseHeaders to responseHeaders |ResponseStatusCode to Variable: responseCode ) Get d/results from Variable: JSonResult (Output to Variable: list ) Count Items in Variable: list (Output to Variable: counting ) Set Variable: index to 0 Loop: Loop the List The contents of this loop will run Variable: counting times Get d/results([%Variabl...
Post a Comment
Read more

Power Apps

Community plan: PowerApps Community Plan gives you access to PowerApps premium functionalities, Common Data Service, and Microsoft Flow for individual use. This plan is primarily meant for learning purposes or creating business solutions to be distributed for AppSource Test Drive. This plan is perpetually available, but only for learning and building your skills on PowerApps, Common Data Services, and Microsoft Flow. It can run unlimited number of apps We can use common data service Connect to Office 365, Dynamics 365 User premium connectors like Salesforce, DB2 Access on premises date using on premises gate way Cloud environments like Azure, SQL, Dropbox, Twitter Can create custom connectors Common data service, Can create run common data service, model your common data service, create database in common data service User roles and access permissions: You can't add co-workers as environment makes and admins Add co-workers to the database role...
Post a Comment
Read more

SharePoint List forms how to customize using JQuery

Here is the solution to customize SharePoint list forms with out using SharePoint designer. This solution is using "Jquery" You can add bootstrap references for custom design Step 1: Create a SharePoint custom list Step 2: Create columns as 1. Person 2. Title (which is out of the box) Step 3: Click on the "new form", or "edit form", or "view form" of out of the box SharePoint List. Step 4: Edit the form Step 5: Add new content editor and refer a .html/.txt custom file where you refer the below code Click on Save Follow the code below: HTML: <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> //Jquery reference <script src="../../SiteAssets/JS/jquery-1.7.1.min.js"></script> <body> <div class="fulldiv"> <label for="" class="ms-font-m-plus" id="taskDesc_task">Title:...
Post a Comment
Read more

Javascript

Once after page loads, your DOM is ready to load the functions $(document).ready(function(){   myFunction(); }); function myFunction(){   alert("Hello World"); } var carsArray = ["Ford", "Maruthi", "Benz", "Audi"]; carsArray.sort(); //to sort the array //To find its value, then seach by its index carsArray[0] means you will get its value as Audi what is JSON array JSON array is array with key and value pair or Object inside an Array. JSON array most popular data format or data model used in current market. var carJsonArra = [{"Teja":29},{"Meena":24},{"Mouni":28}]; carJsonArra[0]// means it gives 0th index value as {"Teja":29} which is a object inside an array carJsonArra.length // gives length of the array means count of objects inside array //Loop the array in javascript var myData = [{Name: 'Teja'},{Name: 'Mouni'},{Name: 'Meena'}] for(var i=0;i...
Post a Comment
Read more

Power BI

Power BI ref guide:  https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop Introduction Power BI Desktop is a free application you can install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them (often called modeling) into a data model that lets you build visuals, and collections of visuals you can share as reports, with other people inside your organization. Most users who work on Business Intelligence projects use Power BI Desktop to create  reports, and then use the Power BI service to share their reports with others. The most common uses for Power BI Desktop are the following: Connect to data Transform and clean that data, to create a data model Create visuals, such as charts or graphs, that provide visual representations of the data Create reports that are collections of visuals, on one or more report pages Share ...
Post a Comment
Read more