Get List Control Dynamic value from SharePoint List in Power Apps

Power Apps


The List Box control in Power Apps allows users to display a list of items, enabling selection and interaction. Integrating data from SharePoint further enhances its functionality, providing a dynamic and efficient way to manage information. In this article, we'll delve into the benefits, features, and limitations and provide a comprehensive guide on how to use the List Box control and retrieve data from SharePoint in Power Apps.


  1. Data Visualization: List Box facilitates the visual representation of data, making it easier for users to comprehend information.
  2. Interactivity: Users can interact with the List Box to select items, facilitating data manipulation and decision-making.
  3. Integration: Seamless integration with SharePoint enables access to real-time data, ensuring data accuracy and consistency.


  1. Customization: Customize the appearance and behavior of the List Box to suit specific app requirements.
  2. Data Binding: List Box can be bound to SharePoint lists, enabling automatic data updates and synchronization.
  3. Filtering and Sorting: Implement filtering and sorting functionalities to enhance data retrieval and organization.


  1. Data Connectivity: Dependency on internet connectivity for accessing SharePoint data may affect app performance.
  2. Performance: Large datasets from SharePoint lists may impact app responsiveness and loading times.
  3. Security: Ensure proper permissions are set to access SharePoint data securely within Power Apps.

Step-by-Step Guide

  1. Open power apps: Launch Power Apps from your preferred platform.
  2. Create a new app: Click on the "Create" button to initiate a new app creation process.
    Blank app
  3. Select blank app: Choose "Blank app" from the available templates.
  4. Choose device type: Opt for "Blank tablet app" as the app type, suitable for tablet devices.
    Canvas app from blank
  5. Provide app name: Enter a name for your app to proceed with the creation process.
  6. Create the app: Click on "Create" to create your app and enter the app development environment.
  7. Insert list box control: Drag and drop the List Box control from the left-hand menu onto your app canvas.
    Item padding left
  8. Setlist box properties: Customize the appearance and behavior of the List Box control as per your requirements.Select a data source
  9. Connect to SharePoint list: Navigate to the Data tab and click on "Add data" to connect to your SharePoint list.
  10. Choose SharePoint as a data source: Select SharePoint from the available data sources and provide the necessary authentication details.
  11. Select SharePoint list: Choose the SharePoint list from which you want to retrieve data for the List Box.
  12. Bind list box to SharePoint data: Set the Items property of the List Box control to the SharePoint list column containing the desired data. Use this formula in item properties: “DummyListTitle[@Title]”. Here, "DummyListTitle" is your List Name, and in square brackets, "Title" is your column name.
    Dummy list title
    Hr it and finance
  13. Test your app: Preview your app to ensure the List Box is populated with data retrieved from the SharePoint list.
    IT and finance


The List Box control in Power Apps, coupled with SharePoint integration, offers a powerful solution for displaying and managing data in custom applications. By following the step-by-step guide provided in this article, users can leverage the capabilities of the List Box control and seamlessly retrieve data from SharePoint, enhancing the functionality and usability of their Power Apps projects.

Similar Articles