Skip to main content

Notifications

Community site session details

Community site session details

Session Id : DalRalLFhSddPA0oag1bgx
Power Apps - Building Power Apps
Unanswered

Power Apps - Excel Data Table

Like (0) ShareShare
ReportReport
Posted on 8 Aug 2023 20:08:10 by 2

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. 

  • slug Profile Picture
    2 on 09 Aug 2023 at 15:09:40
    Re: Power Apps - Excel Data Table

    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. 

  • rubin_boer Profile Picture
    4,841 Super User 2024 Season 1 on 09 Aug 2023 at 07:32:14
    Re: Power Apps - Excel Data Table

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 98 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard
Loading started