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
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
Hi Julie - you might find this one will help you with a horizontal scrolling editable grid gallery th-cam.com/video/wI6SHGQ9ATg/w-d-xo.html. Rezza Dorrani has lots of tutorials that I've used. I have also solved an issue watching this tutorial to patch the changes
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 :(
Jimena Zumaeta - Items property of table. Discint(Filter(Yourdatasource, favortieband = dropdown1.selected.value),favoriteband) Just change the values to your data source and columns
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
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 ?
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
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.
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
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
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..
You have no idea how long I’ve been looking for this hack, Thanks a lot!
Thanks bro. You're a life saver.
Really Nice--Something I've been struggling with.
Exactly what I was looking for!, Thank you!
Great Job! well done, easy to understand
Awesome! Very helpful. Thanks!
Heroooooooooooooooooooooo, I can't thank enough, saved me to get fired jajjaj
Just what I wanted, thank you.
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
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.
cheers for the video helped immensely
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?
Same here but with Currency. did u find a solution yet?
@@stebbey6006 Try formatting as Currency in your Excel table
Is this the same principle when using excel on onedrive or Sharepoint?
Nice video, thanks
Hi stephen u not adding data, u just changing data, is it possible to add record from this gallery?
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?
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
Hi Julie - you might find this one will help you with a horizontal scrolling editable grid gallery th-cam.com/video/wI6SHGQ9ATg/w-d-xo.html. Rezza Dorrani has lots of tutorials that I've used. I have also solved an issue watching this tutorial to patch the changes
Wow. Thank you!!!!
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
This is connected to a SharePoint list and updates the list?
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 :(
Jimena Zumaeta -
Items property of table.
Discint(Filter(Yourdatasource, favortieband = dropdown1.selected.value),favoriteband)
Just change the values to your data source and columns
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 :)
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
This is really nice video. Can we add 50+ columns in gallery editable like excel spreadsheet. If not then how can do that.
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 ?
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
Very interesting. thank you.
Muchas gracias!
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.
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
greate job
I have way more columns, what do I do?
How to add slicer to edit the old data and save it in that same field
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
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..