Entry form

[Sage22]

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 

[v-qiaqi-msft]

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.