Power Apps Table Control Tutorial: From Beginner to Intermediate

แชร์
ฝัง
  • เผยแพร่เมื่อ 19 มิ.ย. 2024
  • In this Power Apps beginner to intermediate tutorial video, we'll take a first look at the all-new Modern Table control for Canvas PowerApps. We will explore the powerful features of the modern TABLE control in this step-by-step video. Discover how to customize the display, column headings, footers, add filtering and sorting to Table control, connect to SharePoint / Dataverse and more...
    Key Highlights:
    🔵 Explore the tabular and list formats, each offering a unique way to present your data.
    🔵 Full control over the columns displayed and their order.
    🔵 Learn to leverage the Selected property to link the Table control with other elements in your app (example: Form)
    🔵 Connect seamlessly with various connectors, including Excel, SQL, and SharePoint, Dataverse & Collections.
    🔵 Discover the reflow behavior options.
    🔵 Experience modern data browsing with infinite scroll & in-built pagination
    🔵 Ability to show or hide avatars, footers, and column headers in your table visuals.
    🔵 Explore filtering and sorting data in Table control.
    Join me on this journey to learn about the Table control in PowerApps.
    #PowerApps #PowerPlatform #SharePoint #Dataverse
    ⬇️ Download sample Power App showcased in the video:
    Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
    Find the download link in the Community Tab for Members.
    To become a member, click here: th-cam.com/users/rezadorranijoin
    Table control in Power Apps - Power Apps | Microsoft Learn
    learn.microsoft.com/en-us/pow...
    Power Apps Modern Controls
    • Modern controls and th...
    Power Apps filtering & Dataverse views
    • Multi Select Filters i...
    • Filter Gallery using D...
    Power Apps delegation
    • Power Apps Delegation ...
    Table of Contents:
    00:00 - Introduction to Table control in Power Apps
    00:47 - Overview of Table control
    02:04 - How to Add Table control to Power Apps
    03:38 - Table control properties
    08:25 - Table control handling large data from SharePoint/Dataverse
    09:25 - Connect Table control to Form control
    11:56 - Filter and Sort Power Apps Table data
    13:39 - Table control and SharePoint
    17:10 - READY to subscribe to Reza Dorrani’s channel
    🤝 Let’s connect on social:
    🔗 Reza Dorrani LinkedIn: / rezadorrani
    🐦 Reza Dorrani Twitter: / rezadorrani
  • วิทยาศาสตร์และเทคโนโลยี

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

  • @mudassirsyedrashidali9787
    @mudassirsyedrashidali9787 7 หลายเดือนก่อน +7

    This is gold. Another one in my bookmark list. Thank you so much Reza for this invalulable knowledge.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Most welcome and thanks so much for watching

  • @MrAll2001
    @MrAll2001 4 หลายเดือนก่อน +1

    Thanks Reza - you are the first reference if I need to get information about Power Platform.

  • @jamesclark2020
    @jamesclark2020 7 หลายเดือนก่อน +3

    Power Apps just keeps getting better and better.

  • @dougydoe
    @dougydoe 7 หลายเดือนก่อน +2

    Another great piece. Looks like the new Table control is quite versatile and powerful. Definitely another option to Galleries I reckon. Thanks for Sharing.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Most welcome and thanks for watching.

  • @oluwatobiyusuf
    @oluwatobiyusuf 6 หลายเดือนก่อน +1

    Thank you Reza. Bookmarking this

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Welcome and thanks for watching

  • @niiikhiiil
    @niiikhiiil 7 หลายเดือนก่อน +1

    Thanks Reza. Time to upgrade my Apps to Modern controls.

  • @user-np7nu7dt3i
    @user-np7nu7dt3i 7 หลายเดือนก่อน +1

    Thanks so much Reza. This is fantastic!

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Most welcome and thanks for watching

  • @paulibaby2825
    @paulibaby2825 7 หลายเดือนก่อน +1

    Amazing. This opens the door to lots of opportunities for canvas apps

  • @venumadhavravulapalli1463
    @venumadhavravulapalli1463 7 หลายเดือนก่อน +1

    Awesome video Reza… this will save huge efforts and time for developers working on gallery with more than 15 columns

  • @spen2431
    @spen2431 7 หลายเดือนก่อน +1

    Always brilliant. Thanks Reza ⚡⚡⚡⚡

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Most welcome and thanks so much for watching

  • @upendrauppu1117
    @upendrauppu1117 7 หลายเดือนก่อน +1

    Thanks Guruji for another valuable input

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Most welcome

  • @michaelcollett7284
    @michaelcollett7284 2 หลายเดือนก่อน +1

    Found this sooo useful! Thank you!
    Following on from you showing you can copy from the table into Excel, can you copy from Excel and paste into the table?

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      Welcome!
      Currently, you cannot copy from excel to table.

  • @roma9026
    @roma9026 7 หลายเดือนก่อน +1

    Hi Reza. This is awesome. You usually demo your development process showing the steps. Could you do the same here please? Like adding another container and connecting to form etc. Thanks a lot!

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      I did not do it here because I did not want to reinvent the wheel. I have done that in many other videos. Same steps apply here.

  • @nununu8
    @nununu8 7 หลายเดือนก่อน +1

    Hi reza great video once again. Regarding data verse tables, does security/permissions get taken into account.? E.g a user will only be able to see records they have permissions to see or will we have to code in filters to the apps based on signed in user

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Security is respected.

  • @user-ct5qc6bz6s
    @user-ct5qc6bz6s หลายเดือนก่อน

    Hi Reza, thank you for this wonderful video. just wondering, how did you make the department field on your form control a dropdown?

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน +1

      It automatically did that probably because it was a Choice column

  • @guenertahsin
    @guenertahsin 7 หลายเดือนก่อน +1

    Reza you are GREAT !!!

  • @CS-xt5qe
    @CS-xt5qe 3 หลายเดือนก่อน +1

    Very good video, thank you for doing this. I apologize if you answered this already - if you click on the dropdown icon on each header, there is a Filter By option but it is greyed out. I understand I can create my own dropdown controls and filter the data as you have done in this video, but it appears that some kind of filtering is built-in (or is planned and not yet available). I would like to filter by all columns, which makes adding separate filter controls somewhat cluttered, and opens issues of multi-column filtering/sorting. Do you know how to enable that built-in filter or if it is a feature planned in a future release?

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน +1

      Table control is in preview. Filtering is coming as a feature later. No date shared yet.

  • @sankhlayashraj
    @sankhlayashraj 7 หลายเดือนก่อน +1

    Another fantastic video Reza. Waiting when this would be available in canvas apps. Superb work

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Very soon!

  • @bernardnguyen5382
    @bernardnguyen5382 7 หลายเดือนก่อน +1

    Amazing like always ! But in my tenant business, i can connect the component table to my SharePoint List but column type choices are not supported, the values are not retrieve, may be the versionning or for the moment only available in US ?
    Thanks a lot Reza for this topic !

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      There is an issue with SharePoint complex type columns. Even in my demo - I created a calculated column that shows value of choice column and put it on the table.

  • @sankhlayashraj
    @sankhlayashraj 7 หลายเดือนก่อน +1

    Another fantastic video Reza. Waiting when this would be available in canvas apps. Superb work❤

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Very soon!

  • @iftikharhussain1823
    @iftikharhussain1823 2 หลายเดือนก่อน +1

    Really great tutorial, a gem

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      Thank You

  • @gavinm2339
    @gavinm2339 7 หลายเดือนก่อน +1

    Greetings from Australia.
    Thanks - I've been keeping an eye on the Table control and it's getting there. Galleries are nice, but for simple data views time consuming to implement in some use cases and the old data grid doesn't play nicely in contrainers. My understanding is that end users should be able to sort and filter directly from the column headers without the need to code it as you have done here. The hover arrow is there on the column header but it doesn't seem to do anything. It will be great when that is implemented.
    PS - Better luck next time 😁on the cup

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Greetings to aussies 😊
      We will meet in the next world cup 😉
      Yes the sort is shown which is a giveaway of whats to come. Good things to come.

  • @user-tr2tx5nf8h
    @user-tr2tx5nf8h 7 หลายเดือนก่อน +1

    Awesome content as always

  • @DIXITROHITMCA
    @DIXITROHITMCA 5 หลายเดือนก่อน +1

    Hi Reza, Thanks for another great section of learning. I would like to ask how we can reset the selection for this table control.

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      Table currently does not have a reset property. Only way to reset is by initiating a reload of the items property. Not something I have tried.

  • @breadandcheese1880
    @breadandcheese1880 7 หลายเดือนก่อน +1

    Great video Reza! Thank you so much! One question: Can this table have the feature of adding new rows where use can copy and paste into the new row? The scenario i am thinking of is this table would be perfect to have as my line item source and have it be right under my main header table form that uses data from another table. The end goal I want to do is to Patch the data from the header form and table (line item) to its respective dataverse tables using one button. i.e. Submit.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      The Table control is currently read-only.

    • @breadandcheese1880
      @breadandcheese1880 7 หลายเดือนก่อน

      @@RezaDorrani Thanks Reza!

  • @user-tv2of5rg6z
    @user-tv2of5rg6z 6 หลายเดือนก่อน +1

    thanks Reza, this is awesome

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Most welcome

  • @haynescrossley9297
    @haynescrossley9297 5 หลายเดือนก่อน +1

    This is a great video. I am following along but I am not sure how you aligned the container within the main container that shows your form to the right of the table?

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      Thanks!
      The video is a step by step build from what I remember. May be I don’t remember :)
      Video description probably has link to download sample app (members only)

  • @samitbhattacharya2201
    @samitbhattacharya2201 7 หลายเดือนก่อน +1

    Hi Reza... This new control looks awesome. Let me give it a try. I am sure we can use collections as well. As always 👍

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Works with collections

  • @pkns_cad
    @pkns_cad 6 หลายเดือนก่อน +1

    Hi Reza, I like the way you demonstrate the features with examples. I have to build Applications to insert/update Azure SQL server database data. Can I leverage the very same approach you demoed here or is there any specific videos you have already published.

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน +1

      Thanks!
      Yes, similar pattern can be applied.

    • @pkns_cad
      @pkns_cad 6 หลายเดือนก่อน +1

      @@RezaDorrani okay, great. Thank you !

  • @kayogunbowale9446
    @kayogunbowale9446 3 หลายเดือนก่อน +1

    Hi Reza, this is gold and i learnt so much. However, i have a question, how do you hide the edit form after you are done considering that the modern data table is not allowing you to unselect the rows? Thanks

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน

      I believe I was resetting the table control by setting a variable to false and then true and using that variable to filter the items of table

  • @ballutamang6545
    @ballutamang6545 7 หลายเดือนก่อน +1

    Awesome Reza Sir!

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Thank You

  • @nihar4713
    @nihar4713 5 หลายเดือนก่อน +1

    brilliant lecture

  • @seang2012
    @seang2012 2 หลายเดือนก่อน

    Hi Rena, do you know a way to allow a word wrap in a column for this table control? I have a column with a longer string I would like to wrap. Love this control!

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      Currently, it does not support wrap

  • @tienta4424
    @tienta4424 7 หลายเดือนก่อน +1

    it's a great video !!
    Can we integrate table control with gallery control? In my case, I want to have a check box for each row in table control!!

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      Thanks!
      I have not tried integrating it with gallery so not sure.

  • @andymoyer4315
    @andymoyer4315 หลายเดือนก่อน +1

    This is a great video as I'm using this new control and it really helped. I noticed that you have a timestamp showing on your Dataverse table example, how can you format that to date only, especially if the column in Dataverse is set as date only?

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน

      Thanks!
      Currently, formatting options are not available.

  • @ciprianpopovici7532
    @ciprianpopovici7532 6 หลายเดือนก่อน +1

    Hi Reza, Nice to explain this control ! Your knowledge help us everyday to learn new things of PowerPlatform! Very nice to show a form control when a row is selected, but how can the form be hidea after..? I want to show this form as a popup screen , but cannot a find a way to hide it...If you can give me an idea ...
    Thank you!

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      When table is reset (via filters) form gets hidden.

  • @marieraymond6512
    @marieraymond6512 2 หลายเดือนก่อน +1

    This is GREAT!!! Just what I needed for developing a list with dynamic columns with form views. I created this but used your tutorial for list views in the dropdown. The only issue is that I cannot seem to get a New Form to open in the form container. Just edit form pops up. I tried a CREATE NEW button with Set(varFormType, "New");NewForm(Form2), but still shows the table item. Any tips on this?

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      Video description has link to download entire solution. I would recommend grabbing the link from community tab.

  • @tutanekai55
    @tutanekai55 7 หลายเดือนก่อน +1

    Thanks Reza. Great video as always. Have you had any trouble displaying dataverse lookup fields within the table?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      New authoring version of app should have it fixed.

    • @tutanekai55
      @tutanekai55 6 หลายเดือนก่อน

      What is the 'New authoring version' and how do i get access to it? Thanks in advance@@RezaDorrani

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      @@tutanekai55 Check documentation on how to change auth version of app. Ive shown it in some videos. Do not remember which. Version numbers keep getting updated. Just pick the latest available.

  • @ozodinson6632
    @ozodinson6632 หลายเดือนก่อน

    Hi Reza. Big thanks! I have built my first app with the help of your videos. Now, I am making some design changes to it. Following your video above, is it possible to adjust row height of a table connected to a SharePoint list, please? If I am not mistaken, I saw some folks achieved this, but couldn't find how to do it.

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน

      Row height in table control? I don’t think we have an option today

  • @frenamakenson9844
    @frenamakenson9844 6 หลายเดือนก่อน +1

    Thank you Reza for Sharing, So Many Time Saved with This Demo.
    One small Question, In terms of Performance, is this control better than a gallery?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Control is in preview. So too early to talk about performance. However modern controls are designed to be faster from a rendering standpoint.
      What data source I connect to, how many columns, delegation etc. all play a key role in performance irrespective of it being a gallery or a table

  • @abdullahtanweer3890
    @abdullahtanweer3890 5 หลายเดือนก่อน

    Hey Raza, Thank you for the valuable video. I dont have the similar preview version of this table control. I also have modern table control but it is completely different than the one that you have been using in this video. I have turned it on from the upcoming features section. do you know what could be the issue? Thanks in advance

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      What’s different in your version?

  • @ducatiteam
    @ducatiteam 6 หลายเดือนก่อน +1

    Well done 👏 It would be great to be able to edit data in batches. Do you think it is possible in such a scenario?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Thanks!
      Table control is currently read only.

  • @Mephisto_616
    @Mephisto_616 5 หลายเดือนก่อน +1

    Thanks for the video. Does modern control table support images? 🤔

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      Currently it does not support images

  • @DuncanCunningham
    @DuncanCunningham 7 หลายเดือนก่อน +1

    I watched your previous video about Patch function and Modern controls, I added the table and found that it worked with SharePoint so my next app was going to use that feature, though I was nervous about it since it did say "dataverse only". thank you for showing us how it works. I like these new modern controls, allows us to build neat looking layouts faster.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Awesome! I am super happy to hear that

    • @sankhlayashraj
      @sankhlayashraj 7 หลายเดือนก่อน +1

      @duncan - You used this on Canvas app with SharePoint as your data source?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      @@sankhlayashraj Yes. Video shows both Dataverse and SharePoint

    • @DuncanCunningham
      @DuncanCunningham 7 หลายเดือนก่อน

      @@sankhlayashraj Yes, SharePoint, our company will not pay premium for anything.

    • @colinoconnor4628
      @colinoconnor4628 6 หลายเดือนก่อน +1

      Hi @@RezaDorrani , i have used this with sharepoint also but i seem to be having a problem with it and the modern forms not loading in choice fields. Have you encounter this

  • @MadhusudanKaleMK
    @MadhusudanKaleMK 6 หลายเดือนก่อน

    Hi Reza, which would be better - the PowerCAT Details List or this modern table control in terms of stability in prod environment? The PowerCAT Details list has a lot of customization available though.

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      PowerCAT list is custom component. This is out of the box control.
      Out of the box one would be a preferred option but you are free to choose based on your needs.

  • @unclejimbog
    @unclejimbog 6 หลายเดือนก่อน +1

    You're the best.

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Thanks so much

  • @anuragdhamija7201
    @anuragdhamija7201 7 หลายเดือนก่อน +2

    Hi Reza. This is extremely helpful. Thank you again for this tutorial. One quick question, In the table I have many columns like 10-12 columns and as a result the columns are so narrowed that I can't even read the names of the columns and values. Is there a way to enlarge the columns? When I play the App, I can do that one by one but after publishing the app its going again to the narrowed version. Is there a to permanently enlarge the columns?
    Thanks

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      I believe that’s currently a bug. Please note the control is in preview

    • @anuragdhamija7201
      @anuragdhamija7201 7 หลายเดือนก่อน

      @@RezaDorrani Thanks for confirming as I read the same in Microsoft blog. Also, is there an alternative as of now with same functionality? Just wondering? :? Can I use the table preview in Classic Experience? Will that give me the same functionality?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      @@anuragdhamija7201 Alternative is to build a collection but I would not recommend that as it would result in delegation challenges

  • @kitabatas
    @kitabatas 7 หลายเดือนก่อน

    Thanks for your great video, Reza!
    One question, How should I initialize Form you mentioned in 10:30 ?
    I'm trying to do the same but there is no timing to EditForm.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      Timing to form?
      Form default mode is edit.
      Onsuccess of form submit, I simply reset the form

    • @kitabatas
      @kitabatas 7 หลายเดือนก่อน +1

      @@RezaDorrani Got it! Thanks Reza!

  • @sreeponn
    @sreeponn 6 หลายเดือนก่อน +1

    Another fantastic video, thanks for sharing. One question though, if you add more than one filter criteria the filter query needs to have even more conditions right?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      More filters means more filter criteria. I have done numerous videos on gallery filtering.

    • @sreeponn
      @sreeponn 6 หลายเดือนก่อน

      @@RezaDorrani Thank you for your comment. Thanks for confirming that gallery filtering logic can be used at table as well. I want to be able to fulter upto 5 columns and filtering should apply only if they are selected. Conditional (if ) criteria are only way right? Which would mean a lot of conditions.

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน +1

      @@sreeponn Yes it would but I have done plenty of videos on that.

    • @sreeponn
      @sreeponn 6 หลายเดือนก่อน +1

      @@RezaDorrani thanks for your response! I will look them up! Thank you!

  • @luongthu5615
    @luongthu5615 7 หลายเดือนก่อน +1

    hey Reza, thanks for you video is very informative, Microsoft Automate change the edit layout, I can't build a flow from a Form to Sharepoint List, can you do a video to guild us pleas.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      Most welcome!
      I have a few ideas in my backlog. Not sure which one I would do next so no guarantees.
      You can always revert to old flow editor by adding &v3=false in url

  • @davidgraham6238
    @davidgraham6238 6 หลายเดือนก่อน +1

    Nice work Reza! Would be nice to see 'OnSelect' functionality of a record. Is that in the works?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Thanks!
      Im not aware if that is in the works.

    • @mrnock2
      @mrnock2 3 หลายเดือนก่อน +1

      I have achived that by adding this code to the Table1 On Select property: Set(varItem,Table1.Selected); I hope it helps 👍

  • @colleenglavan7151
    @colleenglavan7151 6 หลายเดือนก่อน +1

    Thanks so much for this Reza - this is exactly what i've been looking for - to connect with a sharepoint list. I've followed along with the entire video, however when i'm connecting the table to my sharepoint list, i keep getting an "error when trying to retrieve data from the network. the attempted operation is prohibited because it exceeds the list view threshold" Not sure how you were able to bypass this with your list being over 10,000 items...mine is around 9,000 items. So it won't show me any of the data in my table - when i connect to the old version of the data table, it allows me to see the data...but with all of the issues of not being able to see/load more than 2000 items

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      This boils down to delegation and handling large data with sharepoint. Indexing columns etc.
      I covered delegation and handling large SharePoint data in depth during the Training session - th-cam.com/users/live0nhGaQ_J278
      Please note: TH-cam training sessions are only available to gold members of my channel.
      To check membership levels and become a members - use the following link on a desktop or laptop www.youtube.com/@RezaDorrani/join

  • @v75tan
    @v75tan 7 หลายเดือนก่อน +1

    Great Work
    Advantages / Disadvantages with respect to Galery

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Covered that in my training video for gold members 😉
      There are plenty.

    • @v75tan
      @v75tan 7 หลายเดือนก่อน

      @@RezaDorrani How i can access it?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      @@v75tan You would need to be a gold member. To upgrade membership - support.google.com/youtube/answer/6304294?hl=en&co=GENIE.Platform%3DDesktop

  • @hamzasiddiqui9105
    @hamzasiddiqui9105 5 หลายเดือนก่อน +1

    Great tutorial as always Reza. Is there a way to increase the width of the columns? I have allowed it to be scrollable but it still tries to squeeze all columns into to container, hence not readable.

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      There is a known issue with column widths.

    • @hamzasiddiqui9105
      @hamzasiddiqui9105 5 หลายเดือนก่อน +1

      @@RezaDorrani Yeah, I figured. I ended up using creator kit's fluent details list. Thank you for your quick response Reza.

  • @hackmo
    @hackmo 7 หลายเดือนก่อน +1

    Hi Reza, greay video! Does the modern data table work with all column types when using a sharepoint list as a datasource? Im experimenting with it now but it doesnt seem yo pull through values on choice colums or created by

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +2

      It does not work with complex type columns. Its a known limitation.

    • @hackmo
      @hackmo 7 หลายเดือนก่อน +1

      @@RezaDorrani Thanks for the quick reply! I'll keep an eye out on the development to check for when complex types work :)

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      @@hackmo From what I know, it wont be soon

  • @jameshart9519
    @jameshart9519 3 หลายเดือนก่อน +1

    Great video Reza and thanks for sharing. Quick question. The table I am using from Dataverse has several lookup columns. Some are showing with the values in the rows but others display nothing. When I try to add them from the field selector, they show as custom card and dont display data. Do you know why this could be?

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน +1

      Not sure about that

    • @jameshart9519
      @jameshart9519 3 หลายเดือนก่อน

      @@RezaDorrani Thanks anyway Reza

    • @jameshart9519
      @jameshart9519 3 หลายเดือนก่อน +1

      I've just added the source tables in the tables section in the menu on the left and the values have appeared. Strange but appears to work for now. Interestingly though, one of the fields brings up and SQL CRM error.

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน +1

      @@jameshart9519 Control is in preview

  • @keuleule
    @keuleule หลายเดือนก่อน +1

    Hey Reza, you're probably the best teacher ever 😊. Is there a way to include a sum here that sums up a column, even if there are more than 2000 records?

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน

      Wow! Thanks so much!
      Sum is not a delegable function so will not work with large data sets.

  • @MrBond249
    @MrBond249 7 หลายเดือนก่อน +1

    Great video Reza. My only question is will this work with managed meta data?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Probably not

    • @MrBond249
      @MrBond249 7 หลายเดือนก่อน

      That sucks. If it did it would solve many problems. 😎@@RezaDorrani

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      @@MrBond249 I rarely use that column

  • @bamboofireworks1779
    @bamboofireworks1779 6 หลายเดือนก่อน

    Thanks for this video, its very frustrated that datatable in powerapps is readonly since 1 year? Any idea if Microsoft will implement it?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      This is the new Table control which released a few months ago.
      I am not aware of any publicly shared details about datatable control.

  • @DuncanCunningham
    @DuncanCunningham 7 หลายเดือนก่อน

    can you show how you made the second header looking Container where you put the filtering? I made another header_Container but not sure how you have placed the filter text, dropdown etc.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      I have made the entire app available for members (check video description for details)

  • @wellingtonnalmeida6794
    @wellingtonnalmeida6794 6 หลายเดือนก่อน

    Congratulations on the video, one question, is there a way to clean the selected item?
    I ask if we added a close button in the form's container view.

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      What does clean an item mean?

    • @wellingtonnalmeida6794
      @wellingtonnalmeida6794 6 หลายเดือนก่อน

      @@RezaDorrani To view the side form, you use the selected item in the container view, something like "!IsBlank(PowerAppsOneGrid1.Selected)". But in the video the only way you used to close the form container was through submitForm.
      I'm trying to add a close icon to this form container to close it (and not just use submitForm to close the form container).
      Is there a way to clear "PowerAppsOneGrid1.Selected" by clicking a button without necessarily using the submitForm?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      @@wellingtonnalmeida6794 Ahh. So reset the table. Im not sure if it supports reset behavior

    • @wellingtonnalmeida6794
      @wellingtonnalmeida6794 6 หลายเดือนก่อน +1

      @@RezaDorrani Thank you for the immediate response Reza. I added a refresh to the database in the button event and it worked perfectly.

  • @chrisadriano3461
    @chrisadriano3461 5 หลายเดือนก่อน +1

    Really helpful this video. One question though is how was the table layout changed automatically when the form appears and disappears. I see you used 2 containers. THanks for the response.

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน +1

      Table automatically changes layout based on real estate available. I added a form container and show/hide it based on table item selection.

    • @chrisadriano3461
      @chrisadriano3461 5 หลายเดือนก่อน

      Thanks! Is there a way to persistently set the column sizes on the modern table item? I have observed it reverts back to original column size when the app is closed and then opened. @@RezaDorrani

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      @@chrisadriano3461 Currently no option for that

  • @JoeAtWork-gy4wh
    @JoeAtWork-gy4wh 3 หลายเดือนก่อน +1

    Hi Reza
    Awesome video but I have a question with regards to SharePoint lists in the modern table. How did you in your example have columns that have choices or are they just text fields that look like choices?
    I created a SharePoint list for my app but the data in my choice columns is not displaying anything??
    I noticed that each data card is labeled as Custom and if I select the Table from the Tree View / Custom Card Name / Dropdown / Field Type - they are all of type "s".
    Can this be changed to a different type to read from SharePoint or is there another way to read in the SharePoint data?

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน +1

      🗒️ Table control is in Preview.
      Currently type cannot be changed. I believe mine were text columns and calculated columns.

    • @JoeAtWork-gy4wh
      @JoeAtWork-gy4wh 3 หลายเดือนก่อน +1

      Thank you for replying, Reza.
      I hope Microsoft add the support for SharePoint as there are a lot of smaller companies that we develop apps for and Dataverse is not viable for their budgets or use cases.
      Until then, I am following your other tutorial on Responsive Gallery as a table with column filtering.

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน +1

      @@JoeAtWork-gy4wh They will but control is in preview for now. We have to wait.

  • @gilbertpradier
    @gilbertpradier 7 หลายเดือนก่อน

    @reza Is this control still in preview or GA..? Thank you for the video.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Preview

    • @gilbertpradier
      @gilbertpradier 6 หลายเดือนก่อน +1

      Thank you@@RezaDorrani

  • @MadhusudanKaleMK
    @MadhusudanKaleMK 7 หลายเดือนก่อน

    The width of the columns is equally distributed when loading data freshly, is there a way past it, since the user will have readjust the column width every time. Also, I wanted to show/hide columns dynamically based on user selection; however I couldn't find a way to do it.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Please note the control is in preview.
      Width distribution is equal by design for now.
      Show hide columns dynamically is not an option as of now.

  • @lookingforbusiness5662
    @lookingforbusiness5662 3 หลายเดือนก่อน

    Hey Reza ,my whole career is based on your video tutorials , thank you so much.
    I have a concern regarding OnSelect property of Table and refresh() function , If I use hit button which has refresh function of my SP list ,then it get navigate to form screen thats which i have in Onselect proprty of Modern Table control.
    And when I submit the form using Submit Function , after submit it navigate to gallery screen and back to form screen with blank page/record, strange behavior

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน

      At what time in video do I show Refresh() function?
      I have not experienced the issue you are mentioning though.

  • @jasonmoreton461
    @jasonmoreton461 2 หลายเดือนก่อน

    Reza could I ask how you tie the combo box control to the Department column on your SP list please?

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      It probably was a lookup column

  • @Michalck85
    @Michalck85 2 หลายเดือนก่อน

    Hi Reza, is it possible to do bulk operations in this modern table view?

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      Currently, No but coming soon

  • @MarkSmith-338-gd7jp
    @MarkSmith-338-gd7jp 2 หลายเดือนก่อน +1

    First off I love your videos. Very helpful. As it relates to this table control...how do you export the entire data in the table to a flow to be exported to Excel? Unlike a gallery control, there doesn't appear to be a way to Extract All to a flow to create an Excel File to be downloaded? How can I export all my filtered table data to a flow?

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      Idea would be to not export either table or gallery data as both would run into delegation challenges. Best option would be as shown in this video - th-cam.com/video/UZdngrwWsqA/w-d-xo.html

    • @MarkSmith-338-gd7jp
      @MarkSmith-338-gd7jp 2 หลายเดือนก่อน

      @@RezaDorrani Thanks, that helped. On another note, I have a date field called Closed Date and it is empty until the case is closed. However, for closed date default the Table Control is showing a random date instead of blank?? FYI, this is a Dataverse Table Date ONLY field. I want the field to show blanks and not the default date that seems to be there.

    • @MarkSmith-338-gd7jp
      @MarkSmith-338-gd7jp 2 หลายเดือนก่อน

      @@RezaDorrani I implemented your suggested video...however I have another issue I'm hoping you can help me with. I want to disable the export button when the NEW Modern Control Table doesn't have any items in it. There doesn't appear to be a property to use like the gallery to determine if items exists in the table...unless I'm missing it somewhere?

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      @@MarkSmith-338-gd7jp Modern table currently does not.
      I would recommend checking or posting your query on forums in case someone has done something similar
      powerusers.microsoft.com

  • @EllieCarter5225
    @EllieCarter5225 5 หลายเดือนก่อน +1

    I love your videos. Do you edit out a lot on this video?

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน +1

      Thanks!
      Your question can be interpreted in 2 ways :)
      1 - Do you edit your videos - Yes
      2 - Did you edit out a lot on this video - No - I think I kept all the imp/necessary steps.

  • @aqoraj
    @aqoraj 2 หลายเดือนก่อน

    Hi Reza, thank you for this amazing video. I had a problem. Somehow the Modern Table Control is not showing the information from LookUps from Dataverse for Teams. Do you know why this happens. Also the Date Format is somehow MM/DD/YYYY. Do you think they are bugs or features from Microsoft? 😅

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน +1

      Table control is in preview.
      I have not done any work with Dataverse for teams in past 3 years so not sure.
      I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

    • @aqoraj
      @aqoraj 2 หลายเดือนก่อน +1

      @@RezaDorrani Thank you Reza. I will try it using the forum. Have a nice day! :)

  • @VANDIK01
    @VANDIK01 2 หลายเดือนก่อน +1

    Awsome video, if I joined to Silver club, can I download the app? thanks

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน +1

      Yes

    • @VANDIK01
      @VANDIK01 2 หลายเดือนก่อน +1

      @@RezaDorrani great, thanks Reza....

  • @kevinthomas1335
    @kevinthomas1335 5 หลายเดือนก่อน +1

    Huge fan of your videos! I am new to the Dataverse world, but when I add a dataverse table to a modern table, I only get 2 columns ("title" and created on) When I add a choice column, everything goes blank - is that something you or anyone reading this has come across?

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      Thanks Kevin!
      I have not come across this issue hence not sure.

  • @bilalzeine5572
    @bilalzeine5572 4 หลายเดือนก่อน

    Hi Reza, How can I get the form to appear with more width so that it takes half the screen instead of how you have it on the right end side? Thanks

    • @RezaDorrani
      @RezaDorrani  4 หลายเดือนก่อน

      There are different layout options available. Split screen you could use.
      Or simply update width for container.

  • @elderVelazquez73
    @elderVelazquez73 หลายเดือนก่อน

    Hi!
    I found a problem using containers, when a set a header container and I insert a header or a table, I can't modify its size, it's static different like your video. do you know what I should change in order to enable the custom size using the cursor?

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน

      I have not experienced this problem so not sure

  • @luongthu5615
    @luongthu5615 6 หลายเดือนก่อน

    I am a new Bee, Can you explain the table with the the Microsoft List, which one better to build an Apps, let's say I want to build an app for Tracking Process of User request to me? thank you!

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      SharePoint lists and Microsoft lists are one and the same.

  • @steveh8204
    @steveh8204 5 หลายเดือนก่อน

    Nice video but I'm stuck on filtering as I'm not using Dataverse 'In' doesn't work. What can I put in that is delegable here so that it will filter on the 'Department's that are selected?

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน +1

      Check my videos on SharePoint filtering. I have done 4-5 of them.

  • @chrisadriano3461
    @chrisadriano3461 หลายเดือนก่อน

    Hi Reza, If I join today for Silver membership. Will I still have access to the app on this video?

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน +1

      Yes but you would need to post a message in community tab for me to re-enable the link

  • @waellkhanji3466
    @waellkhanji3466 7 หลายเดือนก่อน

    thanks Reza but how do you show column names at top of the gallery in SharePoint list scenario

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      You mean Table? You simply pick the columns you want to show.

  • @user-kf2dm7qf1g
    @user-kf2dm7qf1g 4 หลายเดือนก่อน

    Does anyone have guidance on the container 3 properties (the one that is visible when a row is selected)? I'm having a difficult time trying to overlay within the same container as the table. Thank you!

    • @RezaDorrani
      @RezaDorrani  4 หลายเดือนก่อน

      Im showing and hiding container based upon an item being selected in table.

  • @thomasboden4053
    @thomasboden4053 หลายเดือนก่อน

    Do you know how to change the date format in the new tables? Mine is currently displaying in US and I cant figure out how to get it into uk

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน

      Currently, changing display formats is not supported

  • @moeking5601
    @moeking5601 5 หลายเดือนก่อน

    is a modern table a premium connector? once I published it said to extend my trial, all my other apps opened fine without a modern table

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      It is not a premium connector

  • @andizone3197
    @andizone3197 3 หลายเดือนก่อน

    Hi Reza, some of my entry on my table doesnt pull up the entry to edit. What mightbe the issue with it? Most of the table works though.

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน +1

      Table control is in preview. It has a few gotchas.
      One easy thing to do is when you select an item and click button to edit, on click use lookup function to get the item from SP based on ID, save it in variable and use this on form.

  • @penumurumohith247
    @penumurumohith247 3 หลายเดือนก่อน +1

    Hi Reza is there any option to auto width of the Columns in the modern table as I've 30 columns they are shrinking I need to adjust it manually and when I restart app back to same, is there any way to do so
    Thank you.

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน +1

      Currently, the table control is in preview. I don't think there is an auto width feature.

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน +1

      Table control is in preview. I'm not aware of a way to fix this at the moment.

  • @Flenderr
    @Flenderr หลายเดือนก่อน

    Hi, this nice new modern table has a serious bug.
    If you put in more then 30 rows and present it on a normal desktop monitor 21" and try to filter, it won't filter untill you filter the same control 2 or 3 times.
    Also refreshing adds double data.
    Took me a friday evening to find out!
    I had to make a toggle between classic and modern table to subvert this..

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน +1

      Modern control is in preview. I will recommend sharing this feedback within the product itself. There is a thumbs up or down area next to modern controls tab where you can share this feedback

  • @ethioone7136
    @ethioone7136 7 หลายเดือนก่อน

    Is there a limit to the number of columns we can add to a table in the user interface?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Not that I am aware of

  • @vinod842
    @vinod842 6 หลายเดือนก่อน

    Seems Table control is not available anymore, atleast I don't see it for new canvas apps from today. I was able to use it earlier in other apps which was created earlier. Any idea if they removed this preview feature?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      It is very much available. The feature flag is in settings under general

  • @princeofchaos
    @princeofchaos 2 หลายเดือนก่อน

    Reza, how can i handle to display information of a table that i have the ID value that makes reference to another table, and the ID's are the same, or for example, if we have a FK or so... i can not figure out how to do it with this Table Control Tutorial. (My connection is with PostgreSql)

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      You would need to show related values in a separate table based upon selection of a record in main table.
      Note: I have done no work with PostgreSql

  • @arunv1909
    @arunv1909 7 หลายเดือนก่อน

    so this works for sharepoint list as well ? for canvas app

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Yes, shown in video

  • @jyeetjyeet
    @jyeetjyeet 7 หลายเดือนก่อน

    Can we connect the table to a document library, trying to make a file browser within Power Apps with this new control.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      It can connect to any data source

    • @jyeetjyeet
      @jyeetjyeet 7 หลายเดือนก่อน

      @@RezaDorrani awesome cheers mate

  • @m1rroredgesharpeningservic546
    @m1rroredgesharpeningservic546 5 หลายเดือนก่อน

    I think I have found a bug in the table control. The problem is that the choice column in the SharePoint list is not showing up in the table. Although I can see the column, there is no data displayed in it. I have tried removing and adding it again, but it did not solve the issue. I have also confirmed that the list is correctly identified. Do you think it could be related to the multiple-choice selection option? I would appreciate any additional ideas you may have.

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      I shared the content for this video. It also includes the hack for it. All apps and flows are shared with silver and gold channel members. Link in community tab of my channel.
      Choice, lookup, managed metadata etc are currently not supported with table control which is in preview.
      Table control works best with Dataverse.

  • @CapstonePMConsulting
    @CapstonePMConsulting 29 วันที่ผ่านมา

    I have many columns in a table that is being used in order to create a power app. When I import the modern tools table format, all the fields gets shrinked. It is extra work to adjust each column size and when I exit the app and get back in, it turns into shrinked again. Is there a place to adjust the size of the column at one time?

    • @RezaDorrani
      @RezaDorrani  29 วันที่ผ่านมา +1

      This is currently a known issue. It will try and fit columns in available space.

  • @sanjaykumarize
    @sanjaykumarize 2 หลายเดือนก่อน

    Hi, can we change the background color of table header in modern table? I didn't get any option to do that. Please help

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      I don’t think that’s an option yet

  • @andizone3197
    @andizone3197 3 หลายเดือนก่อน

    Hello new to power apps. How did you create the container? with this table ?

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน

      Used a screen template which includes layout containers.

    • @andizone3197
      @andizone3197 3 หลายเดือนก่อน +1

      @@RezaDorrani Thank you so much! learned so many things from your videos

  • @unclejimbog
    @unclejimbog 5 หลายเดือนก่อน

    Hi, since the data table control doesn't have an OnSelect property, how do you "unselect" the table record and hide the visibility of the form control container? Thank you.

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน +1

      Apply a fake reset on the table control by setting a boolean variable to false and then true. I did show this in one of my earlier videos.

    • @unclejimbog
      @unclejimbog 5 หลายเดือนก่อน

      @@RezaDorrani this worked thanks!

  • @kalpeshpatil9
    @kalpeshpatil9 7 หลายเดือนก่อน +1

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      Thanks

  • @mahamkhan8314
    @mahamkhan8314 6 หลายเดือนก่อน +1

    This is awesome but it would have been amazing if it had edit rights (editable grid)

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Currently it is a read only control by design

  • @christianonphotography
    @christianonphotography 6 หลายเดือนก่อน

    Interesting....in your example the form shows all values, including the values of the dropdowns....I replicated your example but my form doesn't show the dropdown choices. Any idea why?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Because I did more work on it.
      Video description has link to download sample app (members only - check description for details)

  • @plv77
    @plv77 4 หลายเดือนก่อน

    Hello, is it possible to color some cells or lines with a conditional formatting?

    • @RezaDorrani
      @RezaDorrani  4 หลายเดือนก่อน

      Table control currently does not have those options

    • @plv77
      @plv77 4 หลายเดือนก่อน

      @@RezaDorrani :(( but can we put emojis?

    • @RezaDorrani
      @RezaDorrani  4 หลายเดือนก่อน

      @@plv77 No

  • @alisalih101
    @alisalih101 หลายเดือนก่อน

    Reza, how do you change the Date format in a table control? My Dataverse table has DateTime with DateOnly configuration but in a table control, I see the date plus 12:00:00 AM. I couldn't figure out a way to get rid of the time part (althought DV doesn't have this value)

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน +1

      Changing format for table control is currently not supported

    • @alisalih101
      @alisalih101 หลายเดือนก่อน +1

      @@RezaDorrani Thanks for the confirmation. I was going in circles trying to figure out. I hope this is something the team considers as option/improvement, especially since it is taking lots of real estate. Thanks again.

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน

      @@alisalih101 It definitely will be an option