Creating a Dynamic Checklist

Hello there, I am trying to create a dynamic checklist application in Power Apps, so here is my problem:

1. The checklists are already made in excel, but I need power apps to read off the data in them so that it gets displayed in the app, I could use a gallery, the problem is that when they fill out the checklist on the app, I need that info to get stored on different excel as Linear Data, For example: Unique id:, Created By, Date Submitted, Project, Question 1, Question Answer 1, Question Comments 1, Question 2, Question Answer 2, Question Comments 2, And so forth. I couldn't achieve this functionality with a gallery since all the questions would be under "Questions" in the gallery, so theres no way to properly identify each row of the gallery needs to be submitted to this specific column in the excel. I achieved this with a canvas, but that only made the questions and everything else be static, I want it to be as dynamic as possible so if there is some revisions to those checklists the power app can refresh its source accordingly, I dont know if something like this is possible but if so please let me know.

Categories:

General Questions