Answered

Integrating like button in powerapps in Sharepoint list

(1) Share

Report

Posted on by Community Power Pla...

I would like to have a *like* button for users on a gallery which is comment , where people can come and press a like on the comment or remove the like but It should be only enabled once per users . once the user hover over the counter for the likes then then people who have like the comment should be seen in another gallery.

I found a related video to this thing but unfortunately the data was called from Excel sheet and I would like to have it from a Sharepointlist for which the method is different.

(15) HOW TO: Add 'Like' Functionality To PowerApps - YouTube

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

BCLS776 8,994 Moderator on at

Like (2)

Report

A Sharepoint list is structurally much the same as an Excel table data source, so making the change involves creating the necessary columns and then adjusting the app code to refer to the list rather than Excel. Is there a specific issue you are running into difficulties?

Bryan

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for your prompt reply ,
First step what I did was create two column called LikesID and CreatorEmail and then I made a like *icon* and Onselect property used

Patch(
'IT Helpdesk Comments',
Defaults('IT Helpdesk Comments'),
{
LikesID:ThisItem.LikesID,
CreatorEmail:User().Email
}
)

then I would like to enable a the user to click only once and have it disable so on Displaymode of like icon , I get delegation error on CreatorEmail could you kindly help me debug the delegation error on this.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (1)

Report
Firstly, your function should work no matter the delegation limits. The CountRows() function is the non-delegable part, and as long as it counts at least one row then your app logic still applies. It doesn't matter if it counts 1 row or 2000 - your result is the same. If you still need to make it delegable, use With():
With( wFilter: {Filter( 'IT Helpdesk Comments', CreatorEmail = User().Email, LikesID = Text(ThisItem.LikesID)} ), If(CountRows(wFilter)>0, Displaymode.Disabled, DisplayMode.Edit ) )

Also, consider using LookUp() instead of Filter() in this case. LookUp() returns as soon as it finds a matching record, while Filter() goes through the entire table. This might help app performance a bit.

Hope this helps,
Bryan

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Unfortunately I tried the Solution provided above but I got the error ,

I thought the problem was with the With statement so I changed the curly bracket but then it error showed up in IF statement and yes I also tried with Lookup but sadly I did not work.

The LikesID is a Number field and CreatorEmail is a Single line of Text .

I hope this helps and thanks alot for your constant support and help.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (1)

Report
The LikesID is a Number field and CreatorEmail is a Single line of Text .

I hope this helps and thanks alot for your constant support and help.

Thanks for catching my free-typed syntax error. Your code quoted above should work and I can get a similar piece of code in one of my test apps to work with your syntax. To troubleshoot, could you do two things?:
Make sure this code appears in the DisplayMode property of your Likes icon. I think this is the case, but let's verify it.
Can you share the error message getting flagged on the If() statement? I note that the expression "Displaymode.Disabled" has not been changed by the Intellisense feature to "DisplayMode.Disabled", so a re-type of that piece of the code may be all that is necessary to get this working.
Bryan

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report
@Anonymous ,

As per the PM you set me - firstly @BCLS776 is correct on the information you provided - your issue is with the field type (as you have now confirmed, LikesID is numeric)

With( { wFilter: Filter( 'IT Helpdesk Comments', CreatorEmail = User().Email && LikesID = ThisItem.LikesID ) }, If( CountRows(wFilter)>0, Displaymode.Disabled, DisplayMode.Edit ) )

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Thanks alot Bryan and Waren , It worked !

But another problem is I am getting delegation error on this code as well

If( CountRows( Filter( 'IT Helpdesk Comments', LikesID=ThisItem.LikesID ) )>1, CountRows( Filter( 'IT Helpdesk Comments', LikesID=ThisItem.LikesID ) )& "people likes this ", CountRows( Filter( 'IT Helpdesk Comments', LikesID=ThisItem.LikesID ) )=1, CountRows( Filter( 'IT Helpdesk Comments', LikesID=ThisItem.LikesID ) )& " person likes this ", "Be the first to like this "

But I seem to be getting delegation error and I tried to make a work around by using the With on to my Filter to avoid it and so far this part of the code works.

With( { LFilter: Filter( 'IT Helpdesk Comments', LikesID = ThisItem.LikesID ) }, If( CountRows(LFilter)>1, "people likes this " ) )

The code above works till when I try to add another statement countrows statement where =1 then it gives me the error.

Thanks once again both of you
Arsal

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report
@Anonymous ,

You just need to watch your brackets - a hint for you, always indent your code as you write it - you will pick a lot of syntax issues visually

With( { LFilter: Filter( 'IT Helpdesk Comments', LikesID=ThisItem.LikesID ) }, If( CountRows(LFilter)>1, Text(CountRows(LFilter)) & " people likes this ", CountRows(LFilter)=1, "One Person likes this ", "Be the first to like this " ) )

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz ,
I tried and unfortunately the counter where the number of likes are added does not work ,

It gives me the error report invalid argument. Expecting one of the following: Text,Number,Boolean,optionSetValue,ViewValue.

I dont know if this is important or not but I also added on the on select part the following statement

So that when I can create the gallery I can show peoples image and make the Showwholiked gallery visible when clicked on to the likes seen.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report

@Anonymous ,
Amended on initial post

Was this reply helpful? Yes No