Unanswered

Expected operator

(1) Share

Report

Posted on by Fullytasker

Hello! im getting some issues when creating one code after another in power apps. The second Patch shows a expected operator error(Operator expected. We are expecting an operator like +, * or & at this point in the formula.) and the ; simbol after tabela4 its getting a Unexpected characters. The formula contains 'Comma', where 'ParenClose' is expected and Unexpected characters. Characters are used in the formula in an unexpected way erros.

Patch(
    'Tabela3'; 
    Defaults('Tabela3'); 
    { 'Nome do projeto': NomeProjetoVar }
)
Patch(
    'Tabela4';
    Defaults('Tabela4');
    { 'SOP': SOPProjetoVar }
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (1)

Report
Hi you are missing a semi colon between them

Yours

Patch( 'Tabela3'; Defaults('Tabela3'); { 'Nome do projeto': NomeProjetoVar } ) Patch( 'Tabela4'; Defaults('Tabela4'); { 'SOP': SOPProjetoVar } )

Mine as you need to close the original Patch or it just thinks its a run on sentence.

Patch( 'Tabela3', Defaults('Tabela3'), { 'Nome do projeto': NomeProjetoVar } ); Patch( 'Tabela4', Defaults('Tabela4'), { 'SOP': SOPProjetoVar } )

Was this reply helpful? Yes No
Fullytasker 37 on at

Like (0)

Report

Hello Mike! please, i already tried the code you sent me but i already got some error. Im using the PTBR location and already tried with ";" instead of ",". Im getting:
Unexpected characters. The formula contains 'Error', where 'ParenClose' is expected.

Unexpected characters. Characters are used in the formula in an unexpected way.

Was this reply helpful? Yes No
Suggested answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
Hi Fullytasker

If you're using Power Apps in a Latin based/non-English language, you'll need to use semi-colons instead of commas.

Note that you need a double semi-colon (;;) between the 2 patch statements.

Patch( 'Tabela3'; Defaults('Tabela3'); { 'Nome do projeto': NomeProjetoVar } );; Patch( 'Tabela4'; Defaults('Tabela4'); { 'SOP': SOPProjetoVar } )

Was this reply helpful? Yes No
Suggested answer

CA1105 545 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Could you please add semicolon(;) between patch function?
Patch( 'Tabela3'; Defaults('Tabela3'); { 'Nome do projeto': NomeProjetoVar } ); Patch( 'Tabela4'; Defaults('Tabela4'); { 'SOP': SOPProjetoVar } )

Was this reply helpful? Yes No