Last week in Microsoft 365 – 19 Nov – 25 Nov 2020 – VLog 7

Subscribe to my YouTube Channel if this helped you , to appreciate my work and keep me motivated.

n this 7th video of the series I discuss following topics:

1. Adding OOTB/Default Modern SPFx webparts to classic pages – Ram Prasad…

2. Handle your errors in Power Automate – Matt Weston…

3. Open an HTML file from Power Apps and host it within your solution – Terho Antila…

4. Configure the List form…

5. New Bookings experience and capabilities help streamline scheduling – Jessica Wilczek…

#SharePoint #ListForms #PowerApps #PowerAutomate #MicrosoftBookings

YouTube Playlist

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog…

Last week in Microsoft 365 – 26 Nov – 02 Dec 2020 – VLog 8

Subscribe to my YouTube Channel if this helped you , to appreciate my work and keep me motivated.

In this video I talk about 5 topics

1. Launch of Festive Tech Calendar Follow Cloud Family and for new videos all December. there will be one video from my side as well…

2. Create single sign-on authentication for tab apps with Microsoft Teams Toolkit for Visual Studio Code… Teams Toolkit First look:…

3. Self-service Microsoft Form for external guests to use Power App – John Liu Great blog from John Liu for a practical situation that is adding a a guest user of Power App to Tenant…

4. 6 Power BI Reports for Microsoft Teams Call Quality Dashboard (CQD) – Tom Arbuthnot Nice description from Tom about Power BI reports from Teams Call Quality Dashboard…

5. Use the Page Diagnostics for SharePoint tool…

#Festivetechcalendar #SSO #MicrosoftTeams #Teams #Power App #Microsoft Form #Diagnostic Tool #Dashboard

YouTube Playlist

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog…

Last week in Microsoft 365 – 03 Dec – 09 Dec 2020 – VLog 9

Subscribe to my YouTube Channel if this helped you , to appreciate my work and keep me motivated.

In this video I discuss / highlight five topics related to Microsoft 365 from last week

1. Considerations for optimized performance in Power Apps A great article you should definitely read if you are going to create enterprise level Power Apps to understand what things to consider with respect to data source and connectors…

2. Power Platform Weekly Issue Newsletter: A great selection of articles and easy way to be updated on Power Platform topics. Go read it and also subscribe…

3. Speed up npm install – Sergei Sergeev Great discussion how to speed up npm install…

4. Power Apps Editable Excel like Table – Reza Dorrani As usual great video from Reza explaining how to create editable excel like or SharePoint Grid style table…

5. Azure Logic APP API Call Save a file to BLOB Storage – Gregor Suttie A great small blog from Gregor where he uses Logic App API call to csv file and store it in Blob storage, Link:

#LogicApps #PowerApps#npm #PowerPlatform #SharePoint #Microsoft365 #Microsoft

YouTube Playlist

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog…

Power Apps Simple Functionalities – Let’s Learn a Microsoft 365 Topic Vlog 7

If you like my video or the blog please subscribe to my YouTube channel to get me going

In this video we learn some simple Power Apps functionalities:

1. Get current user Manager : Scenario can be that you to display or send an email to current user manager, in this video I have added a Label in Canvas App and used following formula. To make this work your Canvas App should have Office365users as data source which you can learn in Video how to add. The Manager function takes either email or principal id, in this we have passed email by yet another function “User().Email”


2. Get current date week number : In lot of countries Week number is important, so there might be a requirement to display current date week number or selected date week number, to achieve this I had added another label in Canvas App and used following function

     (RoundUp (
          Now() - Date(
               Year(Now() - Weekday(Now() - 1) + 4),
     ) + Weekday(
               Year(Now() - Weekday(Now() - 1) + 4),
     ) + 5) / 7,

3. Set Drop Down choices in Power Apps with SharePoint List Choice column: When we add a drop down in Power App Canvas App we can hard code drop down choices but what if we want to have same choices we already have on SharePoint list column, to achieve this we can use “Choices” function but before that we should add SharePoint List as data source for the Canvas App which you can check in the video, once that is done, add a Drop Down and use below function. Here “PowerAppDataStore” is the list name and “City” is column name whose choice values will be displayed


4. Patch function – Drop down values in SharePoint : Since we added a drop down in above example we want to save data back to SharePoint on click of a button so how to do that, you can of course write a Power Automate but instead of that we can use “Patch” function which can save data back in SharePoint, in this example I have already a List “PowerAppDataStore” which has two columns “Title” and “City” which was already mapped to the drop down, so to use a button we can add it to Canvas App and then “OnSelect” property write below function, you can find more details in the video below

Here Patch takes 3 parameters, first is the source, second is record which is an item with defaults and 3rd values for each column which will be updated.

Patch(PowerAppDataStore,Defaults(PowerAppDataStore),{Title: "click here", City:Dropdown1.Selected})

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog…

SharePoint 2013 migration to Office 365 step by step – Strategy #SharePoint #Office365

This post is written as step 2 that is strategy. Step that is planning can be read here SharePoint 2013 migration to Office 365 step by step – Planning #SharePoint #Office365

Once we have filled in the excel template and also found out all issues via SharePoint Migration assessment Tool we need to formulate a strategy to find solution to issues and customizations.

As an outcome of the first step you should have a list of categorization of issues / customizations for which you need to strategize. I am listing down some if it, note that these are just examples and it totally depends on what you have done in your farm before and how much customizations have been done.


For more reading about above topics and in text format use below link to download an excel Customization / Issues Categorization

Note that any solution will be based on what kind of Office 365 license you have, whether your organization will have PowerApps or Flow or not? Also whether you will have SharePoint Add-in model in place or not

If you have any questions with specific customization solution you can ask in comment section and I will try my best to provide a solution to that.

After we define a strategy for customizations we need to find a strategy to migrate data from On-premise to Office 365. This will be our third step and we will define that in next post. Before we do data migration it’s important to list down how many Web Applications we have, size of Content Databases.

In case you need more help on this or other SharePoint issues please contact us via our Contact Us page or via our Facebook page or via Twitter

Like us on Facebook and follow us on Twitter


Microsoft PowerApps and Flow together #SharePoint #Office365 #Flow #PowerApps

Microsoft PoweApps and Flow can work together so let’s see an example and how they can be applied together.

We have already seen how to create an Microsoft Flow in another blog post Microsoft Flow – Create from blank and also how to create a simple PowerApp in this blog PowerApps first look! Create a simple PowerApp .

Process of attaching a Flow with PowerApps is a bit different, creating a flow is kind of same as before, you can create a Flow from blank but this time you can do it from PowerApps URL , look for Flows in left menu and create a Flow with option “Create from blank”. Since we have already dealt with this topic, I have already created a Flow just remember that Flow should be created from PowerApps site else it will not show up.

Here are some screen shots how you need to do, we are using the ApproveClaim list we created in earlier post and idea is to create a PowerApp to add item using the Flow.

Create MS Flow from Blank in PowerApps

Enter Flow name and Click New step

Add an action, what we will do to allow user to make entry in list item

Select the trigger that is SharePoint – Create item

Enter SharePoint URL and select the List name, After that al fields will show up, click in the text box and in Advanced section select “Ask in PowerApps”

After selection it’s done and click Create Flow

Once Saved Flow will be visible in Flow section

Once the Flow is created, we will start creating the PowerApp, since we want to Add a Flow to PowerApp we need to use Visual Studio on Windows and not the web version. Option to add Flow is not available in web version.

So go the Studio, Click New and create App from Blank with Phone Layout.


Once selected open canvas will be opened and using Insert tab Add three TextInput and button as well    onselect

Now we can add the Flow, select the button and in Action tab select “Flows”, it will show the available Flows. Select the Flow and add for this button


Once added it will be shown as below, note that we have to add 3 Textboxes as we have 3 inputs in our Flow. Most important is that we need to enter formula for OnSelect event for the button, basically we need to enter 3 parameters for the Run method which are our text boxes and property is Text.


Once done Save the PowerApp with proper name in The Cloud. It will be available on web under Apps section


Now you can run it and input the text fields and click button, this will save the item to the List ApproveClaim


So that’s it in this post we have seen how we can create a Flow and associate it in a PowerApp. Our example is quite simple we use the Flow to create an item but you can understand how easily it can satisfy different business needs to implement various bussiness logic.




PowerApps first look! Create a simple PowerApp

PowerApps is a new feature to create Apps quickly and with limited efforts. In this simple example I am going to create an App based on a custom list of SharePoint. List is as below


Idea is to create an App for users to approve or reject claims logged by users, so we have a simple list which stores description and amount. In the App Approver has option to reject or approve claims.

Now in new version of SharePoint Online User Interface you have the option to create an PowerApp from the list so we will use that. Click on PowerApps and Create an app. Pick a name for the App, we have chosen ClaimApp.

createpowerapp powerappname

Once you click create, App creation will start a new window of browser will open. Note that now PowerApps can be created using browser based studio. Widows studio is still available which we will look later in other blog post.

This will create the basic App and show you in the web studio of PowerApp as below.


The studio has different elements on top, right and left. First you will see the Browsescreen1 in which elements can be selected. As you can see I have selected an element which is visible on right side.


You can take away elements as we have taken away all except Claims title, there are other screens for Edit as well which can be selected from left side. Here is a screen shot for Detail Screen and Edit Screen

detailscreen editscreen

As you can see all the useful screens are already created. This can be published as is to work for end users. The other options of the studio will be discussed in another post. Now let’s see it in action.

You can do a preview by using F5 or play button at top right. You can save the App from File menu and then run it from List view option


Click open and the App will open in a new tab.

appscreen viewappscreen EditScreenPowerApp.PNG

PowerApps can be downloaded to mobiles and Windows 10 laptops. Once downloaded it works as a mobile App. The main PowerApps mobile App will show all available Apps for your organization and you can download to run required ones


Once downloaded it will work the same way as it was working the same way on web.

So this was a glimpse of PowerApps and how easy it is to create an App. Next we will explore studio more and perform customization.