Answered

Voting App

(0) Share

Report

Posted on by Thanasis

Hello,

I am creating a voting app for our Halloween party. I have a Sharepoint list that has different columns for each costume category (Best Costume, Funniest etc). To vote, the user selects from a drop-down that has all the associated ID's for each costume entry - 1,2,3,4, etc. When done, the user selects a "Submit" button which writes the results to the Sharepoint list.

What I'm trying to do is have a total for each costume voted for (Most votes for Best Costume, Funniest, etc).

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Thanasis ,

Have you tried Microsoft Forms ?
I think this app is a better choice than PowerApps to achieve your goals.

Can you share more about your issues ?
Thanasis on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @gabibalaban ,

I do use MS forms , so people will be able to upload their costume pictures, then I run a flow that takes all those pictures and puts them into a SharePoint list. Next I created my PowerApps that displays all those pictures for our employees to see, and what I have is a dropdown with all the entry ID's , so people click the ID they want to vote next to the costume categories (Best costume , funniest, etc.) then by clicking the submit button I want that data to go to the SharePoint list and total that column.

Sharepoint list
Column :ID Column : Costume Name Column: Best Costume Column: Funniest Cost Column Scariest Costume
1 Zombie 3 0 1
2 Witch 0 5 2

Let me know if you need any more information. Thank you again for any help you can offer
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Thanasis,

First of all, please read @WarrenBelz 's answer to this topic:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Get-image-from-Sharepoint-list-or-library-and-show-the-picture/td-p/471561
Please note that you have to use a DocumentLibrary instead of a SharePoint List.

In PowerApps insert 3 galleries with layout set to Title and Image, one for each category : BestCostumeGallery, FunniestCostumeGallery,ScariestCostumeGallery.
Set the following properties of each galleries similar to:
Items -> DocumentLibrary
TemplateFill -> If(ThisItem.IsSelected,SelectedColor,GalleryBackGroundColor) (you can set this color as you like)
Inside Galleries
set Image control -> Image property -> ThisItem.'{Thumbnail}'.Large
set Label control -> Text property -> ThisItem.CostumeName

Outside galleries on the screen, insert a button control and set OnSelect property to:
Patch(ResultList, Defaults(ResultList), {'Best Costume':BestCostumeGallery.Selected.ID, ,'Funniest Cost':FunniestCostumeGallery.Selected.ID,'Scariest Costume':ScariestCostumeGallery.Selected.ID}).

You can insert a label control outside galleries to see the selected item setting the text property to: BestCostumeGallery.Selected.CostumeName ...

Here is my test, of course I'm not a very good designer:
Thanasis on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you @gabibalaban

I think that would work. One last thing how would my column lets say Best costume will be adding more votes ? Let say someone else also votes for that costume I want to go to that column to that specific ID and add +1 ?
lamgunbo 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Thanasis
what is your code in the button to increment the number by 1 in the column number when voting? Thank you.