Submit edit form to Share point list some column

[Art_Ratta]

May i ask you if i need to submit edit form to Share point list  some column (SharePoint list having existing data) , example as picture.

[eka24]

You can use Patch with this structure:
Patch(SPlist, Defaults( SPlist), { FirstNameColumn: DatacardValue1.Text, LastNameColumn: DatacardValue2.Text, } )

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Art_Ratta]

@eka24 

Sorry , I do as you recommend but error from picture , not sure what did I do wrong.

[eka24]

Is Actual Date a column in your datasource? If so the put it in single quotes:
 'Actual Date':DatacardValue40

If there is no space in your datasource then it remove the space with no single quotes:
 ActualDate:DatacardValue40

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Art_Ratta]

@eka24 

thank you for answer , but still error again after remove space in data source column  & input single  quotes does not working 😥 

[v-xida-msft · Accepted solution]

Hi @Art_Ratta ,

Based on the screenshot that you mentioned, I suppose that you want to update existing record in your SP List, is that true?

If you want to use the Edit form to update existing record in your SP List, please make sure the DefaultMode property of the Edit form is set to following:

FormMode.Edit

and you must set the Item property of the Edit form to a specific record you want to update. Please make sure the Item property of the Edit form has been bind to specific record in your SP List properly.

You could consider generate an app based on your SP List data source, then it would generate three screens automatically, then you could use this generated app to edit existing records in your SP List easily.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/app-from-sharepoint

If you want to use Patch function to edit the existing record in your SP List, please take a try with the following formula:

Patch(
      'SP List',
      LookUp('SP List', Emp_id = "specific emp id value"),  // find the specific record you want to update
      {
        JobLevel: JobLevelTextInputBox.Text,
        Address: AddressTextInputBox.Text
      }
)

Best regards,

[eka24]

Is Actual Date a column in your datasource? If so the put it in single quotes:
'Actual Date':DatacardValue56

Patch('SHE Training all ',Defaults('SHE Training all '), {'Actual Date':DataCardValue56.Text, statusActive: DataCardValue55.Text})

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Art_Ratta]

@v-xida-msft 

sorry , 

"specific emp id value"

what does it's mean?