Open in Desktop App is not working in Office 365

Problem You obtain the OneDrive link, SharePoint link, Teams files, or Open in desktop app in Office online. You said that the Word/PowerPoint/Excel is opening. But nothing happens Causes This problem happens because set default type or a link type is not registered in the Windows. Solution The solution is quite simple. Make sure your Office is signed in with your one or more Office account such as Office 365 or Microsoft Account. Open word, excel, and your PowerPoint. File – Option – Advanced – Link Handling. You should make sure that Open Supported Hyperlinks is checked Open Add & Remove Apps, find your Office installation file – Modify – Quick Repair That's it, hope it helps your problem. Please let me know if it is not working in your side. medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299";

Office Store not available fix

Problem You want to use some add-ins in Microsoft Office. You click insert Get-Add in and you get information that show. Based on the information it is shown that the Office Store is not available because the organization. You want to access the Office Store but is not available. You need to solve the problem as soon as possible. When you access the Insert – Get Add In menu you get this errot  Office Store not available     Solution This article will guide you the by step to eliminate the problem Office Store is not available. Ask your administrator of your Office 365 to activate the Office store in the Admin Portal. You can do that by following these steps: 1) visit portal.office.com 2) access the admin portal at https://admin.microsoft.com/ 3) visit Settings, Organization Settings, and User Owned apps and services 4) make sure the checklist lets user check access the office is active medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299"; Allow your office to trust Office Store. You can do that by following 1) File tab 2) Options Menu 3) Trust Center Menu 4) Trust Center Settings 5) make sure you uncheck all the options there Try to sign out your account and sign in your account again. Try to visit the Office Store and if you still find the issues, go to the next steps If the problems persist, you can do this extra steps. 1) go to the control panel 2) add remove program 3) Program features 4) look for Microsoft 365 Apps xx-xx 5) click change 6) click online repair That's it hope it will help you to recover from the office store not available solution. medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299";

Call Graph API in PowerApps

Requirements We build PowerApps for the internal organization through the Canvas Model. And we need to read some useful information from the Graph API for user properties. Solution You have multiple way to read the User on The Office 365. Use the User function. If you just need email and name you can use this. You can read the detail here Use the Office365User. If you need access more data such as Photo, Manager, hire date, and many more. You can read the detail here Use the Graph API. If you need access to active directory data. You can read the detail here Limitation medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299"; When call graph API or read user information you need to understand the limitation: There is some field in v2 cannot be updated through Office 365 profile, such as hire date, etc. Therefore, you need to store and read through your PowerApps. Many functions are read only, you cannot save the new value. When you need, history of your update you need to save the record for your Application into SharePoint List or Excel. medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299";

On-premise Backup, is it still relevant in the cloud era?

Backup in the cloud? In the cloud era, we have technically unlimited storage to store anything. From personal photos in OneDrive, business document in OneDrive for Business, or event collaboration artifact in Team files or SharePoint. Today, we put more in the cloud but put less in our on-premise location. The good story is when your connection is working well and your sync engine (OneDrive client) work well as expected. Let us see what the benefit of the cloud backup "technically" unlimited storage. You can request from 1 GB to Petabytes if you want. Backing up to the cloud means you no need to worry about space issues High availability by design. By default, you will find that the storage will be replicated at least three copies in Azure Storage. And if you need more, you can add more geographical backup. Flexibility backup. You can have premium backup on high performance SSD OR if you need cost-effective you can go to standard hard drive with 7200 rpm. However, we have some challenges when we do a cloud backup The speed of the backup is related with your speed network. There might be some inefficiency when unstable network happens, such as reupload etc. In the cloud era data is generated from the cloud so there is no backup from the cloud to the on-premise. All the data is belonging to the cloud. The backup complexity. Imagine you have data from the cloud, and you have data from the on-premise. There should be synchronize each other to provide efficient backup medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299"; The relevancy of the on-premise backup Just imagine your organization have some collaboration work to do and each people stored the collaboration file on a Teams. On Teams, you can click Sync button and it will sync to your account. But imagine, if you are the organization and want to backup the entire teams, SharePoint, or even Azure VM. How you can do that? This is where the on-premise backup still relevant tin the cloud era. In the organization mindset all the document assets are owned by the organization. The question is how we backup the cloud to our on-premise solution? NAS come to the rescue! Whether you have PaaS, IaaS, and SaaS. You can download the files, virtual machine images, and document to your computer. But how if you need to backup the entire documents from your Teams Files? Or SharePoint Site? YES, You can use NAS (network attached storage) to do that. The NAS solution today is not like the old-day NAS solution who just plugged into your network and backup. Modern NAS such as Synology and others have a cool feature regarding with the cloud. Some of the key features are: Backup your legacy VM from Amazon AWS and Microsoft Azure Backup your organization files with Active Backup for Microsoft 365 and G-Suite VM recovery or Web App recovery for your web app solution On-premise Backup, is it still relevant in the cloud era? So the answer of this question is yes! We still need on-Premise Backup for our organization, cloud can work better to provide high availability with the on-premise solution like NAS. Having NAS will become a good investment for the organization. They can enjoy the default benefit of NAS such as files sharing and local backup. Plus, some modern NAS like DS920+, DS720+, DS420+, and DS220+ can have additional features such as: Virtual Machine Manager. Virtual Machine Manager helps you to run VM in the NAS platform. As IT administrator. I face challenges to make my co-worker run their experiment in the cloud because the bottleneck of our organization internet connectivity. By using VMM, I can put my VM Image to NAS and when my co-worker the VM, I can give him the VM access and the VM is run on top of NAS. They don't need to access the internet. You can learn VMM here Active Backup for SaaS solution. If your organization have a lot of intellectual assets in the cloud such as Office 365 you can easily backup with Active Backup for Business. You can learn this free solution here. Hyper Backup for your PaaS and IaaS solution. If your organization has an Azure or AWS you can setup the recovery point and storage to NAS to provide quick backup-restore experience. You can learn the hyper backup solution here. In the next post, we will do a simple experiment about NAS and SaaS (Microsoft 365). Happy weekend everyone   medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299";

Microsoft To Do Keep Crashing

Yesterday, my Microsoft To Do keep crashing every time I opened it. I done several times uninstall and install procedure, but the app keeps crashing. If you have similar problem, this workaround might work for you. This is my configuration of my work machine Windows 10 (Build 2004) Microsoft To Do Office 365 Account Plan E3 I am logging in with Microsoft Office 365. medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299"; The Root Cause After trying some configuration, the root cause of this crash is: Login with Office 365 Activating the Flagged Email The Possible Solution If you have similar problem here are the possible solution that you can do. Uninstalling and Installing Yes, this is the first thing that you can do. Simply uninstall by right clicking uninstall in the application icon. Disabling the flagged email feature Logging in https://todo.microsoft.com/tasks/ with your Microsoft 365 / Microsoft Account Go to "To Do" Setting Set Flagged Email Off and Planner Off Remove or delete the current list on planner and flagged email if any Try to log in with your Microsoft To do App. You can reactivate the setting if you need the integration. That's it, hope it helps! medianet_width = "600"; medianet_height = "250"; medianet_crid = "858385152"; medianet_versionId = "3111299";

Five Power Apps Limitation That You Need to Know

The idea of low codes development platform Coding looks cool, but it hard for some people. Understanding object oriented, scripting, compiling, software architecture, testing and design patterns will be overwhelming for some people. Thanks to Low codes development technology that helps you create app that work in with less coding. There are so many apps out there such as Power Apps, Phone Gaps. Today we will discuss why the Power Apps limitation that you might need to know before you dig down to the Power Platform #1 To Tight with Office 365 Platform If you want to build an app for your organization that already use Office 365, the Power Apps is for you. But when you need to build for your end customer with various technology and platform. The Power Apps might be not your choice. It needs Office 365 license, Office 365 account with Power Apps Free License. Yes, Power Apps provides you Power Apps portal for external users. And we will discuss it in another post. For now, the tightly coupling with Office 365 platforms is a benefit but challenging for external user. // #2 Pricing model The pricing model is too high for small business. Power Apps is not cost efficiency solution if you do not have Office 365. It will take 40$ / user / month if you need unlimited app version. Just imagine how it will take If you want to deploy for 100 users. Fortunately, there is a free plan for Office 365 users and there is community development plan for Power Apps #3 The App Editor The Power Apps integrated development environment is running on the web. Although, it gives you benefit by eliminating specific hardware and installation. It lacks the developer 'feel'. You can try by yourself by visiting the https://make.powerapps.com/ or the canvas version in https://create.powerapps.com/. Yes. It is confusing sometime! That is why I called a limitation #4 You Need Mastering the Excel Style The low codes mean you still need to code. The Power Apps codes work just like Excel Script or DAX in Power BI. If you already know how to create =SUM() script in Excel, it means you have the basic. However, the PowerApps codes will be challenging for some people who already know the object oriented or markup model. Can you guess what the codes are doing in this Power Apps Codes? Launch("https://bing.com/search", { q: "Power Apps", format: "rss" }, LaunchTarget.Self)   #5 Tablet or Phone, You Do not Have Both! If you want to create an app that can work in multiple device orientation and size, the Power Apps need you to create two applications. The first one is a tablet layout and the second one is the phone version. If you want to provide better experience you need to create the most used version (phone / tablet) or both. Fortunately, you can still use the phone version in your Windows 10 version. You have other limitations come on your mind? Please share on the comments below. If you want to see the goodness of PowerApps you can visit this links.   //

How to Manage Microsoft Teams with PowerShell

As a developer, sometimes we need to configure our environment before we create codes that use the capability of the existing platform. The same thing was done in Office 365, before using the Graph API for example. We need to do a set of configurations to ensure that the code we are going to build can already access the resources that are permitted through the configuration. This article will discuss generic steps on how to configure Microsoft Teams with Power Shell. Step 1 – Run the PowerShell Run a Power Shell in your Windows, you can run with your current user (recommended). I don't recommend you to run with Administrator since a lot of configuration is only works with current user privilege. Visit this page of you don't have PowerShell Step 2 – Installation module You can install module by using several model install-Module, Import-Module. On our case we have two module that we need to install. Microsoft Teams for managing interactivity and Skype for Business for managing the admin configuration. Microsoft Teams Module https://www.powershellgallery.com/packages/MicrosoftTeams/1.0.6 Skype Module https://docs.microsoft.com/en-us/SkypeForBusiness/set-up-your-computer-for-windows-powershell/download-and-install-the-skype-for-business-online-connector // Step 3 – Login with Admin Credential Create a new session by creating New-CSOnlineSession. You will need to input your credential and Office 365 password. Step 4 – Set Policy for Remote Signed You need to activate the remote signed environment in order to change configuration remotely. You can do that by using Set-ExecutionPolicy and choose RemoteSigned. Step 5 – Importing Session You can start your configuration by joining a login session that you already made. You can do that by using Import-PSSession Step 6 – It's time to Configure Yes, we can configure the Teams right know. You can see a lot configuration on Microsoft Teams - https://docs.microsoft.com/en-us/MicrosoftTeams/teams-powershell-overview Enjoy your day!   //

Webinar: Creating Teams for Education to Manage Virtual Classroom

In the era of COVID 19, we need a way to continue our education process without leaving our home. With the limitation of our mobility, virtual classroom can be used to deliver learning process both synchronous and asynchronous. On this 30 minutes webinar, we discuss how to create Teams for Education to facilitate digital classroom. This recorded webinar focused on creating and starting virtual classroom, managing assessment, and additional support.   //

OneNote and OneNote 2016, which one is better?

In the last year, Microsoft discontinued the OneNote 2016. Microsoft replaces it with OneNote App that can be installed through Microsoft Store. According some review Microsoft OneNote app still lag behind with the OneNote 2016. Therefore, Microsoft still provide OneNote 2016 as a free software. Today we will compare the OneNote vs OneNote 2016, so you can keep which one that suite with your need. // OneNote OneNote 2016 Free Through Store Download through Microsoft Download Portal Updated Regularly No update Best for Pen (rich pen experience) Best for Typing (rich formatting) Small footprint (55 MB) Casual footprint (86 MB) Sharing is limited Support export to word, and others Opening only through link Open through link, OneNote file, and OneNote Package Best Office 365 integration Best of Desktop productivity Can be uninstalled standalone through store Cannot be uninstalled standalone through control panel       You Need OneNote 2016 if You are using export feature to Microsoft Word You are using OneNote package import You are using OneNote to style your document with icon, to do task, and others You need OneNote App If You are using OneNote in your mobile app, it's similar experience You are using your active pen or your s-pen You need an updated OneNote So which one you want to choose? Please insert into a comment //

Office 365 Development Scenario

in the previous post, I discussed about the choice for the developer to develop in the top of Office 365 platform. Today I will discuss about what kind of scenario and proper technology that you can use to build proper scenario for your customer. // Single Sign on Scenario This is the most useful scenario. Office 365 works as a cloud identity provider. You can register your office 365 tenant in Azure Active Directory. It works as your identity provider. Learn more about SSO scenario here Accessing the Data from Office 365 Platform After you authenticate the user, you can obtain the data from the Office 365 platform. This can be done by registering an application as Azure App and give the proper permission. You can learn in through here Interacting with the Document This can be done through Add-In model. The Add-In model works with Word, PowerPoint, Excel, and many Office 365 desktop application. You can learn here Designing for Instant Collaboration This can be done by creating application in Teams. You can create app integration, bots, and massaging integration. You can learn here Designing for Portal Collaboration Of you want to create a portal based solution, you can use SharePoint to develop platform based application. You can learn here //