List Screen gallery list add new row for input data

[Justas]

Hello, I am using list screen where in gallery list I need to add new row for user inputs when save button is pressed on previous row. I include screen shot of row. I dont know how to make that when save is pressed that all text input fields, dropdown fields and other input fields get recreated for new data to be inserted. Thanks.

[shailendra74]

Hi @Justas 

You can set the Items property of a gallery to some collection (collSample). onselect of save button:

1. Patch(collSample, Defaults(collSample), {FIELD1: value, FIELD2: value2}) // this would add the values entered in the controls
2. collect(collSample,{}) // this would add blank record with controls defined in the gallery

So onSelect of Save button, you should have:

Patch(collSample, Defaults(collSample), {FIELD1: value, FIELD2: value2});
collect(collSample,{}) 

Thanks:

[Justas]

In Gallery I am using filtering from database and it doesnt want to accept the new line. I attach screen shot.

[shailendra74 · Accepted solution]

HI @Justas 

onVisible of Screen, create a collection:

ClearCollect(collPatients, Filter('[...]', Booking_ID = Booking_ID_Var))

set collPatients as Items property of gallery.

To create a new record/line you can write:

collect(collPatients,{})

Thanks.

[Justas]

I am getting data from database, but when i try to save it it doesnt save inputs inside of database, I am using flow to save data in the database.