One great thing about Microsoft Power apps is you don't have to write complicated application code, the way that a traditional developer does. Instead, you can use the tools Microsoft Power apps provides to express logic in an app and control its navigation, filtering, sorting and other functionality. This is where formulas come in, if you've used Microsoft excel functions, you'll be comfortable building apps in power apps. To create a formula, you will combine one or more functions with the required and optional parameters. Here are some common functions and an explanation of what they do. Filter, this function is often used with galleries or tables of data to narrow down the rows returned from your data source. You do this by specifying one or more columns in your data set to perform a logic test on, which will allow you to return data that falls in a certain date range, has a set value or is created by the user for example. Match, this function allows you to check a value to see if it follows a given pattern. You can use this to check if the user entered a properly formatted email address and if they did not, show them a warning that a valid email is required. This function serves well for conditional formatting. Distinct, this function allows you to return the unique values from a list of data, making it easier to build dynamic dropdowns that show users only the valid values for the given column and math functions. Power apps include a range of math formulas for working with your data, from the simple such as sum or average to the complex such as a team and signed to work with radiance. This is a small sampling of a large library of power apps functions that are available. Also, remember you can combine functions into one formula to solve complex problems, this is the power of the platform. You start with simple formulas and then as your comfort grows, you learn to combine them. For a complete list of all the functions available in Power apps or to learn more about using formulas, please see the additional resources at the end of this lesson. Now that you've created an app, you can share it with specific users, groups or your whole organization. When you share an app with other people, they can run it in a Browser or in the players for Apple IOS and Google Android. Even better, you can give someone permission to update the app, sharing your app is your final step as an app creator. You will want to share the app to test a full functionality with some stakeholders. This will give them a chance to provide feedback and help you become a better app creator. Let's take a look at how to do this, to share an app in Microsoft Power apps, open the app that you want to share in edit mode and complete the following steps. In Power app studio, select the file menu and then click save as, from the save as location options, select the cloud, save to Power apps, then click save in the bottom right corner. Once the app has successfully saved click share, in the share window, you can specify the users or groups with whom you want to share the app. You can add everyone in your organization by typing everyone in the search field and then selecting everyone in company name. If you need to share your app with a large group of users, it is best practice to share through an Azure active directory security group. By default, users will be granted a standard user permission which only allows them to view and use the app, want the user to also be able to edit the app, then select the co owner checkbox. Co owners will have the ability to use, edit and share the app but cannot delete or change the owner. To notify users of their permissions by email, leave the send an email invitation to new users checkbox selected. If you select this option, everyone you share the app with will receive an email with a link to the app. Those users that you granted co owner permission for the app, will also receive a link to edit the app in power app studio. If you make and save changes to a shared app the people you shared it with will see the changes as soon as you publish them. This can be useful if you improve or update the app, but it can also negatively affect users if you remove or significantly changed features. Remember to create a notification plan for alerting your users of major updates. Once you confirm who you want to share the app with, just click share in the bottom right of the window and that's it. An important consideration when planning to share your app is whether to create security groups. If you share an app with a security group, existing members of that group and anyone who joins it will have the permission that you specify for that group. Anyone who leaves the group, loses that permission unless they belong to a different group that has access or if you give them permission as an individual. Every member of the security group has the same permission for an app as the overall group does. However, you can specify greater permissions for one or more members of that group to allow them greater access. For example, you can give security group A permission to run an app, but you can also give user B who belongs to that group co owner permission. Every member of the security group can run the app, but only user B can edit it. If you give security group A co owner permission and user B permission to run the app, user B can still edit the app. It is important to be aware of some basic information about permissions and licensing when considering sharing your app. Users and contributors need permissions to any data connections and gateways that are shared app users. Some permissions come implicitly with the app, but you must explicitly grant others. If you create an app based on Microsoft data verse, you must also ensure that the users with whom you share the app have the appropriate permissions for the table or tables on which the Apple lies. Specifically, those users must belong to a security role that can perform tasks such as creating, reading, writing and deleting relevant rows. In many cases, you'll want to create one or more custom security roles with the exact permissions that users need to run the app. You can then assign a role to each user as appropriate, sharing an app is simple and it's a great way to make an app that you find useful available to people across your organization.
