Interview QnA

  1. Date: 24 July 2021
    1. What are the differences you feel when working on SharePoint On-Premise and then on SharePoint Online?
      1. Share your experience.
    2. How Authentication and Authorization works in SharePoint Online?


      2. You can add multifactor authentication in SharePoint Online
      3. SharePoint Online - O365: Set up Multi-Factor Authentication
    3. What type of complexities that lead you to go with SPFx?
      1. You may define complexities that you faced while providing the solution and based on that, you took decision to go for SPFx solution.
    4. Any idea about migrations?
      1. You may describe the migrations you have done so far.
    5. How to implement governance policy in SharePoint Online? (like- retention policies, expiration policies and other stuff)
      1. SharePoint Governance is a set of policies that define processes, roles, rules and regulations for user interaction with SharePoint in your organization. SharePoint Governance applies to everyone, no matter of their company role or title or SharePoint permission/level of access.
      2. A typical governance plan includes-
        1. Site Architecture
        2. Security
        3. Navigation
        4. Look & Feel
        5. Taxonomy & Metadata
        6. Retention & Deletion
        7. 3rd Party Tools Integration
        8. One Drive For Business
        9. Employee Trainings
        10. Help Desk
      3. For further reading, please visit Microsoft portal Planning intranet governance.
    6. While provisioning a site, I want to have some custom lists to be there and some site columns. (means by default when a new site is created I need by default some custom lists must be there)?
      1. The same can be done using PnP PowerShell.
    7. What is the decisive factors to choose which version you will choose to create a site if client doesn't have any knowledge?
      1. It depends upon various factors-
        1. Existing environment
        2. Budget
        3. Site usage
        4. Site complexity
        5. Maintenance & support activities
        6. Customization
        7. Future enhancements
    8. What are best practices during customizing / coding in SharePoint?
      1. These are-
        1. Code reusability (HTML, CSS, JS)
        2. Code optimization
        3. Use minified version of CSS & JS
        4. Data distribution
    9. Let's suppose a SharePoint library has 1L items. How do you handle it in SharePoint application.
      1. One way could be pagination.
    10. What are Hub sites and what is their use?
      1. SharePoint hub sites help the organization to meet the needs by connecting and organizing sites based on project, department, division, region, etc. making it easier to-
        1. Discover related content such as news and other site activities
        2. Apply common navigation, branding, and site structure across associated sites
        3. Search across all associated sites

    11. What is the difference between classic and modern sites?
      1. TBD
    12. How do you decide that data should be saved where (SharePoint / DataVerse / SQL . . .)?
      1. TBD
    13. A user doesn't have access to upload document. But still your application needs to have this functionality. how do you achieve?
      1. By using-
        1. Elevated Privileges (Server Side Code)
        2. Impersonation Steps (Designer Workflow)
        3. Parent-Child Workflows (Microsoft Power Automate)
    14. An app you created starts performing slowly as the time goes. How do you resolve?
      1. Check, if there any-
        1. Cache problem
        2. Data load
        3. Code review
    15. Data in SharePoint list becomes now 10000+ and the app starts performing slow. How do you resolve?
      1. If app starts performing  slow due to data size, we will check, if data is getting fetched on every screen from data source? If yes, then, we will review code to load all data on App Start.
      2. We will check the possibility to implement pagination.
    16. Any governance policy for PowerApps you had implemented, any custom securities?
      1. Share your experience.
    17. Any idea about Environment maker?
      1. TBD
    18. How do you add Custom button in Approval process?
      1. By using "Custom Responses - Wait for all responses" / "Custom Responses - Wait for one response".

    19. How do you perform error handling in Power Automate?
      1. Using Scope action. Put all performing actions in one scope action and name it TRY.
      2. Add another scope action after above and name it CATCH. Put all those actions which need to perform if performing actions get failed due to any reason. Now click on ellipses (...) of this scope action and then click on Configure run after. It will show the action as below. Choose on what status this CATCH action should run.
      3.   
    20. Any idea about Power BI?
      1. Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports.
      2. Power BI Desktop App - is used to create reports.
      3. Power BI Services (Software as a Service - SaaS) - is used to publish the reports.
      4. Power BI Mobile App - is used to view the reports and dashboards.
    21. How do you generate reports on SharePoint usage, activities and similar kind of stuff report?
      1. Tenant admin has the access to perform this activity at Tenant Admin Center.
  2. Date: 21 Jul 2021
    1. How to add rows dynamically in PowerApps New Form? (Here interviewer wants to know about the repeater control in PowerApps)
      1. By default there is no such functionality in PowerApps. But YES, we can achieve this functionality by creating our own repeater control using Gallery control. For this, please read below articles-
        1. PowerApps: Create Repeater Control Part-1
        2. PowerApps: Create Repeater Control Part-2
    2. Which PowerApps is considered as responsive (RWD)?
      1. By default Model driven app and Portals are responsive in nature. While Canvas app is by default non responsive. We can make Canvas app to responsive by following below steps. These steps to be followed when creating new app-
        1. Click on File >> Settings. Below screen will popup-


        3. Choose Display and scroll down the right panel.
        4. By default the status of-
          1.  "Scale to fit" is set as On
          2. "Lock aspect ratio" is set as On.
          3. "Lock orientation" is set as Off.
        5. Make all these as Off.
        6. Now open the screen and set Height & Width as follow:-
          1. Width = Max(App.Width, App.DesignWidth)

          2. Height = Max(App.Height, App.DesignHeight)
        7. Next, avoid absolute dimensions for controls. Always use dynamic formula for controls dimension like - Parent.Width, Parent.Width/2.
        8. This way the Canvas app will also become responsive. 
          1. Read more on Create responsive layouts in canvas apps.
        9. Another way to create responsive apps is by the user of Containers.
          1. Read more details on Building responsive canvas apps.
    3. What is the limitation of data volume in PowerApps and is there any way to over come it?
      1. By default it is 500 which can be extended up to 2000.
      2. Custom code can be written using Iteration, Sequence, ForAll to get all items from data source. Read below articles-
        1. PowerApps: Getting More Than 2000 Items (Using Sequence)
        2. Getting More Than 2000 Items In PowerApps
    4. What types of connectors are there in PowerApps?
      1. Data is stored in a data source, and you bring that data into your app by creating a connection. The connection uses a specific connector to talk to the data source.
      2. Power Apps has connectors for many popular services and on-premises data sources, including SharePoint, SQL Server, Office 365, Salesforce, and Twitter.
      3. A connector may provide tables of data or actions. Some connectors provide only tables, some provide only actions, and some provide both. Also your connector may be either a standard or custom connector.
      4. Connectors in PowerApps are used to connect with data source whether Online or On-Premise. Some of them are SharePoint, SQL, Oracle, Excel.
      5. Overview of connectors for canvas apps
      6. List of all Power Apps connectors
      7. Some of the available connectors in PowerApps are-
        1. SharePoint
        2. SQL Server
        3. Oracle Database
        4. MySQL
    5. A blank excel is placed on OneDrive. Can it be accessible in Power Automate?
      1. Yes. Excel placed on OneDrive is accessible in user's context. But it should have at least one table because Power Automate reads the table from Excel.
    6. An excel having 10 rows is placed on OneDrive. Can we access this data in Power Automate?
      1. Yes. Excel placed on OneDrive is accessible in user's context. But the data should be present in the form of table because Power Automate reads the table from Excel.
    7. How to convert SharePoint Designer Workflow into Power Automate?
      1. There is no known way to convert SharePoint Designer workflows into Power Automate till date. We have to rewrite the process in Power Automate.
    8. What types of Connector/Action are there in Power Automate?
      1. Some of them are-
        1. Approvals
        2. Power BI
        3. Power Apps for Makers
        4. Power Apps for Admins
      2. Connector reference overview
    9. What is the difference between "Start and wait for approval" & simple "Approvals" action in Power Automate?
      1. "Approvals" is a connector while "Start and wait for approval" is an action in that connector.
    10. Where are the properties/configurations of SPFx webpart are saved?
      1. The WebPart properties are saved in the page column named "CanvasContent1".
      2. This column is an array that has an entry for each WebPart on the page.
      3. Each array entry is a JSON string that has all the information about WebPart, the WebPart properties are in the object called "webpartdata" in the "properties" object.
      4. READ AND UPDATE SPFX WEBPART PROPERTIES FROM CODE
      5. Properties are saved by the framework using the REST endpoint-  /_api/sitepages/pages(number)/SavePage.
    11. I don't want to use SharePoint default feature of likes/comments? Is there a way to manage my own custom likes and comments?
      1. For this, you have write your own custom code by creating custom lists to save the likes / comments. If you wish to add reply feature on comments as well, then either you have to create another list for replies or you can manage the same in comments list by adding one more column named "ParentID" where you can save the item id of the comment upon which the reply was made.
    12. How to handle SYNC/ASYNC calls in REST API?
      1. By default all REST API calls are asynchronous in nature.
      2. We can use ".then" to make them synchronous. See below example-
      3. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js" ></script>
<h1>Training Announcements</h1><br/>
<div id="result"></div>
<script>
	jQuery().ready(function () 
	{
		var fullUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('TrainingAnnouncements')/items?$select=ID,Title";
		getItems(fullUrl).then(getItemsSuccess, getItemsFail);
	})
	
	function getItems(url)
	{
		return $.ajax(
		{
			url: url,
			type: "GET",
			headers: {
			"accept": "application/json;odata=verbose",
			}
		});
	}
	
	function getItemsSuccess(data)
	{
		var fullresult="";
		if(data.d.results.length > 0)
		{
			var results = data.d.results;
			for (var i = 0; i < results.length; i++)
			{
				fullresult+=results[i].Title +'<br><br>';
			}
			jQuery('#result').html(fullresult);
		}
		else
		{
			jQuery('#result').text("No Data");
		}
	}
	function getItemsFail(err)
	{
		alert("Some error occurred !!!");
	}
</script>
    13. How to do authentication in REST API?
      1. HTTP Authentication Schemes (Basic and Bearer)
      2. API Keys
      3. OAuth (2.0)
      4. OpenID Connect
      5. OpenAPI Security
    14. I have ReadOnly access on a list. A custom page is built to insert items in that list. I managed to get access of that page and tried to insert the data from this page. What will happen upon click of Submit button?
      1. The data will not inserted. An error of status 401 will occur.
      2. If the user not having access to list (not even read access) then, error of status 404 will return and the response Text will give message "List <list name> does not exist at site with URL <site url>".
      3. Code to submit the data using REST API-
      4. function PostDataInSP(listName)
{
	$.ajax(
    {
    	url: _spPageContextInfo.siteAbsoluteUrl+ "/_api/web/lists/getbytitle('" + listName + "')/items",
        type: "POST",
        async: false, 
  		
  		data: JSON.stringify(
  		{
  			 '__metadata': {
  			  'type': 'SP.Data.' + listName + 'ListItem'
  			 },
   			'Title': 'Test From REST'
  		}),
		headers: 
		{
		   "Accept": "application/json;odata=verbose",
		   "Content-Type":"application/json;odata=verbose",  
			"X-RequestDigest": $("#__REQUESTDIGEST").val()
		},
        success: function (data) 
        {
			alert('Item Saved Successfully');
		},
        error: function(data)
        {
        	alert('Item Failed To Save');
         }
    });
}
    15. In above case, is there any way to control it?
      1. Before submitting the request to insert the record, you may check the permissions assigned to that user.
      2. Reference to the below code, you need to execute GetUserPermissions(listName) function.
      3. function GetUserPermissions(listName)
{

	var webUrl = _spPageContextInfo.webAbsoluteUrl;  
	getListUserEffectivePermissions(webUrl, listName, 'i:0#.f|membership|<userEmailID>').done(
		function(data)
		{
			var roles = parseBasePermissions(data);
			console.log(roles); 
		}
	);
}

function getListUserEffectivePermissions(webUrl,listTitle, accountName) 
{
	var endpointUrl = webUrl +  "/_api/web/lists/getbytitle('" + listTitle + "')/getusereffectivepermissions(@u)?@u='" + encodeURIComponent(accountName) + "'";
	return $.getJSON(endpointUrl);
}

function parseBasePermissions(value)
{
	var permissions = new SP.BasePermissions();
	permissions.initPropertiesFromJson(value);
	var permLevels = [];
	for(var permLevelName in SP.PermissionKind.prototype)
	{
		if (SP.PermissionKind.hasOwnProperty(permLevelName))
		{
			var permLevel = SP.PermissionKind.parse(permLevelName);
			if(permissions.has(permLevel))
			{
				permLevels.push(permLevelName);
			}
		}     
	}
	return permLevels;   
}

      4. A typical list of access-
    16. Any other authentication mechanism in REST API for above case?
      1. Explore yourself
    17. What are the steps to be taken care of before migration?
      1. Share your experiences.
    18. Why use Minimal Download Strategy (MDS)?
      1. Minimal Download Strategy (MDS) is a new technology in SharePoint that reduces the amount of data that the browser has to download when users navigate from one page to another in a SharePoint site. When users browse an MDS-enabled site, the client processes only the differences (or delta) between the current page and the requested page.
    19. I have multiple libraries in SharePoint Site. I want to restrict user to have access on site except a particular library. On that library, the user will have Full Control but rest all the site should be non accessible. How do we achieve this?
      1. Steps for particular library are-
        1. Stop Inheriting Permissions
        2. Give Unique Permissions
      2. For Site permissions-
        1. Give Limited/Restricted Access
    20. In classic site, how can I add the modern page?
      1. In SharePoint Site (in Classic Mode)-
        1. Go to Site Pages
        2. Click on Files tab
        3. Click on New Document
        4. Click on Site Page
        5. This way you can add Modern Page in SharePoint site (Classic Mode)
      2. How to Create a Modern Page (on a Classic SharePoint Site)
    21. How do identify the SharePoint Site be a classic site or modern site?
      1. If Classic Mode, then you will get a link "Exit classic experience" at bottom left corner on Site Pages section.
      2. If Modern Mode, then you will get a link "Return to classic SharePoint" at bottom left corner on Site Pages section.
  3. Date: 29 Jun 2021
    1. What is difference between On-Premise and Online?
      1. The main difference between SharePoint On-Premise and Online is their installation and maintenance.
      2. For On-Premise, you need to install everything in your premise. You need to have servers. Your IT team will take care of installation, updates, patches.
      3. For Online, everything resides at Microsoft cloud means Microsoft datacenters. The installation, updates, patches and all the maintenance is taken care of by Microsoft.
      4. For On-Premise, it takes time to scale up the configuration as the hardware associated with it needs to procure.
      5. For Online, scale up/down is quite easy as SharePoint is subscription based. You may just go to Admin Center and change the configuration. Within next couple of moments, the same will get applied and the same will get included in subscription billing cycle.
      6. For On-Premise, at a point of time, you need to migrate your solution to the upgraded version of SharePoint.
      7. For Online, there is no need of migration.
      8. For On-Premise, you can build and use custom solutions as well as server side object model code.
      9. For Online, server side object model code is not supported. You need to rebuild the same using client side object model using SPFx.
      10. For On-Premise, there needs some downtime to apply updates and patches.
      11. For Online the SLA is 99.9% means almost no downtime.
      12. For On-Premise, the speed of your SharePoint sites depends upon your local infrastructure.
      13. For Online, the speed depends upon the global network of data centers.
      14. For On-Premise, if the user base of sites increases, you need to procure additional servers.
      15. For Online, you need to just take licenses for those additional servers.
      16. Season increase of traffic can be handled easily in Online as compared to On-Premise. 
    2. How many Site Templates in SharePoint Online?
      1. Classic Template
      2. Modern Template
    3. What is the major difference between Classic template and Modern template?
      1. The major difference between the two is that Classic template allows developer to customize the page using SharePoint designer while Modern template does not.
      2. In Classic template, we can create our own Master pages, while in Modern template we can't.
      3. Webparts are different in both templates.
      4. We cannot add scripting in Modern template sites. However we can create SPFx to solve this issue.
      5. Export to Excel is available only in the classic experience for document libraries (and only in Internet Explorer). However, it is available in the modern experience for lists (in Internet Explorer and Edge only).
      6. Click here to read "Differences between modern and classic experiences for lists and libraries"
      7. Read more on "Decide Between Classic SharePoint And Modern SharePoint"
    4. What are Content Types in SharePoint?
      1. Content types is basically a collection of columns that might be Site columns or custom columns to share similar kind of information between list/libraries. Content types enable you to manage the settings for a category of information in a centralized, reusable way.
    5. What is Term Store in SharePoint?
      1. It is part of SharePoint where mostly we store information, can be of multiple types. To avoid the complexity of Lookup type of column we use Term Store. Scope is tenant.
    6. Difference between SharePoint designer workflows and Power Automate?
      1. Sr. No. SharePoint Designer Workflow Power Automate / Microsoft Flow
        1 You need developer knowledge to develop workflows using SharePoint Designer for list or libraries. You don't need developer knowledge to create and use Power Automate in SharePoint Online.
        2 All actions available in SharePoint Designer are specifically for SharePoint only. Power Automate is not particular to SharePoint, you can connect to various services like Twitter, Dropbox, OneDrive, Facebook, Slack, Instagram etc.
        3 SharePoint Designer Workflows does not provide any predefined template to use. Power Automate provides predefined templates to use. Either you can use the template or you can create a flow from scratch.
        4 SharePoint Designer Workflow can be edited by anyone who has the owner rights. By default Power Automate is visible / editable by the owner of that flow. You have to specify Co-Owner to other users so that they can also modify the flow.
        5 SharePoint Designer Workflows does not provide any functionality for Scheduler workflows. We have to write Timer Jobs for that purpose. Power Automate provide Scheduled Flows to create schedulers.
    7. What is Trigger?
      1. It's a programmatic approach and event driven (insert, update, merge, delete).
      2. Trigger works before and after some actions.
      3. Trigger works across all the objects.
      4. You can create a new record through trigger which is not possible through workflow.
      5. To perform some activity upon trigger, we need to code.
    8. If some data has been deleted, then how can we recover it from SharePoint?
      1. By default deleted data goes in Recycle Bin.
      2. After retention time of 30 days ,it will move to next stage of Recycle Bin. 
      3. After that it can be still recovered with the help of Microsoft.
    9. How can we create Edit type of view or which template we use to create a View to show data in editable grid format?
      1. Datasheet View
    10. Explain Check-In / Check-Out functionality?
      1. Check-Out: It is a feature to reserve a object for yourself when you want to be the only one using it. In terms of SharePoint, it would be for editing. For example: in library book, a book can be termed as Check-Out when we borrow as get assigned on our name for reading.
      2. Check-In: It is a feature to release an object for others to use it. In terms of SharePoint, you had edited the file/code and want the changes to be made available to others for use.
    11. Can we do some customization in Modern Template Site?
      1. Below customizations are supported:
        1. Apply a custom theme or change the logo.
        2. Apply an out-of-the-box theme.
        3. Create custom site columns (fields) and content types.
        4. Create lists and libraries.
        5. Configure site settings, such as regional settings, languages, and auditing settings.
        6. Use SharePoint Framework (SPFx) to modify user experience in the sites by providing client-side web parts or including other user interface elements with SharePoint Framework Extensions.
      2. For further details read Customizing "modern" team sites.
  4. Date: 18 Jun 2021
    1. What is the delegation in PowerApps?
      1. Delegation is a process to transfer its job to other one. For example, if we want to get some filtered data, then rather than bringing all data into PowerApps and applying filter upon it, it's better to ask the data source to filter the data based on the criteria passed and return the filtered data. This way we achieve 2 important things-
        1. The amount of data transfer over the internet is reduced which leads to reduction of failure of request.
        2. The PowerApps remain light in terms of data.
    2. What is the limitation of number of controls we can use in PowerApps Canvas App?
      1. 500
    3.  What are the types of variables in PowerApps?
      1. Local
      2. Global
    4. How can we initialize variables in PowerApps?
      1. Local variable are initialized using UpdateContext command.
      2. Global variable are initialized using Set command.
    5. What is Collection?
      1. Collection is a group of items or an Array
    6. How can we parse the collection values in PowerApps?
      1. No Idea. Might be using JSON function
    7. How many type of flows can be created in Power Automate?
      1. Automated cloud flow
      2. Instant cloud flow
      3. Scheduled cloud flow
      4. Desktop flow
      5. Business process flow
    8. Can we add custom button in Approval workflow apart from Approve/Reject?
      1. This can be done using Approval Type as Custom Responses in Automated cloud flow (Start and wait for approval).
    9. What is component framework in PowerApps?
      1. Power Apps component framework empowers professional developers and app makers to create code components for model-driven and canvas apps. These code components can be used to enhance the user experience for users working with data on forms, views, dashboards, and canvas app screens. For example:-
        1. Replace a column on a form that displays a numeric text value with a dial or slider code component.
        2. Transform a list into an entirely different visual experience bound to the dataset, like a Calendar or Map.
        3. Power Apps component framework works only on Unified Interface and not on the legacy web client.
        4. Power Apps component framework is currently not supported for On-Premises environments.
      2. Power Apps component framework overview 
    10. Any idea about HTTP request?
      1. HTTP request can be handled using HTTP Actions in Power Apps.
    11. What is the SharePoint hierarchy model?
      1. Farm
      2. Web Application
      3. Site Collection
      4. Site
      5. List / Libraries
    12. What is the default class inherited for TimerJob?
      1. SPJobDefinition
    13. What is impersonation in SharePoint?
      1. Impersonation can basically provide the functionality of executing something in the context of a different identity.
      2. Impersonation Step is used in SharePoint Designer workflow and it generally means running workflow steps with elevated privileges where the current user won't have permission to do any action by workflow.
      3. When an impersonation Step is created and published, the workflows will be run on with person who created it.
      4. Only in an impersonation Step, the impersonation workflow activities can be used.
      5. To add an impersonation Step in workflow, follow below steps:
        1. In SharePoint Designer ribbon go to "Workflow" and click "Impersonation Step".


        3. Now we can add the workflow activities in the impersonation Step.


        5. Using the impersonation Step we can add or remove permissions to anyone for the current item.
    14. What is the concept of Abstract in SharePoint 2013?
      1. Please help if someone has any idea about it.
    15. In Power Automate, some user has no access to SharePoint list but we want to get his/her item update in list. How?
      1. Power Automate runs only in Owner's Context.
      2. Another option can be if we some how grant access to list using power automate to update the item and then revoke.
    16. How to filter the records based on text box?
      1. Add filter condition in Items property of Gallery Control.
    17. Can we call a nested Power Automate?
      1. Yes, using HTTP request.
      2. Another option using Button flows
    18. How to handle exception in Power Automate?
      1. Using Scope.
    19. How to create repeater control in PowerApps?
      1. PowerApps: Create Repeater Control Part-1
      2. PowerApps: Create Repeater Control Part-2
    20. What is ContentType in SharePoint?
      1. A content type is a reusable collection of metadata (columns), workflow, behavior, and other settings for a category of items or documents in a Microsoft SharePoint.
      2. Content types enable you to manage the settings for a category of information in a centralized, reusable way.
    21. Can we customize the Master Page in SharePoint?
      1. Yes
    22. How can we create Master Page in SharePoint 2013?
      1. Create an HTML
      2. Add in SharePoint
      3. Then Using DesignManager, convert it to Master Page.
    23. Custom Page Layout in SharePoint?
      1. Create A Custom Master Page In HTML For SharePoint Online
      2. Create A Custom Page Layout For SharePoint Online
      3. Using WebPartZones
    24. What method type is used to insert an item in SharePoint list using REST API?
      1. POST
    25. What is Form Digest in REST API?
      1. Access token to authenticate the request. 
    26. What is Event Receiver?
      1. An event receiver is basically used to handle the events. It is like a method that is triggered when an action occurs on a specified SharePoint object. Triggering actions have some activities including,
        1. Adding
        2. Updating
        3. Deleting
        4. Moving
        5. Checking In
        6. Checking Out
      2. Event receivers are of 2 types-
        1. Synchronous
        2. Asynchronous
    27. While migrating SharePoint site, will the URLs mentioned on page gets updated?
      1. URLs doesn't get update.
      2. Need to update manually.
    28. By default how many records we can fetch in PowerApps?
      1. 500 which can be extended up to 2000.
    29. Any idea about Dataverse?
      1. Dataverse is a secure, cloud-based storage space that organizations can use to store business application data. It uses Azure Active Directory identity and access management mechanisms to help ensure that only authorized users can access the environment, data, and reports.
      2. Dataverse works with any type of data relational or non-relational data, it can work with files, images, or data lake, and connecting to other services that contain the data for your business.
      3. The data within Dataverse is stored within a set of tables. A table is a set of records that used to store data, each table consists of some columns.
      4. Read more on Microsoft Dataverse.
  5. Date: 15 May 2021
    1. Is Power Automate available in On-Premise?
      1. Power Automate is a public cloud service only. However, you can securely connect to your own on-premises services through the on-premises data gateway.
    2. Can we connect REST API through Power Automate?
      1. You can connect to any REST API that uses JSON and supports at least one of more than 10 authentication methods by creating a custom connector.
    3. Can we connect through SQL Server / On-Premise data source through Power Automate?
      1. You can connect to services on your local network using the on-premises data gateway.
    4. Can we migrate a flow from dev environment to production environment?
      1. Yes, using Export/Import option. It exports in ZIP format, which then can be imported in Production environment and set the account connections. 
    5. How to change the ownership of flow if user has left the organization and the account is now inactive and there is no co-ownership on that flow?
      1. Through Admin account. Such type of workflows are called Orphan Workflows.
        1. How to manage orphan flows when the owner leaves the organization
        2. Managing orphaned flows through Flow Admin Center-
          1. How to check if there are orphaned flows-
            1. Please note that only privileged users can view flows that do not have any valid owners.
            2. On the environment page from Flow Admin Center (https://admin.flow.microsoft.com/environments), go to "Resources" tab and then open the "Flow" list. Orphaned flows display "None" as their owner. 
            3. Click "Load more" to load the next set of flows so as to ensure you have looked through all flows that might be orphaned.
          2. Assign new co-owner(s) to an orphaned flow-
            1. From the flow list, click on the orphaned flow to open the flow details page.
            2. Click "Manage sharing" at the bottom of the Owners list.
            3. Type in a new owner name and select the new owner account.
            4. Click "Save" to save the changes.
    6. What is the difference between UI Flow and MS Flow?
      1. UI Flows-
        1. UI flows brings Robotic Process Automation (RPA) capabilities to Power Automate. You can use UI flows to automate repetitive tasks in Windows and Web applications. UI flows records and plays back user interface actions (clicks, keyboard input, etc.)
        2. More details on How To Create UI Flows - Power Automate
    7. Can we do Parallel Wait actions using Power Automate?
      1. Yes we can do.
    8. Can we wait for an activity to get complete using Power Automate?
      1. Yes we can using Delay and Delay Until.
    9. Where do data of like and comments stored in Modern site?
      1. The destination is not known right now but data can be accessed using REST API as below-
        1. Working with the Page Comments REST API in SharePoint Communication sites
        2. Getting likes and comments from modern pages
        3. Accessing SharePoint modern page Likes & Comments using Power Automate
    10. How to change the threshold limit of list in SharePoint Online?
      1. No it cannot be modified.
    11. How to change the scope of search box?
      1. Using PowerShell we can achieve this-
        1. Possible Values:-
          1. For Tenant it's value is 1
          2. For Hub it's value is 2
          3. For Site it's value is 3
          4. For Default Behavior it's value is 0
        2. Configure modern search results to search all of your organization (rather than the current site)
        3. SharePoint Online: Change Default Search Scope from "Search This Site" to "Search All Sites"
    12. By default which column is indexed in SharePoint list?
      1. By default no column is indexed. However, we can create maximum up to 20 indices on any list.

      2.  


    13. Can we add lookup column in Indexing (SharePoint list)?
      1. Yes we can.
      2. Supported Columns are-
        1. Title (but not in a document library)
        2. Single line of text
        3. Choice field (but not multi choice)
        4. Number
        5. Currency
        6. Date/ Time
        7. Lookup (but not multi value)
        8. Person or Group (but not multi value)
    14. Can we reference a lookup column from site collection to a sub site?
      1. No OOTB feature.
      2. Custom workarounds can be done to achieve this.
    15. What is the difference between classic page and modern page?
      1. Difference Between Modern SharePoint and Classic SharePoint UI Design
    16. What us the difference between document.ready and window.onload?
      1. window.onload fires after document.ready
      2. $(document).ready() method gets called as soon as the DOM is ready (which means that the browser has parsed the HTML and built the DOM tree). This allows you to run code as soon as the document is ready to be manipulated.
      3. window.onload fires when the entire page loads (images, styles, etc.).
      4. We can have more than one $(document).ready() function, we can only have one onload function.
  6. Miscellaneous Others-
    1. Power Automate FAQs-
      1. Power Automate: Frequently Asked Questions
    2. What are the difference between SharePoint Online and SharePoint On-Premise?
      1. There are lots of difference between SharePoint Online and SharePoint On-Premise version-
      2. In SharePoint On-Premise, the server will be maintained by the organization itself, but in case of SharePoint online, everything will be maintained by Microsoft, organization just need to use.
      3. In SharePoint Online, patches and updates will be taken care by Microsoft, but in On-Premise environment, everything will be taken care by IT team of the organization. 
      4. In SharePoint Online, Microsoft does not allows organization to deploy any server side code but we can develop and deploy solutions using server object model in On-Premise environment.
      5. Alternatively Microsoft has improved client side object model and we can develop and deploy SharePoint Add-ins using client object model.
    3. What are SharePoint Add-ins? Is It same as SharePoint Apps?
      1. According to MSDN definition-
        1. A SharePoint Add-in is a self-contained piece of functionality that extends the capabilities of SharePoint websites to solve a well-defined business problem. We can develop pages, lists, workflows, custom content types, list templates, Web Parts etc. in SharePoint Add-in.
        2. These are nothing but the Apps which has been introduced in SharePoint Online and SharePoint 2013 versions. Microsoft later renamed Apps to Add-in.
    4. Can we create Web Applications in SharePoint Online?
      1. No we can't create a new "Web Application" in SharePoint Online. We can create a new Site collection only (using SharePoint Admin). It can be either under /sites or /teams path only.
      2. There is only one "Web Application" and it is named as https://tenantname.sharepoint.com. It is also the root site collection.
    5. Can we add Custom Domain in Office 365 SharePoint Online?
      1. Yes we can add Custom Domain in Office 365 SharePoint Online. We can go to Office 365 Admin Center and click on +Add a domain in the Domains section.
    6. What is the difference between Common Data Model (CDM) and Common Data Service (CDS) / Dataverse?
      1. Common Data Model: The Common Data Model standard defines a common language for business entities covering, over time, the full range of business processes across sales, services, marketing, operations, finance, talent, and commerce and for the Customer, People, and Product entities at the core of a company’s business processes. The goal of CDM is to enable data and application interoperability spanning multiple channels, service implementations, and vendors. CDM provides self-describing data (structurally and semantically), enabling applications to easily read and understand the data.
      2. Common Data Service / Dataverse: Common Data Service lets you securely store and manage data that’s used by business applications. Data within Common Data Service is stored within a set of tables. A table is a set of rows used to store data, similar to how a table stores data within a database. Common Data Service includes a base set of standard entities that cover typical scenarios, but you can also create custom entities specific to your organization and populate them with data using Power Query. App makers can then use PowerApps to build rich applications using this data.
      3. In simple words, if you want to build a new environment of CDS, then it would build based on the CDM schema, and supply you with some of those standard Tables and relationships defined in the CDM Schema, but the actual data etc would be provisioned or managed by the Service…CDS.
    7. What are the limitations in Power Automate?
      1. Read article Limits for automated, scheduled, and instant flows.
    8. What is a Site column?
      1. A site column is a reusable column definition, or template, that one can assign to multiple lists across multiple SharePoint sites.
      2. Site columns are useful if an organization wants to establish some consistent settings across lists and libraries.
    9. What is Authentication and Authorization?
      1. Authentication: Who are you?
      2. Authorization: What you can do?