Syntax Error (Expected operator)

(0) Share

Report

Posted on by Community Power Pla...

Can anyone spot my syntax error?

Error message: Expected operator. We expect an operator such as +,*, or & at this point in the formula.

On a label's Default section:

If(varEditType="AddActivity",
LookUp('Visits For QSA',
ID=_listItemID,
'Title Date'),
EVEnterVisitForm.LastSubmit.'Title Date');

My intent was that if variable 'varEditType' is set to "AddActivity" then it grabs the 'Title Date' from the list 'Visits For QSA' that has the ID that matches '_listItemID'. If that statement was not true, I wanted it to grab EVEnterVisitForm.LastSubmit.'Title Date'.

I'm not sure where my error is.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

I don't see the error immediately in your formula. To troubleshoot it, put labels on the screen and break out each element of the formula and see if it contains a value. Please post a screenshot of the actual error to see where in the formula PowerApps is indicating there is an error.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Good call on breaking out the labels. Turns out, I think, the error was the semicolon at the end of the statement. This without the semicolon at the end removed the error:

If(varEditType="AddActivity",
LookUp('Visits For QSA',
ID=_listItemID,
'Title Date'),
EVEnterVisitForm.LastSubmit.'Title Date')

Was this reply helpful? Yes No
Kamaldk25 2 on at

Like (0)

Report

Please, Can anyone spot my syntax error?

Error message: Expected operator. We expect an operator such as +,*, or & at this point in the formula.

On .items for a SharePoint list

Filter(Choices([@Product Innovation].Country), Id in Filter(Choices([@Product Innovation].'Country:Region'), Value = DataCardValue3.Selected.Value).Id)

My intent was to create a cascading drop down in the Microsoft List using JSON and PowerApps

Was this reply helpful? Yes No