Error: Unexpected characters. 'ParenClose' where 'Eof' is expected for combo-box

[cyberco01]

Hi,

I have a powerapps form linked to sharepoint.

I have a combo-box that reads data from SQL. The combo box has below formula on the items.

If(
User().Email="abc@xyz.com",
Filter(VW_ANC_WorkerPositionRate, REVPROJID = ComboBox1.Selected.PROJECTID),
Filter(VW_ANC_ProjectStaging, REVPROJID <> ComboBox1.Selected.PROJECTID)
)

However, when I change the combo box property to Allow Searching - it shows error - "the formula contains parenclose where eof is expected powerapps".

Please help.

[cyberco01]

@RandyHayes , kindly help if you have encountered a similar one before.

[cyberco01]

@WarrenBelz , kindly help 

[cyberco01 · Accepted solution]

The issue has been resolved by removing the comments in teh code.

[Mari]

Thanks for updating the thread with your findings!

[RandyHayes]

@cyberco01 

Your Formula did not show any comments...so I suppose you excluded them in your post and discovered them as an issue.

Comments can be in-line (at the end of a line) and proceeded with //

Or an entire block can be commented with the start of the block containing a /* and the end of the block containing a */

[Michman]

This is not so intuitive, but it helped ! Thank you