cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gguedes
Level: Powered On

Error using Collect Formula - "CurlyClose" "ParenClose"

Hi guys,

 

Good Morning (It's still morning here in Brazil). I built a custom form, that i want to upload to a connected sharepoint list.

 

After several errors and a lot of help from the community, the current error i was not able to find here. my collect formula is like this: 

Collect('Teste_Gestão de Relacionamento';{'Qual é a sua Coodernação':[@Dropdown4].Selected.Value; 'Pauta da reunião':[@TextInput1].Text; 'Qual a data do Engajamento':[@DatePicker2].SelectedDate; 'Stakeholders Presentes':[@Label1].Text; Funcion_x00e1_rios_x0020_Anglo_x:[@Label2].Text; 'Próximos Passos':[@TextInput2].Text; 'Comentários Gerais':[@TextInput3].Text)

 

which the model, I also found here, if you guys see any obvious mistake, I'm sorry, I'm just a beginner at PowerApps.

 

The app intention is to be used whenever the team has a meeting with an external stakeholder, which is a repeated process, then i will link the sharepoint list to a Power Bi dashboard.

 

The current error shows this: Unexpected Characteres. The formula contains 'CurlyClose' in the section 'ParenClose' is expected. This error will occur if, for example, a formula contains '{Val@7}' instead of '{Val:7}'. when you define a variable, the syntax will require ":" instead of "@".

 

I translated the above excerpt from portuguese, which is my software native language.

 

Your help will be very apprecciated, please let me know if you need any more info about my app.

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Error using Collect Formula - "CurlyClose" "ParenClose"

Welcome to PowerApps! One way to better understand the expressions is to indent them by breaking them down by lines into its different components, so it's easier to see if there are any mistakes. For example, your expression can be rewritten as follows:

Collect(
    'Teste_Gestão de Relacionamento';
    {
        'Qual é a sua Coodernação':[@Dropdown4].Selected.Value;
        'Pauta da reunião':[@TextInput1].Text; 
        'Qual a data do Engajamento':[@DatePicker2].SelectedDate; 
        'Stakeholders Presentes':[@Label1].Text; 
        Funcion_x00e1_rios_x0020_Anglo_x:[@Label2].Text; 
        'Próximos Passos':[@TextInput2].Text; 
        'Comentários Gerais':[@TextInput3].Text
)

And that shows easier the missing curly brace from it. If you add it (before the last line), the error should disappear:

Collect(
    'Teste_Gestão de Relacionamento';
    {
        'Qual é a sua Coodernação':[@Dropdown4].Selected.Value;
        'Pauta da reunião':[@TextInput1].Text; 
        'Qual a data do Engajamento':[@DatePicker2].SelectedDate; 
        'Stakeholders Presentes':[@Label1].Text; 
        Funcion_x00e1_rios_x0020_Anglo_x:[@Label2].Text; 
        'Próximos Passos':[@TextInput2].Text; 
        'Comentários Gerais':[@TextInput3].Text
    }
)
2 REPLIES 2
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Error using Collect Formula - "CurlyClose" "ParenClose"

Welcome to PowerApps! One way to better understand the expressions is to indent them by breaking them down by lines into its different components, so it's easier to see if there are any mistakes. For example, your expression can be rewritten as follows:

Collect(
    'Teste_Gestão de Relacionamento';
    {
        'Qual é a sua Coodernação':[@Dropdown4].Selected.Value;
        'Pauta da reunião':[@TextInput1].Text; 
        'Qual a data do Engajamento':[@DatePicker2].SelectedDate; 
        'Stakeholders Presentes':[@Label1].Text; 
        Funcion_x00e1_rios_x0020_Anglo_x:[@Label2].Text; 
        'Próximos Passos':[@TextInput2].Text; 
        'Comentários Gerais':[@TextInput3].Text
)

And that shows easier the missing curly brace from it. If you add it (before the last line), the error should disappear:

Collect(
    'Teste_Gestão de Relacionamento';
    {
        'Qual é a sua Coodernação':[@Dropdown4].Selected.Value;
        'Pauta da reunião':[@TextInput1].Text; 
        'Qual a data do Engajamento':[@DatePicker2].SelectedDate; 
        'Stakeholders Presentes':[@Label1].Text; 
        Funcion_x00e1_rios_x0020_Anglo_x:[@Label2].Text; 
        'Próximos Passos':[@TextInput2].Text; 
        'Comentários Gerais':[@TextInput3].Text
    }
)
Highlighted
gguedes
Level: Powered On

Re: Error using Collect Formula - "CurlyClose" "ParenClose"

CarlosFigueira, I can't thank you enough for your help and tip. It was such a simple mistake and now it is working perfectly.

 

Thanks a lot