Answered

Error: CurlyOpen where ParenClose is expected

(0) Share

Report

Posted on by MartinBarbenik

Hello, i am trying to make a Form in PowerApps that be adding new events to my excel chart, I used this code:

Collect(Tabuľka1 {'Názov udalosti':NazovUdalosti.Text;'Začiatok':Zaciatok.DateTime;'Koniec':Koniec.DateTime;'Zodpovedná osoba':ZOsoba.Text;'Typ':Typ.Text;'Popis udalosti':Popis.Text})

but it is always giving me this error: "CurlyOpen where ParenClose is expected"

Datasource is my Excel sheet which is on OneDrive

Can you help me please? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!
Try this:

Collect(Tabuľka1; //missing a semicolon here { 'Názov udalosti':NazovUdalosti.Text; 'Začiatok':Zaciatok.DateTime; 'Koniec':Koniec.DateTime; 'Zodpovedná osoba':ZOsoba.Text; 'Typ':Typ.Text; 'Popis udalosti':Popis.Text })

Hope that helps,

Bryan

Was this reply helpful? Yes No
MartinBarbenik 17 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your message, but it is still not working.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!

OK, can you share a translated version of the error message again?

Was this reply helpful? Yes No
MartinBarbenik 17 on at

Like (0)

Report
Copy link

Link copied!

This shows now:

The problem:
Incompatible type. "Koniec" column in the data source, you are updating expects a DateTime type and you are using the Error type.
Site:
Button1
.OnSelect
Correction procedure:
You will probably need to convert the value to be of the same type, for example, convert the date string (for example 31/12/2018) to a date value or a string to a number.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!

The error is pointing out that "Koniec.DateTime" is not referencing a valid property of a control. Is Koniec a datepicker control? If so, the date reference would be "Koniec.Value" or "Koneic.SelectedDate" depending on the exact datepicker. Try those references instead, and you'll likely need to do the same with the Zaciatok control.

Hope that helps,

Bryan

Was this reply helpful? Yes No
MartinBarbenik 17 on at

Like (0)

Report
Copy link

Link copied!

Still showing this, even is i type Koniec.Value, and also Zaciatok.Value
The problem:
Incompatible type. The "Koniec" column in the data source you are updating expects a DateTime type and you are using the Error type.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!
Please use the intellisense (autocomplete) feature to help you complete the property values for the controls. It should be "Koneic.SelectedDate", not "Koneic.SelectDate"

Alternatively, it looks like you are using a form control, so you can try this:

Collect(Tabuľka1; Form2.Updates);;

Bryan

Was this reply helpful? Yes No
MartinBarbenik 17 on at

Like (0)

Report
Copy link

Link copied!

Sorry for my mistake, but it doesnt work:

Collect(Tabuľka1;
{
'Názov udalosti':Nazov.Text;
'Začiatok':Zaciatok.SelectedDate;
'Koneic':Koniec.SelectedDate;
'Zodpovedná osoba':ZOsoba.Text;
'Typ':Typ.Text;
'Popis udalosti':Popis.Text
})

The problem: Incompatible type. 'Event name' column in of the data source you are updating expects the type Text and you are using the Error type.

I tried it with Form2 like you said,
Collect(Tabuľka1; Form2.Updates);;

there is no problem/no error but the data in excel sheet is not updating, is it possible to make it somehow?

Thank you for your help

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!
Oh, I think I have misunderstood your request.

When you want to submit entries from a form into a datasource, we do not use Collect(). Instead, we use:

SubmitForm(Form2);;

Collect() is meant for keeping a copy of the data in a table within the app, much like a temporary variable.

Does this help?

Bryan

Was this reply helpful? Yes No
MartinBarbenik 17 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much, this really helped me. After form is submitted, data goes into an excel spreadsheet on my sharepoint.

Was this reply helpful? Yes No