cancel
Showing results for 
Search instead for 
Did you mean: 

Let Power Apps connectct to a rating column in Sharepoint

There is a nice Rating Button Within PowerApps, within Sharepoint as well, please let them communicate with each other!

E.G. if a make a rating within Powerapps, please store it within the Rating Column of Sharepoint.

 

rating.png2017-04-17 03_25_23 ‎- PowerApps.png

 

For more Infos, have a view as well within this discussion:

https://powerusers.microsoft.com/t5/PowerApps-Forum/How-to-connect-to-sharepoint-rating-column/m-p/3...

 

Status: New
Comments
KarinaArceo
Frequent Visitor

Besides the Raring with stars, also inclide the "Likes Botton", it would be great people can vote with power apps. Thanks!

razvan_voinea89
Microsoft

I'd really appreciate this feature tool as it would be very easy to create a feedback tool with sharepoint lists.

Jace
Advocate III

Power apps can pull in rating details, but is not capable of implementing functionality to rate within the power app.  This provides a weird experience should anyone want to design a UI based on a list that also requires rating.  

Please implement this so that we can provide a much richer experience within PowerApps

Nova13055
Frequent Visitor

Just faced this issue today while working with SharePoint Rating columns in PowerApps. It looks like we can only read the rating value but cannot update it.

I found one workaround for this issue, but we need to first change the rating column type from "ratings" to "likes". Here are the remaining steps:

1) In PowerApps when you connect the SharePoint source you will get some hidden rating columns like "Likedby" which stores the values of claims and related info (people type column) who have liked or rated the SharePoint item.
2) So, you need to pick this column for every item using "Thisitem.LikedBy" .
3) Then for "Onselect" event of a icon or button (Thumbsup icon which is not filled) , perform a clearcollect(LikedBy_col, Thisitem.LikedBy) and then use patch like this

 

// Patch to update the likedby_col collection to add current user details
Patch(
LikedBy_col,
Defaults(LikedBy_col),
{
Claims: "i:0#.f|membership|" & Lower(User().Email),
Department: "",
DisplayName: User().FullName,
Email: User().Email,
JobTitle: "",
Picture: ""
}
);

// Patch to update the likedby hidden column of sharepoint with this collection
Patch(
<Listname>,
ThisItem,
{LikedBy: LikedBy_col
}
)

In this way likedby column will get updated in sharepoint list . You can perform a rest call to see the value.

4) Now you can show the updated number of likes for each item as CountRows(ThisItem.LikedBy) in a label
5) Change the icon type from thumbsup to thumbsupfilled
6) now, when user clicks on the filled icon , do the oppsite of step 3 to clear the claims of the current user from the Likedby column