Logo
banner

Blogs

Performing CRUD Operations in Power Apps using SharePoint List – Part II

, August 4, 2023 697 Views

In the previous blog part, we have seen how to connect to any data source in Power Apps and perform CRUD operations using SharePoint List as an example.
In this blog, let’s see how to read the data from any data source in Power Apps.
Reading Data from Data Sources in Canvas Apps:
In the already provided Blank Screen in Power Apps:

  • Rename the screen to “scr_View”. [We’ll be using this screen to view the records present in the
    list_PatchingFromPowerApps].
  • Add the Labels which will act as Headers in an orange background as shown in the below image.
  • Add Blank Vertical Gallery below the Header Labels. Use “list_PatchingFromPowerApps” as its Data
    source
Master CRUD operations in Microsoft Power Apps

Master CRUD operations in Microsoft Power Apps

  • Now to read the data from SharePoint List “list_PatchingFromPowerApps”, we’ll be adding several labels
    inside the Blank Gallery and place them as per our readability and updating its “Text” Property as shown in the below image.

Note: The labels will be blank for you as you don’t have any records in your data source

Master CRUD operations in Microsoft Power Apps

ID: “ID: ” & ThisItem.ID
Name: ThisItem.Name //Single line of text Column
Age: ThisItem.Age //Number Column
Description: ThisItem.Description //Multiple lines of text Column
IsPass: ThisItem.IsPass //Yes/No column
Fees: “₹ ” & ThisItem.Fees //Currency Column
Favourite Website: ThisItem.’Favourite Website’ //Hyperlink column
Date of Birth: Text(ThisItem.’Date of Birth’, “dd/mm/yyyy”) //Date Column
Grade: ThisItem.Grade.Value //Choice column
Favourite Subject: ThisItem.’Favourite Subject’.Value //LookUp Column - Single Value
Favourite Book Genre: // Choice Column- CheckBoxes

If(
    IsBlank(ThisItem.'Favourite Book Genre') || IsEmpty(ThisItem.'Favourite Book Genre'),
    "",
    Left(
        Concat(
            ThisItem.'Favourite Book Genre',
            Value & ", "
        ),
        Len(
            Concat(
                ThisItem.'Favourite Book Genre',
                Value & ", "
            )
        ) - 2
    )
)
//Left(string,len(string)-2) -- to remove the last comma and a space.


Likes To PLay Which Games?:  //LookUp - Multiple Values

If(
    IsBlank(ThisItem.'Likes To PLay Which Games?') || IsEmpty(ThisItem.'Likes To PLay Which Games?'),
    "",
    Left(
        Concat(
            ThisItem.'Likes To PLay Which Games?',
            Value & ", "
        ),
        Len(
            Concat(
                ThisItem.'Likes To PLay Which Games?',
                Value & ", "
            )
        ) - 2
    )
)
//Left(string,len(string)-2) -- to remove the last comma and a space.

Conclusion on performing CRUD operations in Power Apps using SharePoint List:

Hereby, we have shown how to read data from columns from all possible data types. Also, we demonstrated how to
fetch the data which is stored in comma-separated format. Thereby, now we have covered almost every possible use
case which one faces frequently to read data from any data source.


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

2 responses to “Performing CRUD Operations in Power Apps using SharePoint List – Part II”

  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 data source […]

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?