Unanswered

UpdateIf Name Isn't Valid Error Source

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

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

@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,383 Super User 2025 Season 2 on at

Like (1)

Report
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,325 Super User 2025 Season 2 on at

Like (0)

Report

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,325 Super User 2025 Season 2 on at

Like (0)

Report

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