The Techie Crunch

  Introduction   In this article, we are going to send an email with SharePoint Lookup Column data using Power Automate. We will create a flow that’s run weekly that fetches data from a SharePoint list which contains lookup columns. We will use the “Apply each” action to get lookup records.   SharePoint Parent List - "ProductSales"   Columns Type Title Text ExpiryDate DateTime SalePersonName LookUp (SalePerson List)   SharePoinChild List - "SalePerson"   Columns Type Title Text   In the above lists we have SalePersonName column which is actually the Title column from SalePerson List. When we “Parse Json” data in the above type of data we get two title fields in the dynamic column section. And sometimes workflow fails due to a null record in lookup column. Let’s see the data in the list as below,     Log in to Office.com with Office 365 credentials. Go to the “Power Automate” tile and click on it. It will be redirected to the Power Automate Pa...

In article, We will see SharePoint Interview Questions and Answers which will helpful to understanding SharePoint concepts. Please refer this articles: SharePoint Interview Questions and Answers - Part One SharePoint Interview Questions and Answers - Part Two SharePoint Interview Questions and Answers - Part Three This is three part of SharePoint Interview Questions and Answers: 1.  Difference of site template Team Site Publishing site Developer site Project site Business intelligence site Custom template Blog site Enterprise wiki 2. Difference between team site and project site Project Sites * Project Sites has “Project Functionality” Site Feature activate by default. * A Project Summary Web Part is added to the main page by default. * Project Sites had “Task” list added to it by default. Team Sites * Team Sites has “Wiki Page Home Page” Site Feature activate by default. “Project Functionality” Feature is not active by default...

In article, We will see SharePoint Interview Questions and Answers which will helpful to understanding SharePoint concepts. Please refer this articles: SharePoint Interview Questions and Answers - Part One SharePoint Interview Questions and Answers - Part Two SharePoint Interview Questions and Answers - Part Three This is two part of SharePoint Interview Questions and Answers: 1  Difference between Rest API and JSON CSOM: 1. CSOM core assembly is Microsoft.SharePoint.Client.Runtime.dll and Microsoft.SharePoint.Client.dll, which stands for Client-Side Object Model. It is a web service based API of SharePoint. It allows access to SharePoint data and features from remote clients. CSOM was introduced in SharePoint 2010 and greatly enhanced in SharePoint 2013. 2. SP.ClientContext.get_current() for normal use. New SP.ClientContext('url...') for specific SPWeb. 3. Client-side object model. C# (or Visual Basic) only, use NuGet, at the moment same package for b...

In article, We will see SharePoint Interview Questions and Answers which will helpful to understanding SharePoint concepts. Please refer this articles: SharePoint Interview Questions and Answers - Part One SharePoint Interview Questions and Answers - Part Two SharePoint Interview Questions and Answers - Part Three This is one part of SharePoint Interview Questions and Answers: 1. What is SharePoint Site Hierarchy? ( reference link ) At the top of the hierarchy are server farms. This encompasses all the physical servers that comprise your SP installation. It may consist of one server or twenty. When you run the SP configuration wizard after installing MOSS/WSS you either create a new server farm or connect to an existing one. It’s done once. Once you have your server farm you must set up a web application. This is what creates a corresponding website in IIS to host the site. This is where it gets its application pool and other IIS properties. You can create multiple w...

In blog, we will see how we can get group list in which current user is member using JavaScript. Let's have example where we have few groups and we want to show current user is member of that group permissions or not. Below is JavaScript code to fetch groups of current user.  var  groups = [ 'Approve Users' ,  'Create Users' ,  'Review Users' ,  'Record Users' ,  'Initiate Users' ];   var  MemberOfGroup = "" ;   function  setUserGroups(groupName) {        if  (groupName ==  "Approve Users" ) {           MemberOfGroup +=  "Approve" ;       }  else   if  (groupName ==  "Create Users" ) {           MemberOfGroup +=  "|Create" ; ...