Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Entry form

Hi, I need help or advice on the best  implementation from a UI standpoint  to create an entry form.

the user will be entering data in two numerical fields for different categories each month. Some what an excel like experience is needed that is editable. The table will have different categories sub categories and data that correspond to each category and subcategory. Also need to have the ability to update categories or add new categories. Currently the data source is excel. There should be a month and year input  to specify the entry inputs and these will be columns in the database. Also they should be able to filter by category month and year in the view mode 


Community Support
Community Support

Hi @Sage22

Do you want to created an editable table and update it in PowerApps?

Could you please share a bit more about your scenario?

Actually, you could achieve this using a blank gallery. Besides, I suggest that you should create an ID column as the primary key if there is not a unique column existing in your excel table.

Here is a detailed newbie-friendly video to teach you how you create an edit grid in powerapps:

PowerApps: Quick Edit for Data Grids - YouTube

Hope it could help you at some degree.


Best Regards,

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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