Category Archives: Microsoft Power Apps

Convert Power Apps Portal Into A Progressive Web Apps (PWA) : Introduction & Demo

What is Progressive Web App (PWA) ?

PWA is a web app that is optimized to run “like an app” on a mobile device .They look & feel like a Native App and also appear to be a like a native app that you would install from your device’s app store, but actually work within a standard browser. From a development perspective, if you know how to create a web application using HTML, CSS and JavaScript (and now Power Apps portals) you can use these same building blocks to build a mobile application. Twitter, Uber, Pinterest, Tinder, and Google Maps are just some examples of large companies that have embraced PWAs.

What are the benefits of Progressive Web App ?

  • Fast loading and works offline
  • Can be launched from home screen and receive the push notification
  • Junk free scrolling, Smooth Animations, and seamless navigation even on poor networks
  • No app store needed. Users can discover and download apps right from the web, making PWAs more accessible.
  • Run on all devices: website, web app, mobile, desktop

Power Apps Portal as a Progressive Web App (PWA)

You can enable progressive web app (PWA) in Microsoft Power apps portal.

  • You can also customize PWA and can also change offline behaviour.A PWA can be configured to continue to run on a mobile device when connectivity is lost or put in an offline mod
  • Once your PWA customization will be completed, you can create or generate an app package and distribute in Google Play store or Microsoft Store. To create app package, select Create app package under App package in Progressive web app in portals Studio. You’ll be taken to PWA builder where you can create app package for various app stores such as Microsoft Windows Store and Google Play Android Store and step-by-step document to publish app in respective store. You can now publish app in respective app store console.

Resource –

https://powerapps.microsoft.com/en-us/blog/power-apps-portals-as-mobile-apps-preview/

Enable & Disable ControlS In Power Apps

Hello Friends ,

Making a Controls (for example Text Controls, Text input, Label, Button, Dropdown Etc..) enable or disable on some conditions are very common requirement in Microsoft Power Apps.

In my example, I have a text box Control in canvas App of Microsoft Power Apps and 2 Button i.e. “Enable” & “Disable”.

Restore a previous version In Power Apps

Activities, activity, back, history, previous, version, versions icon -  Download on Iconfinder

Introduction –

When i started working in Microsoft Power Apps I started to feel that I am missing source control integration with GIT or VSTS/Devops. But then i realized that Microsoft Power apps is focused on helping people build apps without code or less-code. It means that source control Integration with git or VSTS Or Azure DEVOps are not part of those near-term plans and was never a part of plan from Microsoft side,

But good thing is that you can always restore a Microsoft Power app to a previous version that was saved to the cloud from your Power Apps account.

POWER APPS – Aggregate functions [Average, Max, Min, StdevP, Sum, and VarP]

Microsoft PowerApps – What You Need To Know - Empower IT Solutions

Aggregate Functions In Microsoft Power Apps –

Syntax is FunctionName(Collection Or DataSource Or Table, ColumnName)

Average function – Calculates the average, or arithmetic mean

Max function -finds the maximum value.

Min function -finds the minimum value.

Sum function -calculates the sum of its arguments.

StdevP -function calculates the standard deviation of its arguments.

VarP -function calculates the variance of its arguments.

Introduction To Microsoft Dataverse & Differences From CDS

Screenshot showing overview of Microsoft Power Platform.

Introduction – In November 2020, Microsoft renamed or rebranded Common Data Service as Dataverse. This is not first time, Microsoft is renaming and rebranding any product. For example – Microsoft Flow was rebranded as Microsoft power Automate. Dataverse (formerly knows as Common Data Service Or just CDS) allows securely store and mange data that can be used in Power Platform Products like Power Apps or other business apps.

Continue reading Introduction To Microsoft Dataverse & Differences From CDS

SQL Join In Power Apps

Power Apps Archives - Applied Information Sciences

Requirement :

In Microsoft Power Apps there are 2 collections – “Customer” & “CustomerAddress”.

“Customer” collection contain records where CustAccount is unique Key

CustAccountCustNameGenderMobile
CU-0000001DavidM9876543210
CU-0000002JamesM9876543210
CU-0000003SophiaF9876543210
CU-0000004JulieF9876543210

Try, Catch, and Finally In Microsoft Power Automate/Microsoft Flow | Error Handling Using Scope

Error handling and TRY, CATCH, AND FINALLY are very important tasks in Programing as well in any kind of development & Microsoft Power Automate or Microsoft Flow is no different.

Error handling and TRY, CATCH, AND FINALLY can be easily implemented in MICROSOFT POWER AUTOMATE/MICROSOFT FLOW for handling different different business scenarios.

Power Apps : Filter VS Search VS LookUp functions

Power apps : Understanding What it is and why to use it? – Microsoft  Dynamics CRM/365 by Vishal Grade

Filter function in Microsoft POWER APPS : The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records that match one or more criteria and to discard those that don’t.

FilterTableFormula1 [, Formula2, … ] )

Lookup  function in Microsoft POWER APPS :The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria.

LookUpTableFormula [, ReductionFormula ] )

Search  function in Microsoft POWER APPS :The Search function finds records in a table that contain a string in one of their columns. The string may occur anywhere within the column

SearchTableSearchStringColumn1 [, Column2, … ] )

Power Apps Functions – Remove & RemoveIf

There are functions available for deleting or removing records from datasource or table in Microsoft Power Apps.

Remove Function – Use the Remove function to remove & delete a specific record or records from a data source in Microsoft Power Apps.

RemoveIf Function- Use the RemoveIf function to remove & delete a record or records based on a condition or a set of conditions in Microsoft Power Apps.

Continue reading Power Apps Functions – Remove & RemoveIf

Power Apps ForAll:Copy & Insert Records from One Datasource To Another Datasource

Requirement

Copying & Inserting Records from One Datasource To Another Datasource in Microsoft Power Apps using ForALL & PATCH

Scenario

We have 2 datasources or tables. First datasource “List” is excel & second datasource is a CDS entity “Contacts”. We want to insert or copy records from “List” to CDS entity “Contacts”

Continue reading Power Apps ForAll:Copy & Insert Records from One Datasource To Another Datasource