I'm creating a questionnaire that has 15 dropdown (radio button) answers that have a number value (1-5 based on selection). I have these as calculated columns in SharePoint. Once completed I want to open a 'read-only' screen that has these scores displayed (plus a total summed score). I've read that calculated values from SharePoint don't work very well in PowerApps and the calculations should be done in PowerApps but not sure how to get this working. Any help would be really appreciated.
Hi @Bonniedog2 here is how I achieved this:
I used a table structure for the Radio Button:
Table(
{
Name: "Unimportant",
Value: 1
},
{
Name: "Slightly important",
Value: 2
},
{
Name: "Moderately important",
Value: 3
},
{
Name: "Very important",
Value: 4
},
{
Name: "Extremely important",
Value: 5
}
)
I would then have multiple screens for each Question and then on the final screen have a submit button that will patch the answers to your SP list and have a label with the following to display the total Values added together:
This may not be the best way for you as this will require you to do some restructuring but this is the best way that I found to do this in a short time.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.
Thanks
Andrew
Create another screen which will show the ratings once the status is completed. In this screen, either fetch the records from list or show to value based on previous screen rating.
Thanks Michael - the questionnaire looks like below (there are 14 questions).
Example: Unimportant = 1, Slightly important = 2, up to 5. Each question has 5 options.
I have calculated columns for each in a SP List and the formula is: =IF([How important do you feel gender is to you?]="Unimportant",1,IF([How important do you feel gender is to you?]="Slightly important",2,IF([How important do you feel gender is to you?]="Moderately important",3,IF([How important do you feel gender is to you?]="Very important",4,IF([How important do you feel gender is to you?]="Extremely important",5,0)))))
Once the questionnaire is completed and submitted, it should go to a page with a score for each question plus a summed total score. Hope this helps.
Hi,
I'd have to see your table. Doing the calculations wouldn't be difficult or summing. Can you share what the screen looks like and how the values (for each one) works. i know you said 1-5 but I just need to understand how to tell, "based on selecting this, they get 1 or 5" and we can do it.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473