Category Archives: Microsoft Power Apps

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

D365 FO & PowerAPPS – Lookup From Data entities

Requirement – Connecting Microsoft Power Apps to Data Entity of Microsoft Dynamics 365 for finance and operations. Then create a lookup from Data entity.

Continue reading D365 FO & PowerAPPS – Lookup From Data entities