Unanswered

Editable grid prepopulate certain controls with values from first record

(0) Share

Report

Posted on by julijazas

820

I am making excel like editable grid in gallery and i want to be able to add new record(row in gallery) and it on creation should autofill some fields?

Is it possible to do that?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@jja

Set default values in the controls and patch the row to your dataset. Patch(dataset,Defaults(dataset)). Sort the gallery to the ID, descending so the blank row is at the top.

Was this reply helpful? Yes No
julijazas 820 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp
Can you please explain little more on setting default values on contrlos?
as an example i have in a gallery combobox control. In the Items i set it's Choices('Equipment type') and in defaultselecteditems i set to ThisItem.'Equipment type' so if users loads existing list all it gets populated with existing data because user might open let's say not finished project and continue adding new rows. Where do i need to set up this default data on controls? I personally do not know this default data it is user who will choose some data from comboboxes or enter manually in textinput and after that i want some certain fields(I know what fields) to be autopopulated when user will add new row

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jja :

You can set the default value for the specified field directly in the data source, and then the default value will be automatically filled when you add a new row:

For example, I assume the data table is a SharePoint list:

After this configuration, when you add a new row, the ChoicesColumn field will be filled with 'Choice 1' by default.

Best Regards,

Bof

Was this reply helpful? Yes No
julijazas 820 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft
no it is not the case. It is user who will set some default values upon first record entry. Then when entering second, third, etc record it has to copy and patch some fields from the first record

Was this reply helpful? Yes No