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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / I want to insert and e...
Power Apps
Unanswered

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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard