Skip to main content
Community site session details

Community site session details

Session Id : /a/LiFNN7OHQh/sdpt3f4q
Power Apps - Building Power Apps
Answered

Display calculated fields on a 'scores' page

Like (0) ShareShare
ReportReport
Posted on 3 Oct 2023 00:31:26 by

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.

  • Verified answer
    AndrewR1 Profile Picture
    1,572 Moderator on 03 Oct 2023 at 08:08:37
    Re: Display calculated fields on a 'scores' page

    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: 

     

    AndrewR1_1-1696320294024.png

    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

  • Jayant_Kumar Profile Picture
    4 on 03 Oct 2023 at 07:35:22
    Re: Display calculated fields on a 'scores' page

    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.

  • Bonniedog2 Profile Picture
    on 03 Oct 2023 at 04:55:06
    Re: Display calculated fields on a 'scores' page

    Thanks Michael - the questionnaire looks like below (there are 14 questions).

    Bonniedog2_0-1696308709383.png

    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.

  • Michael E. Gernaey Profile Picture
    45,665 Super User 2025 Season 2 on 03 Oct 2023 at 00:51:08
    Re: Display calculated fields on a 'scores' page

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473