RSS

Category Archives: PowerApps

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

 
Leave a comment

Posted by on February 17, 2020 in PowerApps, Uncategorized

 

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.

 
Leave a comment

Posted by on February 17, 2020 in PowerApps, Uncategorized

 

Implement Warning PopUp For Delete In PowerApps


Here I am going to display Warning PopUp dialogue box after clicking on the delete icon.

1. Take one rectangle => fit to with screen

2. Take one label text as (“Are you sure to delete this record?”)
Add two button Yes and No

3. select No button and OnSelect event add the FxExpression as UpdateContext({showPopUp:false}),it will create one variable with name showPopUp.

4. select Yes button and OnSelect event add the FxExpression as Remove(‘Crud Oepration Entiy’, Gallery1.Selected) ;UpdateContext({showPopUp:false}) ; Back()

5. using Ctrl select the buttonslabel and rectangle => go to Home => Group

6. Now go to Delete icon => Select => OnSelect event add FxExpression as UpdateContext({showPopUp:true})


7. Select the Group and paste the variable name show pop up on a visible event of Group


8. After design complete play the application => click on Delete icon.

 
Leave a comment

Posted by on February 17, 2020 in PowerApps, Uncategorized

 

Tags:

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/

 
Leave a comment

Posted by on February 17, 2020 in PowerApps, Uncategorized

 
 
Dynamics Cognizance

Site presents solution to common and non-common Microsoft Dynamics Ax problems faced by Consultants and Administrators

365 by Thijs

Blogging about Microsoft 365, Azure and Automation!

axhowto

Blog about ax with sample codes, tips and tricks.

GM Dynamics Blogs

Transform IT with Digital Trasformation and Social Innovation

Ms. Dynamic Millennial

Unboxing Microsoft Dynamics 365 for Finance and Operations

DynaD365Power

Exploring the new vision of the Power platform

Dynamics Vision 365

The FinOps pulse

Breaking Bong

I write when no one is watching

ErpCoder

Microsoft Dynamics 365 Business Management Solution Enthusiast

Dynamics 365 Finance

Dynamics 365 Finance & Much More.

Microsoft Dynamics AX

“ANYONE WHO STOPS LEARNING IS OLD, WHETHER AT TWENTY OR EIGHTY.” —HENRY FORD

Sumit Potbhare

Dynamics 365 for Commerce

iotsolution.se

This is your site about D365 (Finance and Supply Chain Management), IoT (Internet of Things) and HoloLens