Power Platform Community Forum Thread Details

I am Power Apps beginner working on a Power Apps that reads questions from a Sharepoint list (using a dropdown box to determine which questions get loaded), adds those questions to a gallery and then allows someone to answer those questions then I want to save the answers to a table in an Excel spreadsheet but I'm struggling to figure out how to add the data.

The Excel file has a table already that has a header row as the first row and each column has the question in that header row. Here is an example of part of that table.

I have this added as a data source in my app and I can do

ClearCollect(tableCollection, Defaults(Table1));

to get the schema of that table as a collection.

The questions from the Sharepoint list are in a gallery, the text label comes from the Sharepoint list and has a text box to put the answer.

After clicking a button, all the questions and answers get added to a collection that I was hoping to then use to add to the Excel table.

ClearCollect(questionsCollection, ForAll(textQuestionsGallery.AllItems, {
    question: textQuestionsLabel.Text,
    answer: textQuestionsInput.Text
}));

I was hoping to match each 'question' in the collection to the header name with the same question in the table, add a new row with each answer to the corresponding cell in that row but I cannot figure out how to do this. I can't hard code in the column names because each set of questions will be different, so I need way to dynamically match the questions from the gallery to the table.

Categories:

Building Power Apps