Answered

Simple Edit Grid, Data not saving

(0) Share

Report

Posted on by cmdaniels1986

Hello,

I am working on my first power app, and I am running into a really basic issue. I am trying to create an editable grid. I am able, through a vertical gallery get all of my fields in place.

I added a button for Add New Record, which works perfectly... however, whenever I add/change data in the table, it doesn't save back to the table. Is there some sort of a "Submit" or "Save" feature that I need to utilize whenever an edit is made to the underlying data? If I go into the Table manually, and add rows/Change Data, and then refresh the app, the changes show up there, but it doesn't seem like I am able to actually change it from the grid.

In my screenshots, in the first one this is Data I entered. The second screenshot is when I click "Add New". My code adds a new record (which is saved to the Table), but my changes earlier are removed.

Any help is appreciated! I am developer, and I am finding this low-code approach more frustrating than just developing it.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@cmdaniels1986

In the grid line, you need another icon, like a check icon or save icon with the OnSelect property.

Patch(yourdatasource, ThisItem)

Was this reply helpful? Yes No
cmdaniels1986 12 on at

Like (0)

Report

It still isn't working. I don't get an error but it says "This Formula has side effects and cannot be evaluated.". This seems like a pretty basic function. Any ideas?

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
@cmdaniels1986

Try

Patch(yourdatasource, ThisItem,{field1:Textinput1.Text, field2:TextInput2.Text, field3:Dropdown1.Selected.Value)})

replace the field names with your column names and the textInput and Dropdown with the names of the controls on the line.

Was this reply helpful? Yes No
cmdaniels1986 12 on at

Like (0)

Report

That's it. Thank you very much. I spent years building forms in .net forms builder and MS Access, so I know conceptually what to do. Anyway, thank you very much.

Was this reply helpful? Yes No