What Is PowerApps

PowerApps is the collections of apps, services, connectors and different data platform which provides rapid application development environment to build a custom apps.

Using this PowerApps we can build custom business apps as per our business requirements.
These PowerApps custom application support the different online and on-premise data sources like (Excel, Office 365Share Point, dynamics 365, SQL Server etc).
Using this PowerApps application we can transform our manual business processes to digital , automated processes.

These PowerApps can run easily on browser and mobile devices.
It’s a new feature to build a business apps without coding.
It’s also provides a platform to developers to interact with data and metadata.

using PowerApps we can create three types of apps:
1. canvas :  Start with blank apps.
2. model-driven : Start with data model first.
3. portal : Used to create external website.

Common Data Service : is the data platform that comes with PowerApps and allows you to store and model business data.
It’s the platform on which Dynamics 365 applications are built;
if you’re a Dynamics customer, your data is already in the Common Data Service.

For more information visit Microsoft site.
https://docs.microsoft.com/en-us/powerapps/maker/index

DataTable list with Create, Edit and Delete In PowerApps

In this post  one Datatable and displaying a entity record.

Take the three icon for CreateEdit and Delete.
For Edit and Delete operation first select the DataTable record and performing the respective operation.

Design the screen as:
Create one screen name as Home add the Datatable, select the Datasource for Datatable to displaying the records.



1. For Create Record add FxExpression as:
    NewForm(Form1);Navigate(‘Edit Records’)
Here…
Edit Records = Screen name,
Form1 = Edit record screen Form name.

2. For Edit create one screen with Edit Form, select the data source for record.
On select of Edit icon for OnSelect event add FxExpression as
    EditForm(Form1);Navigate(‘Edit A Record’, None)
Here…
Edit A Record = Screen name

3. For Delete icon just add the FxExpression as:
    OnSelect event = Remove([@’Pwer Apps’], DataTable1.Selected); Notify(“Record Deleted”)
Here…
Pwr Apps = entity name.

4. For Referesh icon add a FxExpression as:
    Onselect = Refresh(‘Pwer Apps’)
Here…
Pwer Apps = entity name

Select any record from DataTable and click on Edit and Delete icon, it will perform respective operation.

PopUp For Delete

Display Warning PopUp dialogue box after clicking on the delete icon.
  • Take one rectangle => fit to with screen
  • Take one label text as (“Are you sure to delete this record?”)Add two button Yes and No
  • select No button and OnSelect event add the FxExpression as UpdateContext({showPopUp:false}),it will create one variable with name showPopUp.
  • select Yes button and OnSelect event add the FxExpression as Remove(‘Crud Operation Entiy’, Gallery1.Selected) ;UpdateContext({showPopUp:false}) ; Back()
  • using Ctrl select the buttons, label and rectangle => go to Home => Group
  • Now go to Delete icon => Select => OnSelect event add FxExpression as UpdateContext({showPopUp:true})
  • Select the Group and paste the variable name show pop up on a visible event of Group
  • After design complete play the application => click on Delete icon.
Reference : http://shaikhd365.blogspot.com/2019/12/implement-warning-popup-for-delete-in.html

PowerApps FxExpression

PowerApps FxExpression:

FxExpression are mainly used into PowerApps for creating formula.
Below are the some FxExpression…

1. For Delete icon:
Remove([@’Crud Oepration Entiy’], Gallery1.Selected); If (IsEmpty(Errors([@’Crud Oepration Entiy’], Gallery1.Selected)),Back())
Here…
Crud Oepration Entiy = targeted current entity,
Gallery1 = List Of Displaying records form name,

2. For Edit icon:
EditForm(Form1);Navigate(‘Edit Records’, None)

Here…
Form1 = Edit form name,
Edit Records = Screen name of edit records.

3. For Right() icon:
SubmitForm(Form1)
Here…
Fomr1 = Edit or create records form name.

4. For Cross() icon:
ResetForm(Form1);Back()
Here…
Form1 = Edit or create records form name.

5. For Refresh(‘Crud Oepration Entiy’)
Here…
Crud Oepration Entiy = data source name

6. For Notify(“Data saved successfully”, NotificationType.Success)
event name = OnSuccess event
Here… this expression used to display message

7. For Notify(Form1.Error, NotificationType.Error)
event name = OnFailure
Here…
Form1 = form name

8. For SubmitForm(Form1)
event name = PnSelect
Here…
Form1 = Form name

9. For Distinct(columnname, columnname)
event = items (for dropdown)
it’s map the distinct values to dropdown.

10. Navigate(Details, ScreenTransition.None)
event name = OnSelect
Here…
Details = screen name or form name.

11. Filter(‘Crud Oepration Entiy’, Country=”India”)
event name = OnSelect
Here…
Crud Oepration Entiy = entity name(data source name),
      Country = DataTable column name

12. Sort(Distinct(columnname, columnname), Result)
it’s sorting the dropdown values
Distinct(Filter(seconddropdownname, firstdropdownname=firsdropdownid.selected.value),seconddropdownname)

13. Reset(FieldName) = it will reset the field values.


14. DisplayMode.Disabled = used to disable he field (on default event, here first we have to select field and set the expression as above.)

For more info visit the below sites…
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference
https://veenstra.me.uk/2019/01/25/powerapps-expressions-in-powerapps/