Logo
banner

Blogs

Performing CRUD Operations in Power Apps using Sharepoint List – Part I

, March 21, 2023 1666 Views

Hello PowerApps Users 

PowerApps is in demand nowadays because of its remarking features such as:

  • Speed of app creation. Power Apps accelerate app creation.  
  • Low-code and no-code. 
  • Microsoft and other third-party service integrations.  
  • Business process automation.  
  • Low cost of app ownership.  
  • AI capabilities.  
  • Cross-platform access and ease of deployment. 

As a beginner in developing any application, the first step we do is CRUD operations. Same is the case in Power Apps.
On the internet, we have scattered information regarding CRUD operations, and hence it becomes difficult for a beginner to expedite the development by seeking information from multiple different articles.

So, to guide PowerApps beginners, we have compiled a series of blogs on CRUD Operations in Power Apps for our fellow PowerApps users:

We have segregated the blog into 5 major parts as below:

  • How to Connect to different Data Sources in Power Apps.
  • How to Read existing records from the Data Source. [Filter, Lookup]
  • How to Create new records in the Data Source. [Using Patch method]
  • How to Update & Delete existing records of the Data Source.
  • How to perform CRUD operations using Edit Forms using any Data Source.

In this blog, we are focusing on Connection, as connection is the most crucial part of any implementation. Connection refers to what data source we’re using as a backend. Here, we are taking SharePoint as a connector.

Note: You can take any other connector of your convenience. And if you face any issues while connecting with your connector, feel free to post comments here. We will try our best to resolve your issue. 🙂

Scenario:

Here, we have taken a scenario where multiple Teacher logs entries of their Students’ details in the SharePoint list using Power Apps. 

Here, we’ve created a SharePoint Site, “SharePoint Patching Site” wherein we have created 3 SharePoint lists namely:  

  • list_PatchingFromPowerApps (This is the main list the Teacher Creates/Updates/Deletes the entries)
  • list_Subject (This is a one-column list that contains Subject column)
  • list_Sports (This is a one-column list that contains Sports column)

Below is the overview of the SharePoint site and the Lists which we’ve created and going to use to perform the CRUD Operations in Power Apps.

Connecting Data Source in Power Apps:

Go to Power Apps and create a new tablet-sized Canvas App. Here, we have named it – “PowerApps SharePoint Patching App”.
To connect to data source, do as follows:

    • Rename the Blank Screen to “scr_View”.
    • Add 3 SharePoint Lists as Data Source, as mentioned above, in the Application as-
      • +Add Data > Dropdown will expand and select necessary work items.
      • Inside Connectors section, scroll down and click “SharePoint”
        OR
        You can search “SharePoint” directly in the Search Textbox as shown in the above image.
      • Select any connection.
      • A right navigation pane will appear, which will ask you to select the specific SharePoint Site from where you need the Lists. Here, the site is “SharePoint Patching Site”.
      • Tick the Checkboxes of the lists you want to select and work within the application.
      • Here, checkmark the checkbox of list_PatchingFromPowerApps, list_Sports, list_Subject, and press Connect.
    • Add Office 365 Users, in the same way, which we’ll be using in creating and updating the Person Type of Column, in a later section.

Thus, in this blog, we learned how we can connect any connectors in Power Apps and establish a proper connection at our convenience. And in our use case, we have used SharePoint & Office365 Users as connectors.

So, now, what next?

Stay tuned!

Check out the next part here!


ATM Inspection PowerApp to ease ATM inspection and report generation process.
https://www.inkeysolutions.com/microsoft-power-platform/power-app/atm-inspection

Insert data into Many-to-Many relationship in Dynamics CRM very easily & quickly, using the Drag and drop listbox.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/drag-and-drop-listbox

Comply your Lead, Contact, and User entities of D365 CRM with GDPR compliance using the GDPR add-on.
https://www.inkeysolutions.com/microsoft-dynamics-365/dynamicscrmaddons/gdpr

Create a personal / system view in Dynamics CRM with all the fields on the form/s which you select for a particular entity using the View Creator.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/view-creator

mm

Inkey

INKEY is your solution partner.
Our focus is to deliver you in-time intelligent innovative solutions ("key") for the problems in hand. Maintaining a quality standard right from the inception of a project is our top most priority.

Our team of talented professionals will execute your projects with dedication and excellence. We take ownership and accountability for the effort that goes into meeting our client’s needs.

Years of experience and proven success of delivering innovative custom solutions.

More posts by

One response to “Performing CRUD Operations in Power Apps using Sharepoint List – Part I”

  1. […] the previous 2 blogs of Performing CRUD Operations in Power Apps using any Data Source (part 1 and part 2), we have shown what data source we are using, Data Model View, how to connect to any […]

Leave a Reply

Your email address will not be published. Required fields are marked *

The maximum upload file size: 2 MB. You can upload: image, audio, video, document, spreadsheet, interactive, text, archive, code, other. Drop file here

Would you like to digitize your business and put it on the cloud?
Do you need clear, concise reports for your organization?