Hello,
I'm new to Power Apps, so please bear with me.
I'm trying to develop a site quality inspection app where users can fill out a form with multiple questions for each site.
The questions will have different types of answers: some will require binary responses, some will be dropdown selections, and others will involve numeric values. Additionally, for each answer, there should be an optional text block where users can add notes.
Based on the weight assigned to each question, a composite score needs to be calculated.
This score should be displayed on a separate dashboard, specifically a SharePoint list, for each activity where the form was completed.
Each quality inspection activity can be performed multiple times at the same site, and it's important to track historical values for each site.
I am trying to follow the solution outlined below, but cannot figure out:
1. How do I add the score field?
2. How can I add a corresponding optional text field per each answer to the app?
3. How can I export the composite score value to a dashboard - Sharepoint List (or if there is a better suggestion)?
4. How can I keep historical values per each site inspection?
https://powerusers.microsoft.com/t5/Building-Power-Apps/Calculating-score-from-questionaire-reply/m-p/802259
Maybe there is already a canvas prebuilt app that can do what I am looking for?
Thank you

Report
All responses (
Answers (