How Create Editable Excel Like Table in PowerApps

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 42

  • @delicious9930
    @delicious9930 ปีที่แล้ว

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

  • @aytekgungor3749
    @aytekgungor3749 3 ปีที่แล้ว

    Thanks bro. You're a life saver.

  • @StephanOnisick
    @StephanOnisick 3 ปีที่แล้ว

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

  • @rmk_ro
    @rmk_ro 4 ปีที่แล้ว +2

    Exactly what I was looking for!, Thank you!

  • @DanRyan01
    @DanRyan01 4 ปีที่แล้ว

    Great Job! well done, easy to understand

  • @OptimalTrainingGroup
    @OptimalTrainingGroup 3 ปีที่แล้ว

    Awesome! Very helpful. Thanks!

  • @roxanarodriguez1828
    @roxanarodriguez1828 4 ปีที่แล้ว +3

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

  • @theelectricsheep8204
    @theelectricsheep8204 5 ปีที่แล้ว

    Just what I wanted, thank you.

  • @PranayPawar1991
    @PranayPawar1991 4 ปีที่แล้ว +2

    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

  • @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.

  • @robmcevoy7329
    @robmcevoy7329 5 ปีที่แล้ว

    cheers for the video helped immensely

  • @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 ปีที่แล้ว +1

      @@stebbey6006 Try formatting as Currency in your Excel table

  • @somecomment
    @somecomment 27 วันที่ผ่านมา

    Is this the same principle when using excel on onedrive or Sharepoint?

  • @btoz6237
    @btoz6237 3 ปีที่แล้ว

    Nice video, thanks

  • @imotumbokanaka4157
    @imotumbokanaka4157 3 ปีที่แล้ว +1

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

  • @jujubalismel
    @jujubalismel 5 ปีที่แล้ว

    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 ปีที่แล้ว +1

      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 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

  • @clatz13
    @clatz13 4 ปีที่แล้ว

    Wow. Thank you!!!!

  • @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?

  • @Jime1306
    @Jime1306 5 ปีที่แล้ว +1

    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 ปีที่แล้ว +2

      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 ปีที่แล้ว +1

      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 :)

  • @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

  • @DevendraSingh-tx2pt
    @DevendraSingh-tx2pt 3 ปีที่แล้ว

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

  • @RojinaPanta1
    @RojinaPanta1 5 ปีที่แล้ว

    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

  • @fhp9st870
    @fhp9st870 5 ปีที่แล้ว

    Very interesting. thank you.

  • @SAULSM17
    @SAULSM17 3 ปีที่แล้ว

    Muchas gracias!

  • @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.

  • @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

  • @alanoud3234
    @alanoud3234 5 ปีที่แล้ว

    greate job

  • @itmesneha
    @itmesneha 3 ปีที่แล้ว

    I have way more columns, what do I do?

  • @solageormeich
    @solageormeich 3 ปีที่แล้ว

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

  • @ascencioparedes
    @ascencioparedes 4 ปีที่แล้ว

    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
    @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..