web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Submitting Checklist G...

Power Apps

Unanswered

Submitting Checklist Gallery data to an excel

(0) Share

Report

Report

Posted on by Angel5

Hello, so I am creating a checklist gallery, it has the question, a dropdown for the answer, and a comment section, when I press the submit button, I want the gallerys' info to be stored in an excel as linear data, ex Question 1, Question Answer 1, Comments 1, Question 2, Question Answer 2, Comments 2, but I cant see how to achieve it since all the questions are considered as one element in itself within the gallery, how do I achieve this functionality?

Also note that the gallery is connected to a table in a different excel table that has all the question, answer and comment columns.

Let me know if anyone knows any answers, thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Angel5 ,

Could you please show me some screenshots?

I assume Question ,Question Answer, Comments are three label controls in checklist gallery, you could try:

ForAll( 'Checklist Gallery'.AllItems, Patch( ExcelTableName, Defaults(ExcelTableName), { ExcelQuectionColumn:QuestionLabel.Text, ExcelQuectionAnswerColumn:QuectionAnswerLabel.Text, ExcelCommentsColumn:CommentsLabel.Text } ) )

Best Regards,

Bof

Was this reply helpful? Yes No
Angel5 on at

Like
a
(0)

Report
Copy link

Link copied!

They are three label controls, the problem is that when I hit upload, I want the data to look like this (see attachment) when it gets uploaded to their respective columns.

Was this reply helpful? Yes No

Join the conversation