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 / I want to insert and e...
Power Apps
Answered

I want to insert and edit fields in a share point list from scratch

(0) ShareShare
ReportReport
Posted on by

It is very comfortable to use the automatic wizard that uses share point and power apps without doing anything, but I would like to learn how to do it from scratch what it is to insert, update and delete the fields (CRUD) from scratch

I have the same question (0)
  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @jlhernandez,

    Not sure I understand fully what you're looking for. Is it to manually modify CDS entities such as adding or a new field or deleting an existing field part of an entity? Or are you looking for create/reading/deleting/updating (CRUD) records of an entity (table)?

    Cheers

  • Verified answer
    v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @jlhernandez ,

    Do you want to learn how to update data of sharepoint list from powerapps?

    Firstly, you need to create sharepoint site, sharepoint list and columns in your list.

    Here's a doc about this in details for your reference:

    https://support.microsoft.com/en-us/office/create-a-site-in-sharepoint-online-4d1e11bf-8ddc-499d-b889-2b48d10b1ce8

     

    Secondly, you need to create an app in powerapps.

    Connect this app with the sharepoint list that you want to update.

    Here's a doc about this in details for your  reference:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-online

     

    Thirdly, you need to know about the formulas about updating data:

    Patch(listname,Defaults(listname),{fieldname:...})   //create anew record

    Patch(listname,item to update,{fieldname:...})   //update an existing record

    SubmitForm(Formname)   //submit a form to create new record or update an existing record

    Collect(listname,record)   //create new record

    Remove(listname,item that you want to remove)    //delete record

    Here are docs about these functions:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-remove-removeif

     

    Fourthly, put the formula that you use to update in one control's behavior property.

    Common behavior property: OnSelect, OnChange,....

    When you trigger this property, the action will perform.

     

    Actually, I more suggest you try to create app by starting from data, then choose sharepoint.

    You will get an app generated based on that sharepoint list. You could learn a lot from that generated app.

    Here's a doc about how to create this kind of app for your reference:

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

     

     

    Best regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard