Unanswered

Power Apps - Excel Data Table

(0) Share

Report

Posted on by slug

I need help in design of my power app. I have a 2 large 11 by 50+ tables in excel I need across separate sheets on powerapp. I would like for the user ideally to open up the power app and be able to scroll through the tables and be able to select individual cells and save that as a selection. And after they are done doing so, the next sheet would list their selections ask them why have they chosen those cells etc. and they would then comment, explain, write why they selected what they did and submit it to me. I have found sources of selecting the entire row, or column but that would become very wordy and cloggy collection. I am wondering if what I envision is possible to do. I already am thinking I may have to resort to the user selecting the entire row sadly. Or I wonder if adding another column with buttons straight down alongside the rows and then by clicking that button it will save the designated cell of that row possible. Thanks for your help and time whoever can help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @slug is that 11 rows, 50+ columns and you have two of those? also, you would like your user to select for e.g. cell "B3" and the rest of the logic follows selecting that cell?

Was this reply helpful? Yes No
slug 2 on at

Like (0)

Report

Yes essentially, that is the general idea, I have two data tables and want them to be able to just click the cell like a B3 and it saves each cell they select from the table, rather than an entire row or column, some of the columns have IDs, and Name titles, and others have descriptions, outcomes etc. paragraph style that they would read.

Was this reply helpful? Yes No