web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Submit edit form to Sh...
Power Apps
Answered

Submit edit form to Share point list some column

(0) ShareShare
ReportReport
Posted on by 154

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.

Insert some Column in SP.JPG
Categories:
I have the same question (0)
  • eka24 Profile Picture
    20,925 on at

    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 Profile Picture
    154 on at

    @eka24 

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

    Error.jpg
  • eka24 Profile Picture
    20,925 on at

    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 Profile Picture
    154 on at

    @eka24 

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

    Error2.jpg
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    20,925 on at

    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 Profile Picture
    154 on at

    @v-xida-msft 

    sorry , 

    "specific emp id value"

    what does it's mean? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 413

#2
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#3
timl Profile Picture

timl 315 Super User 2026 Season 1

Last 30 days Overall leaderboard