Unexpected characters. The formula contains 'ParenClose' where 'Error' is expected.

[Janmas]

In the app OnStart I would like to use a collection but I can't get the syntax right:

Collect(EmployeeCollection, {Name:”John”,LastName:”Henry”}, {Name:”Mike”,LastName:”Jones”})

The id EmployeeCollection is not recognized

[Ramole]

Hi @Janmas 
Try now 

Collect(EmployeeCollection, {Name:"John",LastName:"Henry"}, {Name:"Mike",LastName:"Jones"})

[Janmas]

Hi Ramole,

I get this error: 

[Ramole]

@Janmas 
Lets do basics first add below code on a button and click and use EmployeeCollection tell me what you getting 

ClearCollect(EmployeeCollection, {Name:"John",LastName:"Henry"}, {Name:"Mike",LastName:"Jones"})

Check if App.OnStart property is on the settings look the screenshot 

[Janmas]

Hi,

I checked the App.Onstart property and it is on. I add a button but when I add the Collect statement I get the same error.

[Ethan_R]

Hi @Janmas ,

It seems like there's issue with the quotes symbol. You have ” but you should be using " this instead.

The following code works if used correct " " marks

Collect(
  EmployeeCollection, 
  {Name:"John",LastName:"Henry"},
  {Name:"Mike",LastName:"Jones"}
)

Hope this helps 

[Ramole · Accepted solution]

@Ethan_R 
The problem is somewhere else, I have already corrected the quotation marks if you look at my first post.
that's why I have asked him to check if App.OnStart is enabled also to add the code on button and try out.

[WarrenBelz]

@Janmas ,

It is a good idea to use Notepad, not Word when preparing code - it has been pointed out below that the quotes are wrong, but I am wondering if you actually saw the significance of this. App OnStart settings have nothing to do with it - if it was not enabled, you would not get the option to put anything in there.

Please paste the below into the code - you will find it is valid unless you use EmployeeCollection somewhere else in your app with different field types (you might confirm this)

ClearCollect(
   EmployeeCollection, 
   {
      Name:"John",
      LastName:"Henry"
   }, 
   {
      Name:"Mike",
      LastName:"Jones"
   }
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps