Power Platform Community Forum Thread Details

Hello everyone.

i´ve the following code at a button - OnSelect

The problem is that neither semicolons nor commas work to separate the functions.

Patch(
    UserHierarchy;
    galUsers.Selected;
    {
        ManagerID: {
            Id: cmbMgr.Selected.ID;
            Value: cmbMgr.Selected.FullName
        }
    }
);
Refresh(UserHierarchy);
ResetForm(Form1);
EditForm(Form1)

If I use the semicolon, I get the following error message for the semicolon between the patch and refresh function:
Unexpected characters. Characters are not used as expected in the formula.






Patch(
  UserHierarchy,
  galUsers.Selected,
  {
    ManagerID: {
      Id: cmbMgr.Selected.ID,
      Value: cmbMgr.Selected.FullName
    }
  }
);
Refresh(UserHierarchy);
ResetForm(Form1);
EditForm(Form1)
If I use the comma as a separator for the functions, 

I get the following error message:
Unexpected characters. The formula contains ‘Error’, but ‘ParenClose’ is expected.

Unexpected characters. Characters are not used as expected in the formula.

For your information.
The problem is not unique to this code.

Whenever I have two functions in a code and I have to separate them, I get the error
I have set German as the language in the app. But even if I set the language to English, the errors still occur.

I just can't find a solution

Thanks for help


Marcus