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.
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".
Solved! Go to Solution.
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 */