Hello
I'm new to PowerApps, but I am familiar with SQL and mobile programming. I'm currently having a hard time building a form, due to the fact that the data in it must come from multiple different tables.
These are the tables I'm working with:
QUESTIONARIES
QuestionaryID Description
0 "No questionary"
1 "Corrective"
2 "Follow-up"
3 "Start-up"
4 "Technical Visit"
OPTIONS
OptionID QuestionID OptionText
1 2 "Water pump"
2 3 "Oil Pump"
3 4 "Booster"
4 5 "Robot Arm"
...
QUESTIONS
QuestionID QuestionaryID OptionsID QuestionText
1 1 1 "Name of responsible person?"
2 1 37 "Which part is broken?"
3 1 1 "What caused the problem?"
4 2 2 "Number of burnt eletrodes?"
...
ANSWERS
AnswerID QuestionID AnswerText
196 19 "Peter"
197 20 "10"
198 21 "No"
...
I have already build a screen where the user can choose what type of Questionary the user would like to fill. The idea is that in the next screen, the form with the questions included in the chosen type of Questionary will be available for the user to fill.
To do this, I want to build a Card for each question, which will include a Label with the question text and a drop down with the relevant options for the user to choose an answer.
Describing in pseudocode, basically what I want to do is:
chosenQuestionaryType = # User input from previous screen
for question in QUESTIONS.where(QuestionaryID = chosenQuestionaryType):
label.setText(question.QuestionText)
dropDown.setAvailableOptions(OPTIONS.where(QuestionID = question.QuestionID))
And each question needs to have its answer stored as a line in the ANSWERS table.
Is it even possible to achieve somethings like this with PowerApps? Or should I go with a more customizable solution, like building the app from scratch with code?
Thanks in advance,
Éber
