Unanswered

Gallery record edit/update in a form dropdown at power apps

(0) Share

Report

Posted on by nishak323

Hi All,

I created a form and gallery(datatable) as below. Form to get user inputs an store in excel, Datatable is to view the submitted data, update and delete operations.

Datasource : Excel at sharepoint

Form 1 :

Datatable:

Edit : Navigate(Screen1);EditForm(Form1)

If i try to edit a particular row its taking me to the form but not to the exact one

On click of edit india in datatable :

Note : Item has been updated in form 1 (datatable.selected)

Looking for your inputs.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Sort by

TSte 246 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
For the EditForm Properties:
DataSource: Excel on Sharepoint
Item: Gallery(1?).selected

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@nishak323

You can set the edit button to set the selected data as a variable and then pass it to the form.

OnSelect of the Edit button

Set(editRecord,DataTable1.Selected);

Set item property of the edit form to editRecord variable.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
TSte 246 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey,
i was confused, in Title he mentioned gallery..
However, also for Datatable no variable is required...
just put navigate(screenXX) on the edit button
EditForm Item: DataTableXX.Selected..

Was this reply helpful? Yes No
nishak323 49 on at

Like
a
(0)

Report
Copy link

Link copied!

@narayan225 thanks for you inputs ,but its not taking me to the form with exact selected gallery record.

Was this reply helpful? Yes No
nishak323 49 on at

Like
a
(0)

Report
Copy link

Link copied!

@thsteh thanks for your inputs ,But its not giving the expected result.Its not showing up the table data if i change the editform item as you mentioned

Was this reply helpful? Yes No
TSte 246 on at

Like
a
(0)

Report
Copy link

Link copied!
so your Editform looks like this?
EditForm Properties:
DataSource: your Excel on Sharepoint
Item: Gallery(1?).selected or DataTable(1?).Selected
if you have done changes with the EditForm but they don't appear as you have don them, be sure to have either SubmitForm() or a Patch() Function on your submit form aswell as the Refresh(your excel) function after your Submit or Patch function

Was this reply helpful? Yes No
nishak323 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @thsteh ,
Thanks again for the input.Yes am using submit form ,Patch
Form : Country : Dropdown and State : Combo box
Datatable:

If I choose an row to edit at datatable its taking me to the form but the state value is empty :
Output as of now :
Expected output :

Thank you !

Was this reply helpful? Yes No
TSte 246 on at

Like
a
(0)

Report
Copy link

Link copied!

please send e screenshot of the Properties of the "State" Datacard, maybe there is something other then it should be, i can't reproduce your error...

Was this reply helpful? Yes No
nishak323 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is the property of state:
Thank you !

Was this reply helpful? Yes No
TSte 246 on at

Like
a
(0)

Report
Copy link

Link copied!

It def. looks different then on my FormEdit, but i got mine from Dataverse not from an Excel, don't know if there are differences..
try to use the same code in default as in Items and see what happens..

Was this reply helpful? Yes No