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.

Super User
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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 73 members 4,133 guests
Please welcome our newest community members: