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 http://johnliu.net/blog/2020/11/self-…
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 https://tomtalks.blog/2020/02/6-power…
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 https://powerapps.microsoft.com/de-de…
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 https://www.ppweekly.com/issues/power…
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
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.
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.
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
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 https://web.powerapps.com/ , 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.
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
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 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.
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
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.
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.