web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Design Q&A pattern usi...
Power Apps
Unanswered

Design Q&A pattern using Model driven app

(0) ShareShare
ReportReport
Posted on by 13

Hi,

 

I'm looking out for options on how to design or go with best approach for the below requirement,

 

A) Have set of Questions need to be uploaded from user defined excel format and import it into data verse.

B) Display the Questions in the App(model driven view).

C) Submit the Answer's to the respective questions and the answers should get mapped correctly against respective question in dataverse.

 

Note : Questions volume would be 70 to 80.

 

Appreciate if you could throw some light on this.

Thanks

Categories:
  • BCLS776 Profile Picture
    8,994 Moderator on at

    There are a few different ways to accomplish something like this. First, are you aiming for multiple choice & true/false style questions? Those are easiest to handle programmatically. See opentdb.com for an API with good data structure that handles this situation.

     

    For the app itself, you could build it off of potentially 2-3 tables, with these suggested columns:

    Questions

    QuestionText

    CorrectResponse

    IncorrectResponses

    QuestionID

     

    Quizzes

    QuizID

    UserID

    QuizDate

    QuestionID

    UserResponse

    ResponseIsCorrect

     

    Be careful with bulk CSV uploads of questions - those require lots of checks to make sure data quality is good going in.

     

    That's a start, hope it helps.
    Bryan

  • KishoreJ Profile Picture
    13 on at

    Hi @BCLS776,

     

    Thanks for your suggestion, have a clarification on the approach.

     

    My requirement is, it has only Static Questionnaire with all textbox as the User response /Answer's, so my challenge is importing the Questionnaire excel data(user randomly selected format) to data verse. Next display the Questions in the App screen by screen capture the Answer's and export the excel with Answer's in User defined template or format.

    Thanks,

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 236 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard