Тёмный

Power Apps Table Control Tutorial: From Beginner to Intermediate 

Reza Dorrani
Подписаться 137 тыс.
Просмотров 76 тыс.
50% 1

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

 

2 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 443   
@mudassirsyedrashidali9787
@mudassirsyedrashidali9787 10 месяцев назад
This is gold. Another one in my bookmark list. Thank you so much Reza for this invalulable knowledge.
@RezaDorrani
@RezaDorrani 10 месяцев назад
Most welcome and thanks so much for watching
@dougydoe
@dougydoe 10 месяцев назад
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 10 месяцев назад
Most welcome and thanks for watching.
@DuncanCunningham
@DuncanCunningham 10 месяцев назад
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 10 месяцев назад
Awesome! I am super happy to hear that
@sankhlayashraj
@sankhlayashraj 10 месяцев назад
@duncan - You used this on Canvas app with SharePoint as your data source?
@RezaDorrani
@RezaDorrani 10 месяцев назад
@@sankhlayashraj Yes. Video shows both Dataverse and SharePoint
@DuncanCunningham
@DuncanCunningham 10 месяцев назад
@@sankhlayashraj Yes, SharePoint, our company will not pay premium for anything.
@colinoconnor4628
@colinoconnor4628 10 месяцев назад
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
@frenamakenson9844
@frenamakenson9844 10 месяцев назад
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 10 месяцев назад
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
@KamalaRani-w5j
@KamalaRani-w5j 10 месяцев назад
Thanks so much Reza. This is fantastic!
@RezaDorrani
@RezaDorrani 10 месяцев назад
Most welcome and thanks for watching
@andymoyer4315
@andymoyer4315 5 месяцев назад
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 5 месяцев назад
Thanks! Currently, formatting options are not available.
@PritishTogare
@PritishTogare 10 месяцев назад
Awesome content as always
@RezaDorrani
@RezaDorrani 10 месяцев назад
Thanks
@oluwatobiyusuf
@oluwatobiyusuf 9 месяцев назад
Thank you Reza. Bookmarking this
@RezaDorrani
@RezaDorrani 9 месяцев назад
Welcome and thanks for watching
@ducatiteam
@ducatiteam 10 месяцев назад
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 10 месяцев назад
Thanks! Table control is currently read only.
@v75tan
@v75tan 10 месяцев назад
Great Work Advantages / Disadvantages with respect to Galery
@RezaDorrani
@RezaDorrani 10 месяцев назад
Covered that in my training video for gold members 😉 There are plenty.
@v75tan
@v75tan 10 месяцев назад
@@RezaDorrani How i can access it?
@RezaDorrani
@RezaDorrani 10 месяцев назад
@@v75tan You would need to be a gold member. To upgrade membership - support.google.com/youtube/answer/6304294?hl=en&co=GENIE.Platform%3DDesktop
@chrisadriano3461
@chrisadriano3461 9 месяцев назад
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 9 месяцев назад
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 8 месяцев назад
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 8 месяцев назад
@@chrisadriano3461 Currently no option for that
@JoeAtWork-gy4wh
@JoeAtWork-gy4wh 6 месяцев назад
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 6 месяцев назад
🗒️ Table control is in Preview. Currently type cannot be changed. I believe mine were text columns and calculated columns.
@JoeAtWork-gy4wh
@JoeAtWork-gy4wh 6 месяцев назад
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 6 месяцев назад
@@JoeAtWork-gy4wh They will but control is in preview for now. We have to wait.
@penumurumohith247
@penumurumohith247 7 месяцев назад
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 7 месяцев назад
Currently, the table control is in preview. I don't think there is an auto width feature.
@RezaDorrani
@RezaDorrani 7 месяцев назад
Table control is in preview. I'm not aware of a way to fix this at the moment.
@MrBond249
@MrBond249 10 месяцев назад
Great video Reza. My only question is will this work with managed meta data?
@RezaDorrani
@RezaDorrani 10 месяцев назад
Probably not
@MrBond249
@MrBond249 10 месяцев назад
That sucks. If it did it would solve many problems. 😎@@RezaDorrani
@RezaDorrani
@RezaDorrani 10 месяцев назад
@@MrBond249 I rarely use that column
@paulbruen3108
@paulbruen3108 2 месяца назад
Great video Reza. Would you know how to display dates in UK format though, with the modern data table control? - Thanks.
@RezaDorrani
@RezaDorrani 2 месяца назад
I believe currently the table control does not support formatting
@rorsara3940
@rorsara3940 Месяц назад
I noticed your list only option for reflow shows three fields while mine only shows two. How can I change that? BTW I just subscribed because you are by far the best tutor I could find and your ideas are so creative. please keep up the wonderful work
@RezaDorrani
@RezaDorrani Месяц назад
Thanks for the sub and the appreciation! List only showing 3 fields is an OOTB option. I did not make any specific setup. Just make sure the first 3 fields in table control has data.
@bamboofireworks1779
@bamboofireworks1779 9 месяцев назад
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 9 месяцев назад
This is the new Table control which released a few months ago. I am not aware of any publicly shared details about datatable control.
@lookingforbusiness5662
@lookingforbusiness5662 6 месяцев назад
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 6 месяцев назад
At what time in video do I show Refresh() function? I have not experienced the issue you are mentioning though.
@Wir2alny
@Wir2alny Месяц назад
Which is better for fast editable table on powerapps ? Sharepoint or dataverse?
@RezaDorrani
@RezaDorrani Месяц назад
Dataverse
@seang2012
@seang2012 5 месяцев назад
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 5 месяцев назад
Currently, it does not support wrap
@MrAll2001
@MrAll2001 7 месяцев назад
Thanks Reza - you are the first reference if I need to get information about Power Platform.
@anuragdhamija7201
@anuragdhamija7201 10 месяцев назад
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 10 месяцев назад
I believe that’s currently a bug. Please note the control is in preview
@anuragdhamija7201
@anuragdhamija7201 10 месяцев назад
@@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 10 месяцев назад
@@anuragdhamija7201 Alternative is to build a collection but I would not recommend that as it would result in delegation challenges
@paulibaby2825
@paulibaby2825 10 месяцев назад
Amazing. This opens the door to lots of opportunities for canvas apps
@RezaDorrani
@RezaDorrani 10 месяцев назад
Thanks
@truecrimerealtime3135
@truecrimerealtime3135 6 месяцев назад
Is there a way to define the width of the columns within the control? It collapses all columns and requires to manually move columns with each use.
@RezaDorrani
@RezaDorrani 6 месяцев назад
You can define it in app edit mode by holding alt key. Then once you publish app, width will be maintained
@ubuntuztc
@ubuntuztc 3 месяца назад
Hello, how to add subtotal for column, where is content for example some amount or quantity. + is possible to create PIVOT?
@RezaDorrani
@RezaDorrani 3 месяца назад
Currently not an option in table control
@VANDIK01
@VANDIK01 6 месяцев назад
Awsome video, if I joined to Silver club, can I download the app? thanks
@RezaDorrani
@RezaDorrani 6 месяцев назад
Yes
@VANDIK01
@VANDIK01 6 месяцев назад
@@RezaDorrani great, thanks Reza....
@elderVelazquez73
@elderVelazquez73 4 месяца назад
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 4 месяца назад
I have not experienced this problem so not sure
@marieraymond6512
@marieraymond6512 5 месяцев назад
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 5 месяцев назад
Video description has link to download entire solution. I would recommend grabbing the link from community tab.
@vinod842
@vinod842 9 месяцев назад
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 9 месяцев назад
It is very much available. The feature flag is in settings under general
@michaelcollett7284
@michaelcollett7284 6 месяцев назад
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 6 месяцев назад
Welcome! Currently, you cannot copy from excel to table.
@ciprianpopovici7532
@ciprianpopovici7532 9 месяцев назад
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 9 месяцев назад
When table is reset (via filters) form gets hidden.
@luongthu5615
@luongthu5615 10 месяцев назад
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 10 месяцев назад
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
@kitabatas
@kitabatas 10 месяцев назад
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 10 месяцев назад
Timing to form? Form default mode is edit. Onsuccess of form submit, I simply reset the form
@kitabatas
@kitabatas 10 месяцев назад
@@RezaDorrani Got it! Thanks Reza!
@CS-xt5qe
@CS-xt5qe 7 месяцев назад
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 7 месяцев назад
Table control is in preview. Filtering is coming as a feature later. No date shared yet.
@colleenglavan7151
@colleenglavan7151 10 месяцев назад
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 10 месяцев назад
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 - ru-vid.com0nhGaQ_J278 Please note: RU-vid 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
@AHayes87
@AHayes87 6 месяцев назад
For the life of me, I can't find any documentation on the FieldType property for the columns in the tree view. I want to show a currency field formatted as currency, but I have no idea what FieldType value to provide. Reza - Do you have any insight into this?
@RezaDorrani
@RezaDorrani 6 месяцев назад
Because thats not an option yet :)
@kevinthomas1335
@kevinthomas1335 8 месяцев назад
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 8 месяцев назад
Thanks Kevin! I have not come across this issue hence not sure.
@bobbelter
@bobbelter 2 месяца назад
For the most part great video. But the part where you have 2 containers side by side, the right one with a form in it. You never showed how to do that part. Now I'm stuck.
@RezaDorrani
@RezaDorrani 2 месяца назад
Video description has details about link to download entire solution (silver and gold members only - check description for details)
@kayogunbowale9446
@kayogunbowale9446 6 месяцев назад
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 6 месяцев назад
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
@keuleule
@keuleule 5 месяцев назад
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 5 месяцев назад
Wow! Thanks so much! Sum is not a delegable function so will not work with large data sets.
@bernardnguyen5382
@bernardnguyen5382 10 месяцев назад
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 10 месяцев назад
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.
@jameshart9519
@jameshart9519 6 месяцев назад
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 6 месяцев назад
Not sure about that
@jameshart9519
@jameshart9519 6 месяцев назад
@@RezaDorrani Thanks anyway Reza
@jameshart9519
@jameshart9519 6 месяцев назад
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 6 месяцев назад
@@jameshart9519 Control is in preview
@harsh.mscrm991
@harsh.mscrm991 Месяц назад
Great knowledgeable video...
@RezaDorrani
@RezaDorrani Месяц назад
Thanks a lot
@CalvinWongHKG
@CalvinWongHKG 2 месяца назад
thanks you bro !!!
@RezaDorrani
@RezaDorrani 2 месяца назад
You're most welcome!
@tienta4424
@tienta4424 10 месяцев назад
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 10 месяцев назад
Thanks! I have not tried integrating it with gallery so not sure.
@Mephisto_506
@Mephisto_506 8 месяцев назад
Thanks for the video. Does modern control table support images? 🤔
@RezaDorrani
@RezaDorrani 8 месяцев назад
Currently it does not support images
@haynescrossley9297
@haynescrossley9297 9 месяцев назад
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 9 месяцев назад
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)
@DIXITROHITMCA
@DIXITROHITMCA 8 месяцев назад
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 8 месяцев назад
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.
@MarkSmith-338-gd7jp
@MarkSmith-338-gd7jp 5 месяцев назад
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 5 месяцев назад
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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UZdngrwWsqA.html
@MarkSmith-338-gd7jp
@MarkSmith-338-gd7jp 5 месяцев назад
@@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 5 месяцев назад
@@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 5 месяцев назад
@@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
@andizone3197
@andizone3197 7 месяцев назад
Hello new to power apps. How did you create the container? with this table ?
@RezaDorrani
@RezaDorrani 7 месяцев назад
Used a screen template which includes layout containers.
@andizone3197
@andizone3197 7 месяцев назад
@@RezaDorrani Thank you so much! learned so many things from your videos
@nununu8
@nununu8 10 месяцев назад
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 10 месяцев назад
Security is respected.
@aureliosaraiva708
@aureliosaraiva708 3 месяца назад
Thanks Reza. The table filter by is visible, but not avaible. Why?
@RezaDorrani
@RezaDorrani 3 месяца назад
Because that's coming in future :)
@Flenderr
@Flenderr 5 месяцев назад
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 5 месяцев назад
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
@christianonphotography
@christianonphotography 10 месяцев назад
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 10 месяцев назад
Because I did more work on it. Video description has link to download sample app (members only - check description for details)
@jamesclark2020
@jamesclark2020 10 месяцев назад
Power Apps just keeps getting better and better.
@RezaDorrani
@RezaDorrani 10 месяцев назад
I agree
@gavinm2339
@gavinm2339 10 месяцев назад
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 10 месяцев назад
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.
@pkns_cad
@pkns_cad 10 месяцев назад
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 10 месяцев назад
Thanks! Yes, similar pattern can be applied.
@pkns_cad
@pkns_cad 10 месяцев назад
@@RezaDorrani okay, great. Thank you !
@sankhlayashraj
@sankhlayashraj 10 месяцев назад
Another fantastic video Reza. Waiting when this would be available in canvas apps. Superb work
@RezaDorrani
@RezaDorrani 10 месяцев назад
Very soon!
@mahamkhan8314
@mahamkhan8314 10 месяцев назад
This is awesome but it would have been amazing if it had edit rights (editable grid)
@RezaDorrani
@RezaDorrani 10 месяцев назад
Currently it is a read only control by design
@porschefuel
@porschefuel Месяц назад
For some reason, when I click the submit button. It only submits the first edit into my datasource for example: original: CS1 1st Edit: CS1YYYYYYY It doesn't submit subsequent changes to my Datasource Appreciate your help in this Reza
@RezaDorrani
@RezaDorrani Месяц назад
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@samitbhattacharya2201
@samitbhattacharya2201 10 месяцев назад
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 10 месяцев назад
Works with collections
@sankhlayashraj
@sankhlayashraj 10 месяцев назад
Another fantastic video Reza. Waiting when this would be available in canvas apps. Superb work❤
@RezaDorrani
@RezaDorrani 10 месяцев назад
Very soon!
@ozodinson6632
@ozodinson6632 4 месяца назад
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 4 месяца назад
Row height in table control? I don’t think we have an option today
@venumadhavravulapalli1463
@venumadhavravulapalli1463 10 месяцев назад
Awesome video Reza… this will save huge efforts and time for developers working on gallery with more than 15 columns
@RezaDorrani
@RezaDorrani 10 месяцев назад
I agree
@ratke_
@ratke_ 2 месяца назад
omg i love you!!!
@RezaDorrani
@RezaDorrani 2 месяца назад
Thanks
@niiikhiiil
@niiikhiiil 10 месяцев назад
Thanks Reza. Time to upgrade my Apps to Modern controls.
@RezaDorrani
@RezaDorrani 10 месяцев назад
👍
@luongthu5615
@luongthu5615 10 месяцев назад
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 10 месяцев назад
SharePoint lists and Microsoft lists are one and the same.
@roma9026
@roma9026 10 месяцев назад
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 10 месяцев назад
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.
@princeofchaos
@princeofchaos 5 месяцев назад
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 5 месяцев назад
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
@hamzasiddiqui9105
@hamzasiddiqui9105 8 месяцев назад
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 8 месяцев назад
There is a known issue with column widths.
@hamzasiddiqui9105
@hamzasiddiqui9105 8 месяцев назад
@@RezaDorrani Yeah, I figured. I ended up using creator kit's fluent details list. Thank you for your quick response Reza.
@DavidJones-te9rf
@DavidJones-te9rf 9 дней назад
Reza, great stuff. I can see this offering a great deal of flexibility to filter larger record libraries (document libraries). Do you have any references or pointers to how we would incoporate this table on top of a document library - and open the underlying document on click ?
@RezaDorrani
@RezaDorrani 9 дней назад
I have done videos on document library browsing and more that leverage galleries. Similar concept would apply here.
@surabhigoyal1736
@surabhigoyal1736 2 месяца назад
Hello Reza, can we apply validation on the data table columns similar to excel and highlight the incorrect cell data? if yes, would like to know how it can be achieved? Thanks :)
@RezaDorrani
@RezaDorrani 2 месяца назад
The Table control is currently a read-only control.
@breadandcheese1880
@breadandcheese1880 10 месяцев назад
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 10 месяцев назад
The Table control is currently read-only.
@breadandcheese1880
@breadandcheese1880 10 месяцев назад
@@RezaDorrani Thanks Reza!
@SandipMohapatra-d3d
@SandipMohapatra-d3d 6 месяцев назад
@Reza This is very good and easy to create a table view. But I am facing a problem here , for example if I have let say more than 20 columns which I want to show here , in this case it is showing very small length where we can not read the complete column title and I did not find the solution for this. Can you please suggest how can I do this ?
@RezaDorrani
@RezaDorrani 6 месяцев назад
Welcome! I believe you can change the column width manually.
@SandipMohapatra-d3d
@SandipMohapatra-d3d 6 месяцев назад
@@RezaDorrani Yes I can change it manually. Like if I run the app and then I am able to change it. But when I closed and reopen it is still the same. I need to do it again for all the 20 columns . Is it possible to fix that in develpment it self so that when it runs it show with proper size with a scroll bar ?
@RezaDorrani
@RezaDorrani 6 месяцев назад
@@SandipMohapatra-d3d Did you try doing this in edit mode of app and then publishing?
@SandipMohapatra-d3d
@SandipMohapatra-d3d 6 месяцев назад
@@RezaDorrani Yes, but in app mode there is no option to do so. I have only option to change the column manually once I run it.
@RezaDorrani
@RezaDorrani 6 месяцев назад
@@SandipMohapatra-d3d There is an option in edit mode. Hold Alt key and do it.
@Ezechielpitau
@Ezechielpitau 2 месяца назад
Is it possible to combine this with your graph api search to make full string searches possible in sharepoint lists? I just can't explain not being able to offer full text search (and we have more than 10k items in that project list)
@RezaDorrani
@RezaDorrani 2 месяца назад
Should be possible but not something I have tried. Full text search is NOT an option with SharePoint. Dataverse or SQL is the answer to that.
@NathanielCongreso
@NathanielCongreso 3 месяца назад
Hi Reza, I tried using the new table but when I use Addcolumns some column data is missing, to be specific, my first, middle, last names are on differnt columns but when I combined them using addcolumns other data is blank
@RezaDorrani
@RezaDorrani 3 месяца назад
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@olujustus
@olujustus Месяц назад
Hi Reza, Thanks for the wonderful insights gained from your videos, on this particular video, I can't seem to get the detailed steps to line up the canvas to include all the containers, is there a more detailed steps video that walkthrough adding all the other containers and form? Kind Regards
@RezaDorrani
@RezaDorrani Месяц назад
As a channel member (gold or silver) - you can download the entire solution. Link in community tab. This video is the only reference I have.
@upendrauppu1117
@upendrauppu1117 10 месяцев назад
Thanks Guruji for another valuable input
@RezaDorrani
@RezaDorrani 10 месяцев назад
Most welcome
@AndrewK-b6i
@AndrewK-b6i 8 месяцев назад
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 8 месяцев назад
Im showing and hiding container based upon an item being selected in table.
@hackmo
@hackmo 10 месяцев назад
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 10 месяцев назад
It does not work with complex type columns. Its a known limitation.
@hackmo
@hackmo 10 месяцев назад
@@RezaDorrani Thanks for the quick reply! I'll keep an eye out on the development to check for when complex types work :)
@RezaDorrani
@RezaDorrani 10 месяцев назад
@@hackmo From what I know, it wont be soon
@daisukeniwatari6616
@daisukeniwatari6616 13 дней назад
Hi Reza, just wanted to ask if you've tried using a date in the table and were you able to hide the time when showing data in the table. I have a dataverse date only column but it still shows 12:00 AM on all my dates
@RezaDorrani
@RezaDorrani 13 дней назад
Yes, thats by design for now.
@davidgraham6238
@davidgraham6238 9 месяцев назад
Nice work Reza! Would be nice to see 'OnSelect' functionality of a record. Is that in the works?
@RezaDorrani
@RezaDorrani 9 месяцев назад
Thanks! Im not aware if that is in the works.
@mrnock2
@mrnock2 6 месяцев назад
I have achived that by adding this code to the Table1 On Select property: Set(varItem,Table1.Selected); I hope it helps 👍
@uwuwonyo7502
@uwuwonyo7502 5 месяцев назад
When I connect my data to the modern table it doesn't show the dates, but it shows the dates in the classic data table. Why could this be?
@RezaDorrani
@RezaDorrani 5 месяцев назад
Modern table is in preview. I have not faced any issues with it though so not sure.
@NicoleBemfica
@NicoleBemfica Месяц назад
How to resolve the delay issue from the Sharepoint to the Table, after the data is collected/adjusted ?
@RezaDorrani
@RezaDorrani Месяц назад
It is immediate. My latest video uses table and form connected to SharePoint list.
@steveh8204
@steveh8204 9 месяцев назад
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 9 месяцев назад
Check my videos on SharePoint filtering. I have done 4-5 of them.
@MoiseJurca
@MoiseJurca 8 месяцев назад
Hallo Reza, how can I download the App from this video if i habe Silver Membership?
@RezaDorrani
@RezaDorrani 8 месяцев назад
All links are shared in Community Tab
@chrisadriano3461
@chrisadriano3461 5 месяцев назад
Hi Reza, If I join today for Silver membership. Will I still have access to the app on this video?
@RezaDorrani
@RezaDorrani 5 месяцев назад
Yes but you would need to post a message in community tab for me to re-enable the link
@gilbertpradier
@gilbertpradier 10 месяцев назад
@reza Is this control still in preview or GA..? Thank you for the video.
@RezaDorrani
@RezaDorrani 10 месяцев назад
Preview
@gilbertpradier
@gilbertpradier 10 месяцев назад
Thank you@@RezaDorrani
@CapstonePMConsulting
@CapstonePMConsulting 4 месяца назад
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 4 месяца назад
This is currently a known issue. It will try and fit columns in available space.
@andizone3197
@andizone3197 6 месяцев назад
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 6 месяцев назад
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.
@karun1369
@karun1369 3 месяца назад
Thanks Reza, I have a question how can we select multiple rowns in if so how can we do that because currently it limited to one record.
@RezaDorrani
@RezaDorrani 3 месяца назад
Currently, it’s limited to one record only. You would need to use gallery for multiple select options.
@venusv4698
@venusv4698 5 дней назад
Table control does not have wrapping function right?
@RezaDorrani
@RezaDorrani 5 дней назад
Currently No
@VANDIK01
@VANDIK01 2 месяца назад
Hi Reza, why the table not load the items? only show them when I start typing into the Text input control, thanks
@RezaDorrani
@RezaDorrani 2 месяца назад
I have not experienced this issue.
@gatskopsoftware8357
@gatskopsoftware8357 10 месяцев назад
My text in the grid looks blurry on play mode how can I fix that?
@RezaDorrani
@RezaDorrani 10 месяцев назад
Control is in preview. Blurry effect is a bug which is fixed or will be fixed in future release.
@jasonmoreton461
@jasonmoreton461 5 месяцев назад
Reza could I ask how you tie the combo box control to the Department column on your SP list please?
@RezaDorrani
@RezaDorrani 5 месяцев назад
It probably was a lookup column
@sanjaykumarize
@sanjaykumarize 5 месяцев назад
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 5 месяцев назад
I don’t think that’s an option yet
@thomasboden4053
@thomasboden4053 4 месяца назад
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 4 месяца назад
Currently, changing display formats is not supported
@MichellebayerutubeBarton
@MichellebayerutubeBarton 17 дней назад
Reza, would you be so kind as to re-share the download sample app on this one for a desperate Silver member?
@RezaDorrani
@RezaDorrani 17 дней назад
Happy to. Can you please post a comment on the secured community post for silver members.
@subiwasabi_
@subiwasabi_ 8 месяцев назад
Why my modern table control doesn't display the number of records in the table? Is it an add-on?
@RezaDorrani
@RezaDorrani 8 месяцев назад
Table control is in preview. There will be changes before it goes GA.
@moeking5601
@moeking5601 9 месяцев назад
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 9 месяцев назад
It is not a premium connector
Далее
Editable Grid in Power Apps | SharePoint List
42:49
Просмотров 379 тыс.
Сколько стоит ПП?
00:57
Просмотров 143 тыс.
Обменялись песнями с POLI
00:18
Просмотров 330 тыс.
Top 5 Must-Know GALLERY Features in Power Apps
15:55
Просмотров 32 тыс.
Power Apps With Function - Explained
9:06
Просмотров 680
Google Data Center 360° Tour
8:29
Просмотров 5 млн
Сколько стоит ПП?
00:57
Просмотров 143 тыс.