Rating Control Dynamically from SharePoint List in Power Apps



In Power Apps, the Rating Control empowers app creators to gather feedback and ratings from users, facilitating interactive experiences and valuable insights. While the Rating Control traditionally requires static configuration, it's also possible to dynamically populate its options from a SharePoint list. This functionality enhances the flexibility and usability of Power Apps solutions, enabling real-time updates and customization based on data stored in SharePoint lists.


  1. Dynamic Feedback Collection: Dynamically populating the Rating Control from a SharePoint list allows for real-time feedback collection, enabling users to provide ratings based on dynamic data.
  2. Customization: Tailor rating options to specific criteria stored within SharePoint lists, providing users with relevant and contextual rating choices.
  3. Centralized Management: Utilizing SharePoint lists centralizes the management of rating options, streamlining updates and ensuring consistency across multiple Power Apps.


  1. Real-Time Updates: The Rating Control dynamically reflects changes made to the associated SharePoint list, ensuring that users always have access to the latest rating options.
  2. Scalability: Easily scale the Rating Control to accommodate a wide range of rating criteria stored within SharePoint lists, without the need for manual adjustments.
  3. Integration: Seamlessly integrate rating functionality with other SharePoint data, leveraging the full capabilities of both Power Apps and SharePoint.

Limitations of Rating Control in Power Apps

  1. Limited Appearance Customization: The Rating Control in Power Apps offers limited options for customizing its appearance, such as size and color. Users may find it challenging to achieve highly specific design requirements.
  2. Single-Value Input: The Rating Control allows users to provide only a single value rating. It doesn't support multi-criteria or multi-dimensional ratings out of the box.
  3. No Built-In Analytics: Power Apps Rating Control lacks built-in analytics features for analyzing and interpreting rating data. Users may need to implement additional functionality or integrate with external analytics tools for detailed insights.

Step-by-step implementation

  1. Open Power Apps.
  2. Click on the "Create" button.
    Blank app
  3. Select "Blank app".
  4. Choose "Blank tablet app" to create an app for tablet devices.
    Blank tablet app
  5. Provide a name for your app.
  6. Select "Create" to proceed.

Insert ListBox


  1. Within the Power Apps studio, locate the "Insert" tab in the top menu.
  2. Click on "Input" and then select "ListBox" from the dropdown menu.
  3. Position the ListBox control on the desired screen of your app.

Steps for dynamically populating Rating Control from SharePoint List



  1. Navigate to the screen where the Rating Control will be placed.
  2. Select the Rating Control.
  3. In the properties pane, locate the "Default" property.
  4. Click on the formula bar next to the " Default " property.
  5. Write a formula to retrieve rating options dynamically from the SharePoint list. For example.

PowerApps code

First(Filter(DemoRatingList, Title = "Rating")).RatingNo

Replace DemoRatingList with the name of your SharePoint list and RatingNo with the column containing the rating options.

  1. Press Enter to apply the formula.
    Text Label
    Rating App
  2. Beatify your app.

By following these steps, you can successfully populate the Rating Control dynamically from a SharePoint list in Power Apps, enhancing the usability and functionality of your applications.

Demo rating control


In conclusion, dynamically populating the Rating Control from a SharePoint list in Power Apps offers numerous benefits, including real-time feedback collection, customization, and centralized management. While the Rating Control has its limitations, such as limited appearance customization and single-value input, its integration with SharePoint lists enhances its versatility and usability. The step-by-step guide provided empowers users to implement this functionality effectively, improving user engagement and driving actionable insights within their Power Apps solutions.

Similar Articles