Form based on SQL Rows

(0) Share

Report

Posted on by MrDannyHarry

144

Hi all,

I have a SQL table which has a list of questions (new question each row).

I want those questions to be shown on the powerapps screen.

I want to use the Toggle (Yes/No) for each row in the table.

Example of the Questions Table.

Question ID	Question	Group ID
1	Test1	1
2	Test2	2
3	Test3	3

You then fill out the form on the powerapps and it saves the answers to another table like below

Question ID	Answer	Visit ID
1	1	Vis12
2	0	Vis12
3	1	Vis45

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@MrDannyHarry

My suggestion would be to create an app that looks like my picture below. I will give step-by-step instructions to allow you to build it like mine.

#1 Add a blank gallery to the app called 'Gallery1'. Set the Items property to

your_questions_table

#2 Place a label into the gallery row which will display the question. Put this code in the Text property of the label

ThisItem.Question

#3 Put a toggle into the gallery row. Name the toggle 'Toggle1'.

#4 Place a button below the gallery and use this code in the OnSelect property.

// creates the table of values to be inserted into the answers table ClearCollect(colResponse, ShowColumns( AddColumns( Gallery1.AllItems, "Answer",If(Toggle1.Value,1,0), "Visit ID", "Vis12"), "Question ID", "Answer" ) ); // inserts values into the answers table Collect(your_datasource_name, colResponse);

Note: I have manually assigned "Vis12" here but you may want to come up with your own method.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
MrDannyHarry 144 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney

Many thanks for this, I think i get the concept and what it needs to do!
My only question is how would I then patch the data in the Collection to SQL.

Cheers,
Danny

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@MrDannyHarry

I've made a small adjustment to my code above. I believe this will patch the data to SQL. If it does not work I have other ideas. Please let me know.

Collect(your_datasource_name, colResponse);

Fun fact: COLLECT can be used to insert new rows into any datasource. Not just collections!

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
MrDannyHarry 144 on at

Like (0)

Report
Copy link

Link copied!

Many thanks @mdevaney!!

Really helpful here and ha actually enabled me to do more things that I needed!

Was this reply helpful? Yes No