cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mishatandon
Helper III
Helper III

New user | seeking guidance on how to build excel like tables

Dear community,

 

This is my first post and I am looking to build an excel data table like entry sheet. I am not sure if this is possible in power app and seeking guidance for the same. Below are the requirements:

 

1) I want 2 excel like tables to be displayed on the same page- one table would only have 'Un-editable' information for the user to refer to make edits / updates on the second information , 2 table will have 3-4 editable fields to be input / edited by user which means this table will be editable. The reason I am consistently saying 'table' is that look and feel should be like an excel table.

2) The editable table will have column validations. If validation is not met, user to be displayed with 'error message' and user 'cannot' save unless the validation is 'met'.

3) since this information would be accesses by multiple users who are 'owners' of data, as soon as they access the application they should only be presented with information where they are the 'owners'. Its a sort of row level security I want to apply.

 

These are deal breaker requirements for my stakeholder. Can somebody guide me on how to approach and build?

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@Mishatandon 

If your client requires an Excel-like table then honestly PowerApps is may not be the solution for you.

 

The current workaround is to create a repeating table in a Gallery as shown in the 3 part video series by Shane Young (link below).  This however, does not behave like an Excel table.  You cannot press enter to go to the next line.  

 

Link To Video:

https://www.youtube.com/watch?v=xgznk4XlPCo

 

If your stakeholder can accept the way PowerApps Repeating Tables Like Infopath work then I'm sure you can get requirements #2 & #3 working.  My recommendation is to watch the video, try to get it working, and post a new forums question each time you have a specific problem you want help with.  There are several broad questions in your single post and its not easy for our forum members to give a valuable response.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
mdevaney
Super User
Super User

@Mishatandon 

If your client requires an Excel-like table then honestly PowerApps is may not be the solution for you.

 

The current workaround is to create a repeating table in a Gallery as shown in the 3 part video series by Shane Young (link below).  This however, does not behave like an Excel table.  You cannot press enter to go to the next line.  

 

Link To Video:

https://www.youtube.com/watch?v=xgznk4XlPCo

 

If your stakeholder can accept the way PowerApps Repeating Tables Like Infopath work then I'm sure you can get requirements #2 & #3 working.  My recommendation is to watch the video, try to get it working, and post a new forums question each time you have a specific problem you want help with.  There are several broad questions in your single post and its not easy for our forum members to give a valuable response.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,548)