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”.
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.
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 – 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
Requirement :
In Microsoft Power Apps there are 2 collections – “Customer” & “CustomerAddress”.
“Customer” collection contain records where CustAccount is unique Key
| CustAccount | CustName | Gender | Mobile |
| CU-0000001 | David | M | 9876543210 |
| CU-0000002 | James | M | 9876543210 |
| CU-0000003 | Sophia | F | 9876543210 |
| CU-0000004 | Julie | F | 9876543210 |
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.
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.
Filter( Table, Formula1 [, 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.
LookUp( Table, Formula [, 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
Search( Table, SearchString, Column1 [, Column2, … ] )
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 & RemoveIfRequirement
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 DatasourceRequirement – 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