Power Apps Azure MIcrosoft 365


Microsoft 365 and Azure are powerful tools that can help improve the performance of any business. Microsoft 365 is a suite of productivity tools, while Azure is a cloud computing platform that can help businesses manage and store data. Together, they provide a powerful set of tools that can help businesses improve their efficiency, security, and collaboration.

One of the biggest benefits of using Microsoft 365 and Azure is improved productivity. Microsoft 365 includes tools such as Word, Excel, PowerPoint, and Teams, which can help employees work more efficiently and collaboratively. Azure provides businesses with a flexible and scalable cloud computing platform, which can help reduce IT costs while also providing access to a wide range of services.

Another major benefit of using Microsoft 365 and Azure is enhanced security. Microsoft 365 includes powerful security features, such as multi-factor authentication, data encryption, and advanced threat protection. Azure provides businesses with a secure and reliable cloud computing platform, which can help protect against data breaches and other security threats.

Finally, Microsoft 365 and Azure can help businesses stay competitive in an ever-changing market. By providing access to powerful productivity and cloud computing tools, businesses can become more agile and responsive to changes in the market. This can help them stay ahead of the competition and improve their bottom line.

In summary, Microsoft 365 and Azure are powerful tools that can help businesses improve their productivity, security, and competitiveness. By leveraging these tools, businesses can become more efficient, secure, and flexible, allowing them to better meet the needs of their customers and stakeholders.


Power Apps Azure MIcrosoft 365

Microsfot Power Apps

Microsoft Power Apps is a low-code platform that enables businesses to quickly build custom applications that can run on any device, web browser, or within Microsoft Teams. Power Apps are designed to work with a wide range of data sources, including Microsoft services such as Dynamics 365, Excel, and SharePoint.

In 2023, Power Apps have become an essential tool for businesses to automate and streamline various processes, such as workflows, data collection, and reporting. Here are a few actual uses of Microsoft Power Apps:

  1. Custom forms: Power Apps can be used to create custom forms for data collection, such as employee feedback, customer surveys, or event registration.
  2. Workflow automation: Power Apps can be used to automate tasks such as approvals, task assignments, and data entry. This helps businesses save time and reduces the risk of errors.
  3. Data analysis and reporting: Power Apps can connect to a wide range of data sources and can be used to create dashboards, reports, and charts. This provides businesses with real-time insights into their data and helps them make informed decisions.
  4. Mobile applications: Power Apps can be used to create mobile applications that can be used on smartphones and tablets. This makes it easier for businesses to access and manage their data on the go.
  5. Collaboration and communication: Power Apps can be used within Microsoft Teams to facilitate collaboration and communication between team members.

In conclusion, Microsoft Power Apps is a versatile platform that provides businesses with the tools to create custom applications that can help them streamline their processes, increase efficiency, and improve decision-making. With the growing demand for digital transformation, Power Apps is expected to continue playing a critical role in helping businesses achieve their goals in 2023 and beyond.

sharepoint migration

Migrating from Google Cloud to SharePoint can be a complex process that requires careful planning and execution. SharePoint provides a robust content management platform, but migrating data from Google Cloud to SharePoint requires a thorough understanding of the data, processes, and tools involved. To ensure a smooth migration, organizations must follow best practices to minimize disruption, ensure data integrity, and reduce the risk of data loss.

Plan the migration: A well-planned migration is the key to success. Start by defining the scope of the migration, identifying the data that needs to be migrated, and determining the timeline for the migration. Plan for contingencies such as unexpected downtime, system failures, and security risks.

Assess the current environment: Before migrating data from Google Cloud, assess the current environment to identify any potential issues that could arise during the migration. This includes analyzing the data structure, evaluating the customizations and configurations, and reviewing the access rights and permissions.

Choose the right tools: Choose the right migration tools that fit the organization’s needs. The tools should have the capability to transfer data accurately, preserve metadata, and handle complex customizations and configurations.

Test the migration: Before starting the migration, test the process to identify any potential issues and resolve them. Test migrations should include both a small-scale migration and a full-scale migration to verify that the process works as expected.

Communicate with stakeholders: Ensure that all stakeholders are aware of the migration process and the timeline. This includes communicating with users about the change and any impact on their work. It’s important to keep stakeholders informed throughout the migration process to ensure a smooth transition.

Monitor the migration: Monitoring the migration process is crucial to ensure that the migration is running smoothly and to identify any issues that may arise. Organizations should monitor the migration process to ensure that data is being transferred accurately and to ensure that the migration process is on track.

Document the migration: Document the migration process, including the tools used, the steps followed, and any issues encountered. This documentation will be useful for future migrations and for resolving any issues that may arise.

In conclusion, migrating from Google Cloud to SharePoint requires careful planning and execution. By following best practices, organizations can ensure a smooth migration, minimize disruption, and reduce the risk of data loss. Organizations should choose the right tools, communicate with stakeholders, monitor the migration process, and document the migration to ensure a successful outcome.

SharePoint Framework(SPFx) is a client side development framework that leverages CSOM, REST APIs, Microsoft Graph and more. Development is done through utilizing open source technologies like Node.js, Gulp, Yeoman, VSCode and more. It supports SharePoint Online and SharePoint 2016 (SP2)+ on-premise solutions.

Key benefits of using SPFx are

  1. It utilizes context of current user.
  2. It enables use any JavaScript Framework. React, Knockout, Angular etc
  3. Controls are responsive.
  4. Web parts can be used by both classic and modern pages

Previous models like JSLink and SP Add-in had their limitations. JSLink restricted scripts if not marked with “Safe for Scripting” and Add-ins were using IFrame model which are inefficient in modern websites.

Ready to try SPFx. Start with Hello World

As Microsoft SharePoint Roadmap suggests that future innovations will be cloud inspired, Companies who have invested in their On Premise versions are considering to go hybrid as the first step towards embracing Cloud. Using Hybrid Approach, Enterprises can continue to use their existing portal while gradually migrating it to Cloud.

Following capabilities can be achieved in hybrid implementation.
1. Hybrid Search
2. Hybrid Sites

a. Hybrid Profiles
b. One Drive for Business
c. Hybrid Extranet Sites

3. Hybrid BCS
4. Duet Enterprise Online
There are three ways to achieve hybrid implementations.

1. One-Way outbound Topology (SharePoint on-premises version can query SharePoint Online)
2. One-Way Inbound Topology (SharePoint Online can be connected to SharePoint On-Premises)
3. Two-Way bidirectional Topology (SharePoint On-premises and SharePoint Online can access each other functionalities)

In this blog, I will focus on Hybrid Search using One-Way Outbound topology.

Hybrid Search

Hybrid Search can be achieved using three steps.

  1. Directory Synchronization
  2. Server to Server Trust & Identity Management
  3. Search Service Integration

Directory Sync

Three Identity Models are available. We will focus on Synchronized identity for simplicity.

  1. Cloud Identity
  2. Synchronized Identity
  3. Federated Identity

In Synchronized Identity, Identities are managed in on-premises Active Directory and are synchronized to Azure AD through Azure AD Connect. Synchronization also sync password hashes.

Here is given the steps to achieve directory synchronization.

  1. Enable Directory Synchronization in you tenant (Office 365)
  2. Add On-Premise domain (user suffix) to Office 365 Tenant. (Domain Name should be publicly accessible for reverse sync)
  3. Update DNS Records (MX / TXT records) in your Domain Hosting Panel.
  4. Download and Run the User Sync from Tenant
  5. In Office 365, Import users / groups and validate.
  6. Activate Users and Assign Licenses.

Server to Server Trust & Identity Management

Trust between SP On-Premises and Office 365 tenant (Server to Server) can be established by following below steps.

1. Replace STS Certificate (All on-premises servers)

Set-SPSecurityTokenServiceConfig –ImportSigningCertificate

 2. Establish Remote Windows Power Shell Connection

Import-Module MSOnline –force –verbose
Import-Module MSOnlineExtended –force –verbose

3. Add Service Principal for on-premises domain

New-MsolServicePrincipalCredential –AppPrincipalId -Type asymmetric –Usage Verify –value
$SPOnlinePrincipal = Get-MsolServicePrincipal – AppPrincpalId $SPOnlineNameSpace = $SPOnlinePrincipal.ServicePrincipalNames
Set-MsolServicePrincipal –AppPrincipalId -ServicePrincipalNames $SPOnlineNameSpace

4. Establish On-Premise Farm Trust with ACS

$SPContextID = (Get-MsolCompanyInformation).ObjectID
Register-SPAppPrincipal –site -nameIdentifier <SPPrincipalID@SPContextID> -displayName “SharePoint Online”

5. Set Authentication Realm

Set-SPAuthenticationRealm –realm

6. Configure Proxy in On-premises farm

New-SPAzureAccessControlServiceApplicationProxy –Name “ACS” –MetaDataServiceEndPointUri “” –DefaultProxyGroup
New-SPTrustedSecurityTokenIssuer –MetadataEndpoint “” –IsTrustedBroker –Name “ACS”

Search Service Integration

Search Integration process is based on 3 parts.

1. Configure Result Source
Search Result Source can be configured in SharePoint on-premises by Adding Result Source in Site Collection Administration. Protocol should be chosen as Remote SharePoint. Credential should be chosen as Default Authentication. In case of Inbound, Select SSO ID.

2. Create Query Rule
You can filter when to trigger remote Query Processor by creating a Query Rule. Specific words can be added as triggers.
You can also specify where the result set should appear. By Default, all remote results come on top for easier identification. It can also be set to come in between complete result set.

3. Validate Query Rule
It’s an optional step to verify whether Query Rule has been configured properly and is returning correct result.

As discussed in last blog regarding UI consistency, Microsoft has recently released similar UI for document library in SharePoint Online that was in Office 365 – One Drive.

As I didn’t enable the Office 365 First Release, my SharePoint Online environment didn’t automatically had this feature available. In order to experience it, I enabled the Office 365 First Release Program. First Release enables the immediate adaption of new features as soon as they become available. On the contrary, standard release is received when entire Office 365 community receives it.



Once First Release Experience is enabled (I selected First Release – Entire Organization. You can also select First Release – Choose selected people), Document Libraries will automatically give you option for Check Out button.


Clicking on checkout will change your document library UI to Office 365 One Drive for Business UI that was rolled back in Oct 2015.


There are multiple enhancements done in new look. Here is a glimpse over those features & functionalities.


Breadcrumbs are designed intelligently. As you dive deep into folders, initial parent folders will be hidden in … and as you click on that, it will reveal the parent folder in modal dropdown view.


Submitted to Microsoft User Voice: Large folder names shall be either adjusted by giving higher weight age to last entry or to make folder name visible on breadcrumb hover (already submitted using Microsoft user voice).



Extended Navigation will be enable as soon as you make a selection. Different options will appear for single / multiple selection. Here are the key highlights for single file selection. On selecting a file and click on information icon (I) in top right, it generates a preview for known file type. You can browse through the document through this preview pane. Other attributes like Name, Title, Created By, Modified By, Version History, File Type, and Path will be displayed below preview pane in right section. Under sharing option, user can share the file directly by specifying the user or can share global read access link or global edit access link for selected file. Users can also get this link by clicking Get Link in top navigation.


Frequently accessed documents can be pinned by selecting Pin option in top navigation. It automatically generates the image of the document.

Submitted to Microsoft User Voice: When documents are pinned, it generates an automatic image which doesn’t always communicate the document essence effectively. If a user can attach a picture instead of automatic picture, this shall give a nice look and feel along with effective usability.



Using link feature, user can link a file from another SharePoint Online site or from One Drive and use this artifact along with its entire properties and workflows functionality. Link will automatically be security trimmed.



User can choose among list and grid views. Other custom changes to views are similar.


Here is one example of Group byCreated by


Views’ fields can be changed by clicking … on top right in list view. In order to do the same in grid view, first click on arrange that shall make the views’ field appear and then click on same … icon


Upload Folders

One of the great features is the functionality of recursive folder upload. It uploads folders, subfolder and their files.


Submitted to Microsoft User Voice: After folder upload using drag drop is completed, view does not refresh itself automatically to show uploaded folder.

Move-to and Copy-to

An intuitive way for Move to and Copy to has made it easier for users to copy / move the files among other folders.



Submitted to Microsoft User Voice: Move to and Copy to do not render if Group by in views is selected.

Switching Back to Classic

If for any reason (custom code / hard coded css fixes etc), you would like to switch back to classic version, you can go back by clicking to Switch to Classic View in bottom left of screen.



Overall, I am glad to see new features and functionality. It seems that Microsoft has taken end user perspective into consideration and finally presented with much needed User Interface and Features.

Following improvements / enhancements have been done in SharePoint 2016.

Hybrid Improvements

SharePoint 2016 allows you to integrate with Office 365 and gives a overall hybrid experience. Following capabilities are extended during hybrid implementations.

One Drive for Business

SharePoint 2016 App Launcher (One Drive) can be connected with Office 365 One Drive giving an integrated view of hybrid solution. This feature has been added in last release also i.e. SharePoint 2013 – SP1.

Single Sites View

Whether you are following the sites in Office 365 or SharePoint 2016, a single site view would show list of all followed sites in single view. SharePoint Hybrid Team Sites must be configured to utilize this feature.

Unified Search

SharePoint 2016 and Office 365 can now be integrated and can provide a unified search experience. User can also take the advantage of Delve and Office Graph to find contextual results.

Search Sensitive Information in Hybrid Search

Hybrid search can also search for sensitive information like credit card and other confidential information using DLP (Data Loss Prevention) policies.

You can implement DLP policies by creating an eDiscovery Center (site collection) and creating an eDiscovery case with in it (subsite). DLP Query can now be run on eDiscovery case to find all sensitive and personal data stored in a particular site.

Unified UI

SharePoint 2016 offers identical UI as of Office 365 so that users can navigate without any hassle of learning different UI experience. This also motivates users to get more familiar with Office 365 experience in general.

Performance, Scaling and Deployment

Search Scaling Capabilities

SharePoint 2016 search now supports up to double (500 million) items per Search Server Application than its predecessor SharePoint 2013 (250 million).

Site Collection Enhancement

SharePoint 2016 features a fast site collection creation. It can create site collection faster by saving the round trip between SharePoint and SQL Servers by using new templates at same location as SQL Server.

Each site collection can also now store 5 time more information than its predecessor (SharePoint 2013).

Deterministic View Threshold – Removing 5000 Limit

In earlier version, there has been a limit of 5000 items per view in List. You can increase the threshold limit however it will start to deteriorate the performance. Fix was to index the columns. For end users, this could be some time challenging. Hence Microsoft has added ‘Automatic Index Management’ to automate the process of creating indices so you can know take the advantage of large lists view without worrying of performance degradation.

Durable Links and Large Files Support

Durable Links enable all files stored in SharePoint to have a unique id. It requires Office Online Server (previously Office Web Apps 2013) to be configured. If user moves or renames the file, it attaches the unique document id as query parameter resulting in returning the actual file from new location / new name. For more Details, Durable Links

SharePoint 2016 supports uploading and downloading of large files (like Auto CAD files). Users can specify file size per web application. Though there is no restriction in file size limit, Microsoft recommends it to be at 10GB. This features specially helps file

In SharePoint 2016, file name length and special characters restriction have been removed.

Deployment Improvements

SharePoint 2016 offer following flexibility during installation.


In min role installation, you can specify specific role for server. Each server role has been optimized for its specific needs. Following roles are available with installation.

  1. Front End
  2. Application
  3. Distributed Cache
  4. Search
  5. Custom

Standalone installation has been replaced with Single Server Farm. Prior installation of SQL Server would be required as it’s not included in SQL Server Farm unlike Standalone installation.

Zero Downtime Patching

Using Zero Downtime patching in SharePoint 2016, SharePoint Administrator can now apply patches and cumulative updates without going offline. It works by distributing payload (patches, cumulative updates) in smaller chunks and installing specific chunks. All chunks must be in sequence to be installed. This greatly reduces the complexity of full patch being applied at once thus offering easier deployment with zero downtime. For more details, Zero Downtime Patching.

Upgrade Paths

SharePoint 2013 web applications can be upgraded to SharePoint 2016 by attaching SP 2013 database.

Upgrade paths from SharePoint 2010 to SharePoint 2016 are not available. Web applications must be in SharePoint 2013 mode.