Тёмный

How Create Editable Excel Like Table in PowerApps 

Stephen Homa
Подписаться 315
Просмотров 84 тыс.
50% 1

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

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 41   
@delicious9930
@delicious9930 Год назад
You have no idea how long I’ve been looking for this hack, Thanks a lot!
@almaqasim932
@almaqasim932 4 года назад
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.
@PranayPawar1991
@PranayPawar1991 4 года назад
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
@StephanOnisick
@StephanOnisick 2 года назад
Really Nice--Something I've been struggling with.
@aytekgungor3749
@aytekgungor3749 3 года назад
Thanks bro. You're a life saver.
@DevendraSingh-tx2pt
@DevendraSingh-tx2pt 2 года назад
This is really nice video. Can we add 50+ columns in gallery editable like excel spreadsheet. If not then how can do that.
@rmk_ro
@rmk_ro 4 года назад
Exactly what I was looking for!, Thank you!
@imotumbokanaka4157
@imotumbokanaka4157 3 года назад
Hi stephen u not adding data, u just changing data, is it possible to add record from this gallery?
@tonystanford6825
@tonystanford6825 2 года назад
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
@stebbey6006 2 года назад
Same here but with Currency. did u find a solution yet?
@tonystanford6825
@tonystanford6825 2 года назад
@@stebbey6006 Try formatting as Currency in your Excel table
@OptimalTrainingGroup
@OptimalTrainingGroup 3 года назад
Awesome! Very helpful. Thanks!
@RagavanRajanrahav
@RagavanRajanrahav 4 года назад
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
@learningtechs1267
@learningtechs1267 4 года назад
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
@jl1399
@jl1399 Год назад
This is connected to a SharePoint list and updates the list?
@btoz6237
@btoz6237 3 года назад
Nice video, thanks
@DanRyan01
@DanRyan01 4 года назад
Great Job! well done, easy to understand
@roxanarodriguez1828
@roxanarodriguez1828 4 года назад
Heroooooooooooooooooooooo, I can't thank enough, saved me to get fired jajjaj
@v.s.5460
@v.s.5460 4 года назад
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.
@jujubalismel
@jujubalismel 4 года назад
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
@steve78951 4 года назад
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
@derekgray3019 2 года назад
Hi Julie - you might find this one will help you with a horizontal scrolling editable grid gallery ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wI6SHGQ9ATg.html. Rezza Dorrani has lots of tutorials that I've used. I have also solved an issue watching this tutorial to patch the changes
@Jime1306
@Jime1306 5 лет назад
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
@steve78951 5 лет назад
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
@Jime1306 5 лет назад
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 :)
@RojinaPanta1
@RojinaPanta1 4 года назад
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
@steve78951 4 года назад
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
@theelectricsheep8204
@theelectricsheep8204 4 года назад
Just what I wanted, thank you.
@SAULSM17
@SAULSM17 3 года назад
Muchas gracias!
@pierrepierre5382
@pierrepierre5382 3 года назад
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
@solageormeich
@solageormeich 3 года назад
How to add slicer to edit the old data and save it in that same field
@ascencioparedes
@ascencioparedes 3 года назад
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
@robmcevoy7329
@robmcevoy7329 4 года назад
cheers for the video helped immensely
@itmesneha
@itmesneha 3 года назад
I have way more columns, what do I do?
@fhp9st870
@fhp9st870 4 года назад
Very interesting. thank you.
@clatz13
@clatz13 4 года назад
Wow. Thank you!!!!
@alanoud3234
@alanoud3234 5 лет назад
greate job
@ApuBala888
@ApuBala888 4 года назад
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..
Далее
Pivot Table in PowerApps
21:25
Просмотров 10 тыс.
PowerApps Multiple Data Sources
22:09
Просмотров 202 тыс.
Слушали бы такое на повторе?
01:00
PowerApps: Quick Edit for Data Grids
20:10
Просмотров 18 тыс.
PowerApps filter gallery by dropdown
28:06
Просмотров 275 тыс.
Creating Easy Data Entry Forms in Excel
9:52
Просмотров 3 млн
Power Apps Editable Table/Gallery like Excel (Tutorial)
28:41
Power Apps Editable Table
20:42
Просмотров 136 тыс.
How to Build a Responsive Data Table in Canvas Apps
32:46