Unanswered

A editable table that allows for adding new, update and deleting of records.

(0) Share

Report

Posted on by Sage22

Hi,I am new to PowerApps but I am trying to build a form in a tabular format that allows the user to add new rows, update rows and delete rows using Excel as a data source. To start a new table form they would be prompted to select a month and year which would automatically be filled in the month and year column as a new row is being entered. Also based on a drop down selection the other fields will be pre-determined. They should be able to view the table list, edit rows and delete. Also I would like to add a filter pane that filters the table view. What is the best approach to this?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Hey! So, you should have a screen with a gallery and the dates

To filter you should use this: Filter(dataSource; Created > DatePickerFirstDate && Created < DatePickerSecondDate)

Then, on the OnSelect Property of the gallery you should navigate to a screen with a form to edit the line

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

@RezaDorrani has an amazing video for grid like data entry. Check it out.

Power Apps Editable Table/Gallery like Excel (Tutorial) - YouTube

Was this reply helpful? Yes No
Sage22 40 on at

Like (0)

Report

Also is it possible to based on a drop down selection, presents a complete list in a table to enter data for, for example. Item A is linked to items in another column (1,2,3) if I select A it will create : rows auto filled with 1, 2, 3

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Yes.

You cans et the default to Dropdown.Selected.Value

Or

If(DropdDown.Selected.Value = "1"; "1"; "anything but 1")

Was this reply helpful? Yes No
Roma Gupta 167 on at

Like (0)

Report

@Sage22 - What is the number of records in your excel source? Is this your sample source & will change in future?

Was this reply helpful? Yes No
Sage22 40 on at

Like (0)

Report

Well. It’s a predefined table with categories and subcategories and about 3 fields that are empty. Which will be the input fields. So the form will have a drop down list of categories and when one is selected it will prepopulate the other columns based on that category and the other input fields will be entering a number and the date selected will fill in the month and year. The categories may change but it will be done from the data source.

Was this reply helpful? Yes No
Roma Gupta 167 on at

Like (0)

Report

@Sage22 alright. Have a look at the video shared by @zmansuri & see if that resolves your problem

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

I have exact scenario in one of my app. 3 values will be pre filled from the above drop down. and user will just have to select month and enter budget. That video helped. Tell me if you need help

Was this reply helpful? Yes No