Unanswered

Update Formula Error

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I'm getting an error message on my submit button that says the following with a red squiggles at the front and rear of the formula -
"Unexpected characters. The formula contains 'ParenClose' where 'Eof' is expected."

Update(
FLSAList,
LookUp(FLSAList, ID = Value(DataCardValue25.Text),
{FullName: DataCardValue9_1.Text,
LastName: DataCardValue10_1.Text,
FirstName: DataCardValue11_1.Text,
MI: DataCardValue12_1.Text,
EmployeeNumber: DataCardValue22.Text,
WhoCreatedProfile: DataCardValue13_1.Text,
ApprovingSupervisorName: DataCardValue15_1.Text,
DateSupeervisorApproved: DateValue(DataCardValue16_1.SelectedDate),
DateOfHire: DateValue(DataCardValue17.SelectedDate),
JobTitle: DataCardValue18.Text,
JobLocationProject: DataCardValue19.Text,
EvaluatorName: DataCardValue24.Text,
EvaluationType: DataCardValue20.Text,
EvaluationDate: DateValue(DataCardValue23.SelectedDate),
PertinentSupportingInfo: DataCardValue21.Text,
DateProfileCreated: DateValue(DataCardValue14_1.SelectedDate)});

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Phineas ,

The call to LookUp is missing the closing bracket. If you correct the formula like so, that should fix the problem.

Update( FLSAList, LookUp(FLSAList, ID = Value(DataCardValue25.Text)), {insert your existing values here... } )

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Phineas

If you are using a Form (which it appears to be), you should not be doing all this work!!

SubmitForm(yourForm) is all you need.

I hope this is helpful for you.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yep, could; But I've changed some much this was easier.

I made the change recommended by the other user. I now have the following formula that is kicking back this error - ID: Field 'ID' is required

DataCardValue25.Text contains the item 'ID' from the SharePoint list.

Update(
FLSAList,
LookUp(FLSAList, ID = Value(DataCardValue25.Text)),
{FullName: DataCardValue9_1.Text,
LastName: DataCardValue10_1.Text,
FirstName: DataCardValue11_1.Text,
MI: DataCardValue12_1.Text,
EmployeeNumber: DataCardValue22.Text,
WhoCreatedProfile: DataCardValue13_1.Text,
ApprovingSupervisorName: DataCardValue15_1.Text,
DateSupeervisorApproved: DateValue(DataCardValue16_1.SelectedDate),
DateOfHire: DateValue(DataCardValue17.SelectedDate),
JobTitle: DataCardValue18.Text,
JobLocationProject: DataCardValue19.Text,
EvaluatorName: DataCardValue24.Text,
EvaluationType: DataCardValue20.Text,
EvaluationDate: DateValue(DataCardValue23.SelectedDate),
PertinentSupportingInfo: DataCardValue21.Text,
DateProfileCreated: DateValue(DataCardValue14_1.SelectedDate)});

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I made the change recommended by the other user. I now have the following formula that is kicking back this error - ID: Field 'ID' is required

DataCardValue25.Text contains the item 'ID' from the SharePoint list.

Update(
FLSAList,
LookUp(FLSAList, ID = Value(DataCardValue25.Text)),
{FullName: DataCardValue9_1.Text,
LastName: DataCardValue10_1.Text,
FirstName: DataCardValue11_1.Text,
MI: DataCardValue12_1.Text,
EmployeeNumber: DataCardValue22.Text,
WhoCreatedProfile: DataCardValue13_1.Text,
ApprovingSupervisorName: DataCardValue15_1.Text,
DateSupeervisorApproved: DateValue(DataCardValue16_1.SelectedDate),
DateOfHire: DateValue(DataCardValue17.SelectedDate),
JobTitle: DataCardValue18.Text,
JobLocationProject: DataCardValue19.Text,
EvaluatorName: DataCardValue24.Text,
EvaluationType: DataCardValue20.Text,
EvaluationDate: DateValue(DataCardValue23.SelectedDate),
PertinentSupportingInfo: DataCardValue21.Text,
DateProfileCreated: DateValue(DataCardValue14_1.SelectedDate)});

Was this reply helpful? Yes No