cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niteesha
Level: Powered On

editable data table or gallery

How can we edit the values in the data table and place controls (drop down, text boxes, etc). 

4 REPLIES 4
JoshHavens
Level: Power Up

Re: editable data table or gallery

To edit a record in a gallery...

  1. You can insert various controls like a text input within a gallery.
  2. Set the default value of the text input control to ThisItem.YourItem. Also remember to name this text input control. 
  3. Then create an icon within the gallery with a patch function that will patch your data source with the contents of the text input. 
Patch('YourData', First(Filter('YourData', ID = ThisItem.ID)),  {ITEM: txtInput.Text})
Super User
Super User

Re: editable data table or gallery

Along with what @JoshHavens @posted, you may want to check out this blog post: https://powerapps.microsoft.com/en-us/blog/editable-tables/

It has an easy to follow walk-through on creating an editable gallery with immediate updates.

Dual Super User
Dual Super User

Re: editable data table or gallery

Hi @niteesha , 

 

For doing so, create a blank gallery, and select its first item at the top and while it is selected, insert text Inputs/Dropdown controls into it. You can set their default values corresponding to the attributes of your data source.
 
You can either create a new record or update an existing one. For updating an existing record, please make sure that you have an attribute that user can not change so that you can map it to data source to find the record that needs to be updated.

For patching the changes, you can either update the OnChange property of your controls or you can add a seperate button for each item or a button that bulk edit all the items in the gallery at once.
 
Patch Formula:
New Record: Patch(TestDataSource,Defaults(TestDataSource),{Title:TextInput1.Text,Value: Dropdown1.Selected.Value})
Existing Record: Patch(TestDataSource,LookUp(TestDataSource,Name=Label1.Text),{Title:TextInput1.Text,Value: Dropdown1.Selected.Value})
 
MicrosoftTeams-image (34).png

 


Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Highlighted
Super User
Super User

Re: editable data table or gallery

@niteesha 

Great suggestions by @JoshHavens@wyotim  and @yashag2255 - give them a try.

 

I just wanted to add - you had originally mentioned "data table or gallery".  All of these suggestions are based on a Gallery - where you can do such things.  You cannot do this type of thing to a DataTable control. 

Not sure you entirely wanted to focus on a Data Table, but just wanted to set that point.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,309)