Answered

UpdateIf Name Isn't Valid Error Source

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I've got the following formula in a submit button for a gallery.

I am getting the following error - 'Name isn't valid. '(0)' isn't recognized.'

I gone over the column names (in the SharePoint List search bar) and Power Apps field names several times, and confirmed
their accuracy, and can't figure out why I am getting this error.

What am I missing?

UpdateIf(
'Action Plan Worksheet List',Title = Action_Plan_Client_ID_Fld.Text,
{
Title: Action_Plan_Client_ID_Fld.Text,
Client_FullName: Action_Plan_Client_FullName_Fld.Text,
Client_File_Number: Action_Plan_Client_File_Number_Fld.Text,
Counselor_ID_Number: Action_Plan_Counselor_ID_Fld.Text,
Counselor_Name: Action_Plan_Counselor_Name_Fld.Text,
Case_ID: Action_Plan_Case_ID_Fld.Text,
Action_Plan_ID: Action_Plan_Action_Plan_ID_Fld.Text,
Preffered_Contact_Method: Action_Plan_Preffered_Contract_Method_Fld.Text,
Refferal_ID: Action_Plan_Refferal_ID_Fld.Text,
Refferal_Agency_Name: Action_Plan_Refferal_Agency_Name_Fld.Text,
Referral_Description: Action_Plan_Refferal_Description_Fld.Text,
Reason_for_Seeking_Counseling: Action_Plan_Reason_for_Seeking_Counseling_Fld.Text,
Additional_Remarks: Action_Plan_Additional_Remarks_Fld.Text,
Client_Goals: Action_Plan_Client_Goals_Fld.Text,
Property_Assessment: Action_Plan_Property_Assessment_Fld.Text,
Financial_Assessment: Action_Plan_Financial_Assessment_Fld.Text,
Client_Actions: Action_Plan_Client_Actions_Fld.Text,
Counselor_Actions: Action_Plan_Counselor_Actions_Fld.Text
}
)
;

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Phineas ,

I’m trying to figure it out why you prefer UpdateIf() function to Patch(). Is there a set of records to update with current values or it is only one record ?

UpdateIf iterate through all records and update the ones where condition is met. It is non delegable function and this can create update problems for large lists.

Patch(

Your list,

Lookup(Your list, Title=SearchTitle),

{
…

}
)

On the other hand, your scénario seems to be perfect match for a form usage.

Was this reply helpful? Yes No
Verified answer

timl 36,774 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Phineas

What I'd suggest here is that you start off by just calling UpdateIf on the Title.

UpdateIf( 'Action Plan Worksheet List',Title = Action_Plan_Client_ID_Fld.Text, { Title: Action_Plan_Client_ID_Fld.Text } ) ;

You can then add and test each additional field one-by-one. The point at which you receive the 'name isn't valid' error will be the field that's the cause of the problem.

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

Like (0)

Report
Copy link

Link copied!

After all that, is was operator error; I was misspelling two column names.

Thanks for the suggested corrective action.

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

Like (0)

Report
Copy link

Link copied!

It's a Gallery getting initial data from a variable set on another screen, then I have Lookups in the other fields.

If there is existing data associated with the Client_ID in the List/Collection, that data populates those fields.

If existing data is missing from list or needs to be added/edited it can be.

If it is a new client the 'Client_ID' and 'Client_Name' populate from variable, and other fields will remain blank and new content can be added and uploaded.

Was this reply helpful? Yes No