Power Platform Community Forum Thread Details

I have Gallery1.

The items of Gallery1 is varEmployeeRecord, from a gallery on another screen.

I have the following in the Submit button; However, when I submit the SPList does no update, even though I get no errors, and I see 'ants' across the screen. What am I missing?
If(Edit_Individual_Suscriber_Item_ID_Fld.Text in _Client_List.ID,
Update(
Client_List,
Defaults(Client_List),
{Title: Upper(Edit_Individual_Subscriber_CML_ID_Fld.Text),
Subscriber_Prefix: Upper(Edit_Individual_Suscriber_Prefix_ComboBox.Selected.Value),
Subscriber_First_Name: Upper(Edit_Individual_Suscriber_First_Name_Fld.Text),
Subscriber_Last_Name: Upper(Edit_Individual_Suscriber_Last_Name_Fld.Text),
Subscriber_Email_Address: Upper(Edit_Individual_Suscriber_Email_Address_Fld.Text),
Subscriber_Suffix: Upper(Edit_Individual_Suscriber_Suffix_ComboBox.Selected.Value),
Subscriber_MI: Upper(Edit_Individual_Suscriber_MI_Fld.Text),
Subscriber_Phone: Upper(Edit_Individual_Suscriber_Phone_Number_Fld.Text),
Type_of_Subscriber: Upper(Edit_Individual_Suscriber_Type_Fld.Text),
Subscriber_Source: Upper(Edit_Individual_Suscriber_Source_Dropdown.Selected.Value),
Subscriber_Status: Upper(Edit_Individual_Suscriber_Status_Dropdown.Selected.Value),
Comments: Upper(Edit_Individual_Suscriber_Comment_Fld.Text)})
;

Categories:

General Questions

I notice in your Patch, you are doing an Update but with Defaults(Client_list) which means add.

I don't see where you are doing a lookup (instead of Default(Client_list)) to find the row in the list you want to update.

So can you validate you aren't accidentally adding records.

Normally you would say

Update(Client_List, LookUp(Client_List, UniqueIdFieldIMMakingUP = _Client_List.ID),

{Title: Upper(Edit_Individual_Subscriber_CML_ID_Fld.Text),
Subscriber_Prefix: Upper(Edit_Individual_Suscriber_Prefix_ComboBox.Selected.Value),
Subscriber_First_Name: Upper(Edit_Individual_Suscriber_First_Name_Fld.Text),
Subscriber_Last_Name: Upper(Edit_Individual_Suscriber_Last_Name_Fld.Text),
Subscriber_Email_Address: Upper(Edit_Individual_Suscriber_Email_Address_Fld.Text),
Subscriber_Suffix: Upper(Edit_Individual_Suscriber_Suffix_ComboBox.Selected.Value),
Subscriber_MI: Upper(Edit_Individual_Suscriber_MI_Fld.Text),
Subscriber_Phone: Upper(Edit_Individual_Suscriber_Phone_Number_Fld.Text),
Type_of_Subscriber: Upper(Edit_Individual_Suscriber_Type_Fld.Text),
Subscriber_Source: Upper(Edit_Individual_Suscriber_Source_Dropdown.Selected.Value),
Subscriber_Status: Upper(Edit_Individual_Suscriber_Status_Dropdown.Selected.Value),
Comments: Upper(Edit_Individual_Suscriber_Comment_Fld.Text)}

)

OR Since its a Gallery you can say

Update(Client_List, GalleryX.Selected,

)

Update(Client_List, ThisItem,

{Title: Upper(Edit_Individual_Subscriber_CML_ID_Fld.Text),
Subscriber_Prefix: Upper(Edit_Individual_Suscriber_Prefix_ComboBox.Selected.Value),
Subscriber_First_Name: Upper(Edit_Individual_Suscriber_First_Name_Fld.Text),
Subscriber_Last_Name: Upper(Edit_Individual_Suscriber_Last_Name_Fld.Text),
Subscriber_Email_Address: Upper(Edit_Individual_Suscriber_Email_Address_Fld.Text),
Subscriber_Suffix: Upper(Edit_Individual_Suscriber_Suffix_ComboBox.Selected.Value),
Subscriber_MI: Upper(Edit_Individual_Suscriber_MI_Fld.Text),
Subscriber_Phone: Upper(Edit_Individual_Suscriber_Phone_Number_Fld.Text),
Type_of_Subscriber: Upper(Edit_Individual_Suscriber_Type_Fld.Text),
Subscriber_Source: Upper(Edit_Individual_Suscriber_Source_Dropdown.Selected.Value),
Subscriber_Status: Upper(Edit_Individual_Suscriber_Status_Dropdown.Selected.Value),
Comments: Upper(Edit_Individual_Suscriber_Comment_Fld.Text)}

)

Not

Update(
Client_List,
Defaults(Client_List),

If you want to update
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey