20+ Farmson Pharmaceutical Interview Questions and Answers

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

Sub-sites are child sites created under a parent site while hub sites are top-level sites that connect and organize related sites.

• Sub-sites inherit permissions and settings from their parent site

• Hub sites allow for consistent branding and navigation across related sites

• Sub-sites can be used for specific projects or teams while hub sites can be used for departments or divisions

• Hub sites can aggregate content from associated sites

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

CSOM is client-side object model used for remote access while SSOM is server-side object model used for local access.

• CSOM is used for remote access to SharePoint objects while SSOM is used for local access.

• CSOM uses REST API to communicate with SharePoint while SSOM uses .NET framework.

• CSOM is lightweight and can be used in any platform while SSOM requires SharePoint server installed.

• Examples of CSOM are JavaScript, .NET, and Java while examples of SSOM are PowerShell and C#....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

Content type is a reusable collection of metadata and settings that can be applied to a list or library to standardize data.

• Content types define metadata and behaviors for items in a list or library

• They can be inherited or created from scratch

• Examples include Document, Image, and Announcement content types

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

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

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'.

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

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.

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

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

SharePoint Online is cloud-based while SharePoint On-Premise is installed on local servers.

• SharePoint Online is managed by Microsoft while SharePoint On-Premise is managed by the organization.

• SharePoint Online has limited customization options while SharePoint On-Premise allows for more customization.

• SharePoint Online has a subscription-based pricing model while SharePoint On-Premise has a one-time licensing fee.

• SharePoint Online has automatic updates while SharePoint On-Prem...read more

SharePoint hosted in SharePoint Online is a type of hosting model where the SharePoint site is hosted on the same web server as the SharePoint website.

• SharePoint hosted apps are installed on a SharePoint site and are hosted within the same domain as the site

• They are built using HTML, CSS, and JavaScript and are deployed to SharePoint Online

• They can access SharePoint data using client-side object model (CSOM) or REST APIs

• They are limited to using client-side technologies and c...read more

Yes, web applications can be created in SharePoint Online.

• Web applications can be created using SharePoint Online's web application templates.

• These templates include options for team sites, communication sites, and publishing sites.

• Web applications can also be customized using SharePoint Designer or Visual Studio.

• SharePoint Online also supports the creation of custom web parts and apps.

Sandbox solution is a code solution that runs in a restricted environment in SharePoint.

• Sandbox solutions are used to prevent custom code from affecting the overall SharePoint environment.

• They are deployed to a specific site collection and have limited access to resources.

• Sandbox solutions can be developed using Visual Studio and can include web parts, event receivers, and workflows.

• Examples of sandbox solutions include custom branding and site templates.

• Sandbox solutions are...read more

Lists and libraries are two types of data storage in SharePoint. Lists store data in rows and columns, while libraries store files.

• Lists are used to store structured data, such as contacts, tasks, or calendar events.

• Libraries are used to store files, such as documents, images, or videos.

• Both lists and libraries can be customized with columns, views, and workflows.

• Examples of lists include a task list, a calendar list, or a custom list.

• Examples of libraries include a document ...read more