20+ Sharepoint Developer Interview Questions and Answers

Issues faced during migration of SharePoint 2010 sites to SharePoint online sites using sharegate tool

• Possible issues with metadata and content types

• Permissions and user mapping issues

• Custom solutions and workflows may not work

• Large amounts of data may cause performance issues

• Possible data loss or corruption

Workflow in Power Automate is a sequence of automated actions that can be triggered by an event in SharePoint Online.

• Workflows can be used to automate business processes, such as approval workflows or document review workflows.

• Power Automate provides a range of pre-built templates for common workflows, as well as the ability to create custom workflows.

• Workflows can be triggered by events such as when a new item is added to a SharePoint list or when a file is uploaded to a doc...read more

Canvas apps are custom apps with a drag-and-drop interface, while model-driven apps are based on pre-built data models.

• Canvas apps allow for more customization and flexibility in design

• Model-driven apps are better suited for complex data models and business processes

• Canvas apps are created using Power Apps Studio, while model-driven apps are created using Power Apps Maker

• Examples of canvas apps include expense trackers and event planners, while examples of model-driven apps i...read more

collect() and clearCollect() are functions in Power Apps used to add or replace data in a collection.

• collect() adds data to a collection or replaces existing data with new data.

• clearCollect() removes all data from a collection and replaces it with new data.

• Both functions are commonly used to manipulate data in a collection before sending it to a data source.

• Example: Collect(MyCollection, {Name: 'John', Age: 30}) adds a new record to MyCollection.

• Example: ClearCollect(MyCollec...read more

Master URL is the default URL for a SharePoint site while Custom URL is a user-defined URL.

• Master URL is used to access the default SharePoint site

• Custom URL is a user-defined URL that can be used to access a specific page or site within SharePoint

• Master URL is set by the SharePoint administrator while Custom URL can be set by any user with appropriate permissions

• Custom URL can be used to create a more user-friendly URL for a specific page or site

Site Collection is a group of SharePoint sites that share common settings, permissions, and features.

• Site Collection is a top-level site in SharePoint

• It can contain multiple subsites

• It has its own unique permissions, settings, and features

• It can be managed by a Site Collection Administrator

• Examples include: Team Site, Document Center, Publishing Site

Content type defines metadata and behavior for a particular type of content. Site content is the collection of all content types and lists in a site. List types are templates for creating lists.

• Content type: defines metadata and behavior for a particular type of content

• Site content: collection of all content types and lists in a site

• List types: templates for creating lists

• Example: Content type 'Article' can have metadata like author, published date, and behavior like approval...read more

The Rest API in SharePoint allows developers to interact with SharePoint data using standard web requests.

• REST stands for Representational State Transfer

• REST API uses HTTP requests to GET, POST, PUT, and DELETE data

• SharePoint REST API supports OData protocol for querying data

• REST API can be used with SharePoint Online and on-premises versions

• Example: GET request to retrieve all items from a SharePoint list: https:///_api/web/lists/getbytitle('ListName')/items

Delegation in Power Apps allows for efficient data retrieval by delegating some processing to the data source.

• Delegation is used to retrieve large amounts of data from a data source without overwhelming the app.

• It allows for filtering, sorting, and searching of data at the data source level.

• Common data sources that support delegation include SharePoint, SQL Server, and Dynamics 365.

• Delegation can be limited by the data source's capabilities and the specific functions used in ...read more

Patch function in Power Apps is used to modify or create a record in a data source.

• Patch function is used to update or create a record in a data source.

• It takes three parameters: the data source, the record to modify or create, and the changes to make.

• Example: Patch('MyDataSource', {ID: 1, Name: 'John'}, {Name: 'Jane'}) will update the name of the record with ID 1 from 'John' to 'Jane'.

Web Services in SharePoint are used to communicate with SharePoint from external applications.

• Web Services provide a standardized way to access SharePoint data and functionality.

• They use SOAP and REST protocols to communicate with SharePoint.

• Examples of SharePoint Web Services include the Lists, User Profile, and Search Web Services.

• Web Services can be used to perform CRUD operations on SharePoint data, retrieve data, and execute SharePoint workflows.

• Web Services can be acces...read more

A collection in Power Apps is a group of data that can be stored and manipulated together.

• Collections can be created from data sources such as SharePoint lists or Excel files.

• Data can be added, removed, or updated in a collection using functions like Collect, Remove, and Update.

• Collections can be used to display data in galleries or tables, or to perform calculations and filtering.

• Collections can also be used to pass data between screens or to other apps.

SharePoint is a web-based collaboration and document management platform by Microsoft.

• Allows users to create, manage and share content and applications

• Provides features like document libraries, lists, workflows, and search functionality

• Can be used for intranet portals, document management, and team collaboration

• Integrates with other Microsoft products like Office 365 and Teams

Add-ins in SharePoint are self-contained extensions that can be added to a SharePoint site to extend its functionality.

• Add-ins can be developed using web technologies like HTML, CSS, JavaScript, and can be hosted on a remote server.

• They can be used to add new features, integrate with external systems, and customize the user interface.

• Add-ins can be deployed to SharePoint Online or on-premises SharePoint.

• Examples of add-ins include web parts, custom actions, and remote event r...read more

Power Apps and Power Automate are low-code platforms that allow users to create custom business applications and automate workflows.

• Power Apps is a platform for building custom business applications without writing code.

• Power Automate is a platform for automating workflows across different applications and services.

• Power Apps and Power Automate can be used together to create end-to-end business solutions.

• Examples of Power Apps include custom forms, dashboards, and mobile apps...read more

CSOM stands for Client Side Object Model in SharePoint. It is a set of APIs that allows developers to interact with SharePoint from client-side applications.

• CSOM is used to perform CRUD (Create, Read, Update, Delete) operations on SharePoint data from client-side applications.

• CSOM can be used with .NET, JavaScript, and other programming languages.

• CSOM can be used to access SharePoint data from mobile devices and other non-Windows platforms.

• CSOM can be used to automate SharePo...read more

Error handling in Power Automate

• Use the 'Scope' action to group actions and handle errors within that scope

• Use the 'Terminate' action to stop the flow when an error occurs

• Use the 'Compose' action to create custom error messages

• Use the 'Condition' action to check for specific errors and take appropriate actions

• Use the 'Retry Policy' to automatically retry failed actions

• Use the 'Apply to each' action to handle errors in loops

• Use the 'Initialize variable' action to store error m...read more

Approval flows in Power Automate

• Approval flows allow for automated approval processes for tasks or documents

• Power Automate offers pre-built approval templates or custom approval flows can be created

• Approval flows can be triggered by specific events or conditions

• Approvers can approve or reject requests directly from email or mobile devices

Site permission refers to the level of access granted to users or groups for a specific site or subsite in SharePoint.

• Site permission can be set at the site level or at the list/library level within the site.

• There are three types of permission levels: Full Control, Design, and Read.

• Permission can be granted to individual users or groups of users.

• Permission can be inherited from parent sites or can be unique to a specific site or subsite.

• Site owners or administrators can manag...read more

Microsoft SharePoint is a web-based collaboration and document management platform.

• Allows teams to share and collaborate on documents and projects

• Provides a centralized location for storing and organizing files

• Offers customizable workflows and forms for business processes

• Integrates with other Microsoft products like Office and Teams

• Can be used for building websites and intranets

Scope in Power Automate refers to the level at which an action or set of actions will be performed.

• Scopes can be used to group actions together and apply conditions or exceptions to them.

• There are three types of scopes in Power Automate: Flow, Apply to Each, and Condition.

• Flow scope is used to apply conditions to the entire flow, while Apply to Each is used to apply actions to each item in a collection.

• Condition scope is used to apply actions based on a specific condition bei...read more