To navigate to edit screen.

//Select(Parent)
Set(record, ThisItem); EditForm(FormNewEdit); Navigate(scrForm)

To navigate to New screen:

Icon +, onSelect , ResetForm(FormNewEdit); NewForm(FormNewEdit); Navigate(scrForm, ScreenTransition.Fade)

 

Set the Bg of the selected row

TemplateFill: If(ThisItem.IsSelected,RGBA(0, 120, 212, .2),RGBA(0, 0, 0, 0))

or

If(ThisItem.IsSelected,WhiteSmoke,White)

 

Format Currency column:

[code] If(
IsBlank(ThisItem.’col name’),
"",
"$" & Text(
Value(ThisItem.’col name’),
"[$-en-US] #,##0.00"
)
)
[/code]