Powerapps how to Vote on Likes for a Question

[Manny123]

Hi Team, I was wondering if you can help me?

I am very new to Powerapps - but I was wondering if it was possible to create an app which can allows multiple users to post questions and then allow team members to put a vote on the different questions (e.g. thumps up /Like counts)? Ideally would want the list of questions to be ordered based on the number of likes received.

I have created a basic Sharepoint list which captures Employee Name and Employee Questions.

Thanks, Manny.

[BCLS776]

If you add one more column to your list, one for Likes (number), you can do that. In your app, you'll make a button that reads the current value of Likes and if your user gives it another vote then you'll increase the number by one. It will look something like:

Patch(
    mySPList,
    ThisItem,
    {
        Likes: ThisItem.Likes + 1
    }
)

[Manny123]

I have created extra column called Likes (numeric values). But I dont understand the formula or where the button should be. 

Basically I want users to post questions/ideas and team members to like(vote) on the questions/ideas.

[BCLS776]

OK, here's a screenshot of a simple app that counts "likes":

I assume you already have your SP list connected to a gallery, so you can see your list of questions. Place an icon or other image in the first gallery, and in its OnSelect property paste the Patch code I shared earlier. Now, each time you click on the icon, the Likes column for that item increases by 1. To help see this in action, I also put in a label and set its Text property to ThisItem.Likes

How does that work for you?

[Manny123]

Hi Thanks for the update. I have created the "Thumps Up" icon into the Gallery and also the "likes". When I copy the code into the icons "On Select" I get an error message: "Name isnt invalid. This identifier isn't recognized".  My SharePoint list is called Vote.  I am using 1 Gallery. I have attached screen shots of my app.

[BCLS776 · Accepted solution]

Replace "mySPList" above with the name of your list (Vote) and the error should go away.

[Manny123]

Brilliant. It worked! Thank you so much! 🙂

Is there a way to do a filter so the questions with most "likes" are at the top?

Thanks again!

[Manny123]

Forgot to mention - At the moment the sort is done using the following formula: 

SortByColumns(Filter([@Vote], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

[Manny123]

Sorry also is there a way so a team member can only vote once per question? i.e. can only click on Thumps up like once per question.

[BCLS776]

---

@Manny123 wrote:

Forgot to mention - At the moment the sort is done using the following formula: 

SortByColumns(Filter([@Vote], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

---

Your current statement is a combination searching function and sorting function. If you make this one change, it will start sorting by Likes, while keeping the searching function intact:

SortByColumns(Filter([@Vote], StartsWith(Title, TextSearchBox1.Text)), "Likes", If(SortDescending1, Descending, Ascending))