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/