How Create Editable Excel Like Table in PowerApps

Using Power apps Galleries to create tables that update your data source live. I use sharepoint Lists as my data table.

[@delicious9930]

You have no idea how long I’ve been looking for this hack, Thanks a lot!

[@StephanOnisick]

Really Nice--Something I've been struggling with.

[@PranayPawar1991]

That's great stuff.. Thanks for such nice video.. One doubt i have.. What is we want a column like status where user can select from drop down menu to select 1 value and it should get updated on database

[@rmk_ro]

Exactly what I was looking for!, Thank you!

[@almaqasim932]

It worked on my data perfectly, thanks. Why are you not uploading more such short and practical PowerApps videos? I don't see more on your channel.

[@aytekgungor3749]

Thanks bro. You're a life saver.

[@OptimalTrainingGroup]

Awesome! Very helpful. Thanks!

[@DanRyan01]

Great Job! well done, easy to understand

[@DevendraSingh-tx2pt]

This is really nice video. Can we add 50+ columns in gallery editable like excel spreadsheet. If not then how can do that.

[@imotumbokanaka4157]

Hi stephen u not adding data, u just changing data, is it possible to add record from this gallery?

[@roxanarodriguez1828]

Heroooooooooooooooooooooo, I can't thank enough, saved me to get fired jajjaj

[@theelectricsheep8204]

Just what I wanted, thank you.

[@tonystanford6825]

Thank you for this video! I have clicked Label for all the ones I need but I have a Date column which does not transfer over. Any ideas please?

[@stebbey6006]

Same here but with Currency. did u find a solution yet?

[@tonystanford6825]

@@stebbey6006 Try formatting as Currency in your Excel table

[@SAULSM17]

Muchas gracias!

[@btoz6237]

Nice video, thanks

[@jl1399]

This is connected to a SharePoint list and updates the list?

[@learningtechs1267]

Is it fine using Text boxes for Country and City? Is it possible to use a Dropdowns and Lookup columns in similar way.. Please explain

[@robmcevoy7329]

cheers for the video helped immensely

[@RagavanRajanrahav]

hi @Stephen Homa thanks for this really helpful. I have a same scenario but when I try to reference my SharePoint column similar to your 'Favourite Band' I am getting `data type is unsupported for evaluation` pls help

[@clatz13]

Wow. Thank you!!!!

[@fhp9st870]

Very interesting. thank you.

[@jujubalismel]

Hi @Stephen thanks a lot for the video, I am wondering if we have a lot of columns in the table, how we can add horizontal scroll bar?

[@steve78951]

Juli lis I recommend breaking up the fields to different views logically. Too many entries on one page is a bad user experience. Think if you had only one page to enter all your tax info. Turbo tax breaks it up to keep it simple. You can still map all the data back to the same table

[@derekgray3019]

Hi Julie - you might find this one will help you with a horizontal scrolling editable grid gallery kzbin.info/www/bejne/rXqZhHt9hp50isk. Rezza Dorrani has lots of tutorials that I've used. I have also solved an issue watching this tutorial to patch the changes

[@solageormeich]

How to add slicer to edit the old data and save it in that same field

[@Jime1306]

hi! thanks for the video! how did you manage to link the first table to the drop down menu you have on top? I'm new to PowerApps and I still can't find an answer to this :(

[@steve78951]

Jimena Zumaeta - Items property of table. Discint(Filter(Yourdatasource, favortieband = dropdown1.selected.value),favoriteband) Just change the values to your data source and columns

[@Jime1306]

Stephen Homa thank you!!! It worked with =myDropdownvalue.Selected.Id , where the Id is the variable in the drop down ... but weird but it worked :)

[@itmesneha]

I have way more columns, what do I do?

[@v.s.5460]

What about the case when you have the app integrated into a Power BI report and you want the users to be able to submit the data they entered back to the database? Usually, this happens with a button which OnSelect property is set to SubmitForm(FormName). However, the function SubmitForm doesn't accept Gallery as an argument, only Form.

[@RojinaPanta1]

Thank You for the tutorial. I am having a problem while specifying border for labels. My border does not get loaded properly. Like some rows have solid borders and some have half filled borders. Can you help me out with this ?

[@steve78951]

Rojina Panta I’ve seen this issue. I’m guessing your borders are different between labels and input boxes. But you should be able to still format around that issue

[@alanoud3234]

greate job

[@pierrepierre5382]

Hello sir; excuse me, is it possible to patch the data coming from the same column in different collections, then from different SharePoint lists, I tried to create, a collection by criterion of the column so that in my Patch formula, I can put a filter on the column and point it to the desired collection but there are errors since I started, hence I allow myself to ask you how I will be able to get out of this problem, that's it the formula: locform: is my variable which allows me to display the desired criterion of my column. ColMarketing and ColDigital are different collections that I created to fill according to different criteria of my column. patch (Filter (ColMarketing; Locform.systeme = "Marketing") && The Expectations = thisIthem.Attentes)); {......... patch (Filter (ColDigital; Locform.système = "Digital") && The Expectations = thisIthem.Attentes)); {......... So on for the 10 systems. and it doesn't work. by the way i want to redirect the data of each

[@ascencioparedes]

Buenas tengo un problema al momento de mostrar en una table o grafico informacion con fechas... por ejemplo tengo la data de temperatura diaria de 01/01 al 31/01 en mi excel ! pero cuando lo muestro en mi table . se adelanta un dia. mostrando desde el 02/01 al 01/02 . me podrian porfavor indicar a que se debe Hi, I have a problem when displaying information with dates in a table or graph ... for example, I have the daily temperature data from 01/01 to 01/31 in my excel! but when i show it on my table. is one day early. showing from 02/01 to 01/02. Could you please tell me why

[@ApuBala888]

What we see in this example is just 7 fields.. (which is within the screen size). What if i have some 20 fields... ? i tried this method, only the vertical scroll works as the no of item increases. we cannot have horizontal scroll as we use the default screen size.. So this could be only used on a datasource with less no of fields :( Anybody have any ideas on iplementing the same solution for large datasource pls let me knw..