Mastering Modern TABLE Control in Power Apps | Working with Multiple Related Tables

  Рет қаралды 32,172

Reza Dorrani

Reza Dorrani

Күн бұрын

In this Power Apps tutorial, we dive deep into utilizing the latest Modern TABLE control within Canvas PowerApps. Join me as we construct a fully responsive canvas app that seamlessly interacts with multiple related tables in Dataverse.
Throughout this tutorial, we'll explore various aspect of the Modern Table control, empowering you to show your data in tabular, list format, style table data and more. Learn how to add sorting and searching capabilities in modern table control, and seamlessly connect with multiple related Dataverse Tables & Form control to allow user to create & edit data.
Key Highlights:
🔵 Construct a responsive canvas app with multiple Modern Table controls.
🔵 Explore the interconnection between related tables in Dataverse.
🔵 Enable users to search & sort data within the Modern Table control.
🔵 Establish connections between Table controls and other app elements such as Forms.
Let's get started with learning the Modern Table Control in Power Apps
#powerplatform #powerapps #microsoft #dataverse
⬇️ Download Solution shown in video
➡️ The link is in Community Tab for Channel Members (Silver Club 🥈 or Higher)
Table of Contents:
00:00​ Introduction to building Power Apps with multiple related Modern Table controls
00:32 Scenario: Related tables in Dataverse
01:09 Build Responsive Canvas Power Apps with Modern Table control
01:39 Enable Modern Controls in PowerApps
02:17 Explore Modern Table control properties in depth
05:46 Search in Modern Table control
07:24 Build multiple connected Table controls in Power Apps
10:20 Connect Modern Table control to Modern Form Control

Пікірлер: 208
@btoz6237
@btoz6237 3 ай бұрын
Great video as always Reza! Nice to see them adding in sorting & styling to the modern table control.
@RezaDorrani
@RezaDorrani 3 ай бұрын
👍
@dougydoe
@dougydoe 3 ай бұрын
A very informative and insightful tutorial on the modern table control. A feature rich option to use in certain use cases instead of always leaning on the Gallery. Thanks for sharing, Reza.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Glad to hear that! Thanks so much Doug
@ederson1337
@ederson1337 3 ай бұрын
This is exactly what I'm looking for. Thank you, Reza! Great Video.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Most welcome
@aimeeoneil7029
@aimeeoneil7029 2 ай бұрын
Thanks for this video! It is very helpful.
@mohamedbamba5098
@mohamedbamba5098 2 ай бұрын
Thank you for this video! It is very, very complete.
@RezaDorrani
@RezaDorrani 2 ай бұрын
You are most welcome!
@simonball5602
@simonball5602 3 ай бұрын
Thank you Reza. Really great and informative video. A true master.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thanks so much
@johnlopes1784
@johnlopes1784 2 ай бұрын
Thank you for share this video!
@RezaDorrani
@RezaDorrani 2 ай бұрын
My pleasure
@JorgeOyanadel
@JorgeOyanadel 3 ай бұрын
Wow, muchas gracias Claro, directo, sencillo, extraordinario
@RezaDorrani
@RezaDorrani 3 ай бұрын
Most welcome!
@spen2431
@spen2431 3 ай бұрын
Clean and Simple. Great vid Reza 👍👍
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thanks
@justmyluckxx
@justmyluckxx 7 күн бұрын
Thank you so much for your videos, it helps a lot to learn power app! 🥰
@RezaDorrani
@RezaDorrani 7 күн бұрын
You're so welcome!
@naveenkumarpenumalla7221
@naveenkumarpenumalla7221 3 ай бұрын
Thanks, Reza. It will be helpful
@RezaDorrani
@RezaDorrani 3 ай бұрын
Glad to hear that
@temidayolonge4566
@temidayolonge4566 3 ай бұрын
As always you are the man.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thanks ya
@mkersoy
@mkersoy 3 ай бұрын
Great video thank you for all. Power apps has come a long way with these modern controls 👏🏼👏🏼 but there are some bugs and missing features hope they all will be solved soon
@RezaDorrani
@RezaDorrani 3 ай бұрын
Most welcome
@ericmild4050
@ericmild4050 3 ай бұрын
Good stuff. Thanks
@RezaDorrani
@RezaDorrani 3 ай бұрын
Welcome!
@user-nv4wv1pb8o
@user-nv4wv1pb8o 3 ай бұрын
Thank you Reza.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Welcome
@jameshart9519
@jameshart9519 3 ай бұрын
Brilliant video again Reza. So helpful. One of the only downsides I have found in using the table control is that it displays dates such as 'created on' and 'modified on' in the American format rather than uk format.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thanks! Formatting of data in table control is currently not an option.
@sppsghosh
@sppsghosh 2 ай бұрын
Reza, I like all your videos. Very informative. keep up the good work! Do you have a video with multiple tables in master detail relationship in tabbed format in one form.? Can you share the video please? Many Thanks !
@RezaDorrani
@RezaDorrani 2 ай бұрын
I dont think I have a video reference on that
@oluwatobiyusuf
@oluwatobiyusuf Ай бұрын
Thank you Reza
@RezaDorrani
@RezaDorrani Ай бұрын
Welcome
@suhas220780
@suhas220780 3 ай бұрын
Thanks Reza for sharing this video of Modern table. This help in designing Power App using Modern Table. Just one thing i wanted to know why is filter option in Modern table disabled thanks.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Because its not available yet 😊
@m-o42
@m-o42 15 күн бұрын
Apparently the "DelayOutput" property is gone, Text Input now has a property called "Trigger output", if you set it as "Delayed" it gives you the same behavior. Cool video, Reza. :)
@RezaDorrani
@RezaDorrani 15 күн бұрын
Yes, it's now 'Trigger Output'
@mtamitolanga
@mtamitolanga 3 ай бұрын
Thank you Reza for the video.... would you recommend the use of preview modern controls in production? 🤷‍♂
@RezaDorrani
@RezaDorrani 3 ай бұрын
As long as it meets your requirements then why not?
@sppsghosh
@sppsghosh 2 ай бұрын
Thank you Reza for your reply! Quick question : If I'm using the Modern controls and Themes in Power APPs, and I have Master and Detail table. To show the detail table only those records which is selected in Master, what should I use? If I have ID as PK in both the tables, how can can I do it?
@RezaDorrani
@RezaDorrani 2 ай бұрын
Im not sure how I can help on chat. I will recommend posting your issue on forums in case someone has done something similar powerusers.microsoft.com
@zero2herobeatspaul882
@zero2herobeatspaul882 3 ай бұрын
Thanks for the tutorial. Would you be comfortable to use the preview controls in Production apps? Maybe if the apps are not mission critical?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Yes I would be as long as it meets my requirements.
@nguyenhoanggiang7297
@nguyenhoanggiang7297 3 ай бұрын
Thank you. Can you add the checkbox in left of the Company table? Then user can select 1 or many record.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Currently, table control does not support that feature
@butiky
@butiky 11 күн бұрын
Great video!!!, 1 qq, how you can use the search icon or emoji in the text input for the search control for the table??
@RezaDorrani
@RezaDorrani 11 күн бұрын
To add emojis user windows+. to open emoji keyboard
@alec734
@alec734 2 ай бұрын
Great video! I noticed the disabled filter option on the column headers, is there a way to use these or is an incoming feature?
@RezaDorrani
@RezaDorrani 2 ай бұрын
Most probably an incoming feature
@blazejay1
@blazejay1 2 ай бұрын
Thanks Reza! Do you know when the "filter by" column options are going to be activated?
@RezaDorrani
@RezaDorrani 2 ай бұрын
I am not aware of the "Filter By" timeline
@martinsmuts2557
@martinsmuts2557 Ай бұрын
Thanks for this video Reza. Is there a way to join related tables in one table (like an inner join)? For example, I have created a View on two related Dataverse tables, but when linking the Table and its View to a Modern table on Canvas App, it does not allow to select the related table columns - only the main table. Do you know if this is a limitation on the Modern Table in Canvas App?
@RezaDorrani
@RezaDorrani Ай бұрын
I have not tried this but my guess is it may very well be a limitation
@sathiyasaravanan382
@sathiyasaravanan382 3 ай бұрын
Thank you so much for this video 😊... Can you please show us using power automate how can we pull the data from Ado to SharePoint list online
@RezaDorrani
@RezaDorrani 3 ай бұрын
Most welcome! Look like ur ask is on a completely different topic. My rule for topic suggestions is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post”
@HardikGajjar-wi6lg
@HardikGajjar-wi6lg 3 ай бұрын
Thank you, Reza, for creating this informative video. I have a question regarding the Table modern control: Can we change the display property of a specific column? For example, if we have a datetime column in the Dataverse table, can we configure it to display only the date and not the time? If you could provide an answer to this question, it would greatly assist me.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Most welcome! Currently, there is no option to format the display behavior of a column.
@danielexpoliojuarez3180
@danielexpoliojuarez3180 3 ай бұрын
Hi Reza Thanks for the vid, is there any possibbility to change de default of a column? Like changing how a bollean is shown?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Currently, we cannot change the default display behavior
@mw011i
@mw011i 3 ай бұрын
Thanks for the tip about using ‘Alt’ to adjust column widths. I’ve been having the issue where column widths always revert to minimum, forcing me to constantly adjust.
@RezaDorrani
@RezaDorrani 3 ай бұрын
That would still happen when user runs the app. The limitation is called out in documentation for Table control which is currently in preview
@mw011i
@mw011i 3 ай бұрын
I see, thanks for confirming. I’m hopeful that this will be fixed when modern controls become more mainstream.
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@mw011i I hope so too
@EMiller500
@EMiller500 2 ай бұрын
Hi Reza! Thank you for this great video! Question: When I use the modern table control, it does not display the data in choice columns for me. Why is that? How can I fix it? (I'm running this app and the Dataverse table in Teams.) Could it have something to do with the "global choice" selection? I'm not clear on what "global choice" is for or how to use it.
@RezaDorrani
@RezaDorrani 2 ай бұрын
Im not aware of any limitations for DV4T
@sppsghosh
@sppsghosh 2 ай бұрын
Reza, Thanks for sending me the link of the above Video! Much appreciated. I'm trying to do a master detail (One to many relationship) between two tables. I'm stuck on how to show the details table data for those selected in Master table when the relationship is not established in sql server. Although there are columns like ID in both master and details tables which can be joined. Can you please help?
@RezaDorrani
@RezaDorrani 2 ай бұрын
These videos are the best references I have. I have done no work with sql so not sure how to help. I will recommend posting your issue/query on forums in case someone has done something similar powerusers.microsoft.com
@maio8958
@maio8958 2 ай бұрын
Hi Reza thanks for the video! I'm having a problem tho, tha table rows sometimes are not updated even if the filtering/searching is correctly done (the row number on bottom sx shows the right number). Any idea on what could possibly cause the problem? thanks!
@RezaDorrani
@RezaDorrani 2 ай бұрын
Video description has details on how to download entire solution (you can check all the logic I used in it)
@travisstrean4185
@travisstrean4185 3 ай бұрын
Great video! I was super excited when Microsoft added the table control, but it still has too many issues to be used. The column widths don't stick, row heights can't grow, column names don't change, and there are too many scenarios that result in the table values appearing fuzzy. I think I've narrowed the fuzzy issue to laptop screens and screens that aren't run at the recommended setting. For example, I have 4k monitors and if I run them at 1080p the table data gets fuzzy and hard to read. They also don't work well with custom canvas resolutions. Hopefully, Microsoft will continue to develop the table control because it would be a great addition. For now, the gallery is probably the better approach depending on the use case.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thanks for the feedback
@cedartree816
@cedartree816 22 күн бұрын
Great tutorial, curious how you avoided the delegation warning for the search box warning though.
@RezaDorrani
@RezaDorrani 22 күн бұрын
Search is a delegable query with Dataverse
@cedartree816
@cedartree816 20 күн бұрын
@@RezaDorrani Yet another reason I can use to justify licensing dataverse 😆
@dbosset
@dbosset 3 ай бұрын
Thanks, Reza. After an item is selected, how can you deselect it without selecting another item in the table, ie. deselect all?
@RezaDorrani
@RezaDorrani 3 ай бұрын
I dont think there is an option to do that other than the Table control reloading.
@jmrussi1968
@jmrussi1968 Ай бұрын
@RezaDorrami, yesterday I had a not very good surprise with this control. It simply stopped to show values, with a message of "No column selected". This at an app scheduled to be released next week. I opened a support ticket and the answer was that this control is still under preview, and that there is nothing they can do to solve it.
@RezaDorrani
@RezaDorrani Ай бұрын
Check this post which explains about preview vs GA www.microsoft.com/en-us/power-platform/blog/power-apps/ga-of-many-long-time-preview-features/ I have not experienced any issues with table control recently. Have also not seen any customers report this.
@jimmyandrianina444
@jimmyandrianina444 15 күн бұрын
Hello Reza!Is there any way to directly edit data entry from the table?Thank you!
@RezaDorrani
@RezaDorrani 15 күн бұрын
Currently, Table control is ready only. For editing via grid, check my playlist on grid control
@kedar910
@kedar910 2 ай бұрын
Hi Reza, is there a way to search on an already filtered data on table control. I have filtwred the table.to nly show the items belonging to the current user and i want to be able to search on rop of that.
@RezaDorrani
@RezaDorrani 2 ай бұрын
Search and Filter functions can be combined
@sankhlayashraj
@sankhlayashraj Ай бұрын
@Reza - Wanted to check with you one thing - If I select an item in the data table, I am able to navigate the same to a page where I have a gallery. I would like to know how I can select that item in that Gallery that I have selected in the table. Also would like to know a work around to get countrows as there is a delegation issue. I understand the new table gives the count, but I would like to give a better UI to my users.
@RezaDorrani
@RezaDorrani Ай бұрын
Why would you have a table for selecting and then a gallery for selecting? Sounds like duplication. Countrows is not a delegable function and Im not aware of any workarounds.
@sankhlayashraj
@sankhlayashraj Ай бұрын
@@RezaDorrani Agreed. Thanks much...
@salrathor1
@salrathor1 23 күн бұрын
Hi Reza, Thanks again for this video but I have another question. Is it possible to increase the default size of the table above 25? i.e. the pagination occurs at 25 items.
@RezaDorrani
@RezaDorrani 22 күн бұрын
Currently, the default pagination size cannot be changed
@kingslayer786
@kingslayer786 3 ай бұрын
The modern table has a problem...upon scrolling more than 25 rows at once in list view mode loses the current selection field...you have any workaround for this?
@RezaDorrani
@RezaDorrani 3 ай бұрын
The control is in preview and does have its challenges at the moment. This is one of them. I do not have a workaround for it.
@kingslayer786
@kingslayer786 3 ай бұрын
@@RezaDorrani np. Thanks Reza.
@user-io2zz7nr1t
@user-io2zz7nr1t 2 ай бұрын
Great video as per usual. I implemented the table and I am unable to get the sorting to work. Any ideas?
@RezaDorrani
@RezaDorrani 2 ай бұрын
I have not run any issues with it so not sure. Note: sorting mainly works with text columns. Check documentation for limitations
@user-io2zz7nr1t
@user-io2zz7nr1t 2 ай бұрын
Ah found the issue, now just need to resolve. My data is a Collection and not a table
@mariohiraldo2621
@mariohiraldo2621 2 ай бұрын
Great video as always. How delete works on the table.
@RezaDorrani
@RezaDorrani 2 ай бұрын
Select an item, then have a button similar to edit. When user clicks on it, use remove function
@mariohiraldo2621
@mariohiraldo2621 2 ай бұрын
@@RezaDorrani Thank you
@juanpablogutierreztrujillo6995
@juanpablogutierreztrujillo6995 3 ай бұрын
Hi! Very useful info here, I've a question, how can I format to currency type a field of this table? If I have a to format a long Date to short date, how can I do it? Thanks for the help!!
@RezaDorrani
@RezaDorrani 3 ай бұрын
Currently, formatting of data is not supported
@juanpablogutierreztrujillo6995
@juanpablogutierreztrujillo6995 3 ай бұрын
@@RezaDorrani Thank you very much!! And I'm very gratefull to meet you and your content! ☺️
@Chaddcl0ps813
@Chaddcl0ps813 2 ай бұрын
Hey Reza! Thanks for the video. Have you noticed any problems with the sorting feature of this table? None of my sortings work properly. It doesnt put them in order
@RezaDorrani
@RezaDorrani 2 ай бұрын
Works on text cols only
@Chaddcl0ps813
@Chaddcl0ps813 2 ай бұрын
I noticed it doesnt sort if you use a collection. will only sort on direct datasource
@RezaDorrani
@RezaDorrani 2 ай бұрын
@@Chaddcl0ps813 The control is in preview. It will have limitations.
@shadhaalazri8099
@shadhaalazri8099 2 ай бұрын
Hi, I have a task to create 360 feedback tool in Powerapp application. Can you show us how to develop one? I tried to use the list to create the Q forms but how to send the forms for stakeholders to answer and give feedback and how to analyze the results.
@RezaDorrani
@RezaDorrani 2 ай бұрын
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@deborahjoyous
@deborahjoyous 3 ай бұрын
Another excellent video! Three questions: 1) Can I filter by a field, such as Employee ID, that is NOT included in my table, but IS included in the data source list? 2) Can I wrap text for column headings and multiple line content fields? 3) For calculated columns that are formatted both in the data source list and the form used to insert new rows to have 2 numbers after the decimal, how can I display them that way in the form? At the moment, they are displaying 14 numbers after the decimal. Thank you!!!
@RezaDorrani
@RezaDorrani 3 ай бұрын
1) Possible by using filter function on items property of table 2) Currently, No 3) No idea about this
@deborahjoyous
@deborahjoyous 3 ай бұрын
@@RezaDorrani, thank you for your quick reply. I am very new to Power Apps - would you have a link to another of your videos that explain using filter function on items property of table? I have many rows in my Power Apps Form table that I would like to filter by selecting an Employee ID from a drop-down. The Employee ID had to be removed from the table but it is in the underlying SP List. Once an Employee ID is selected from the drop-down, it would filter the table to show only the rows that belong to that particular Employee ID (they may have many related rows in the table). Thanks again!
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@deborahjoyous I have done many videos on filtering galleries and one with table control. They are all in playlists in my channel.
@deborahjoyous
@deborahjoyous 3 ай бұрын
@@RezaDorrani thank you - I will search those.
@mja6546
@mja6546 2 ай бұрын
Hello Reza, How do you activate that emoji keyboard? How useful it is to add icons to the application.
@RezaDorrani
@RezaDorrani 2 ай бұрын
windows+.
@Sab-ph7zl
@Sab-ph7zl 3 ай бұрын
Excellent timing I was looking for similar one, your videos always come as my first reference. Additionally, is it possible to edit the Heading title in modern control? If not, what is the better alternative for responsive screen?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thanks! What is heading title?
@Sab-ph7zl
@Sab-ph7zl 3 ай бұрын
@@RezaDorrani I mean column name. It takes the default column name from data source; how could I change as I needed?
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@Sab-ph7zl Currently, changing names or formatting data is not supported (as far as I know)
@Sab-ph7zl
@Sab-ph7zl 3 ай бұрын
@@RezaDorrani That's disappointing! Also I'd appreciate if you can help me understand how to control default selection in the modern table control? I am trying to run an action based on record selection. But when I write an if condition with IsBlank property it always returns false despite no record selection.
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@Sab-ph7zl That is also a limitation. Please note the control is in preview.
@sankhlayashraj
@sankhlayashraj 3 ай бұрын
Looks like it can be used like. Modern gallery… not exactly, but somewhat like that
@RezaDorrani
@RezaDorrani 3 ай бұрын
It’s more like a data table. Modern galleries will come in future.
@robfreeman1987
@robfreeman1987 2 ай бұрын
Hi, Thanks. At 8:50 you connect the two tables but guessing you are using Dataverse. How can this be done with other data sources like SharePoint?
@RezaDorrani
@RezaDorrani 2 ай бұрын
kzfaq.info/get/bejne/Z7ejmZWDtd_UaKc.htmlsi=LUnLqJZAB4PVXXhO
@DanielBitters
@DanielBitters 4 күн бұрын
Great tutorial! When I add the search input, it doesn’t allow the sorting of the table to function properly anymore. Even though it says the sorting is enabled, it just doesn’t work anymore. Any ideas why this is happening? I’m using a share point list as a data source.
@RezaDorrani
@RezaDorrani 4 күн бұрын
After you search the sorting will be lost. User would need to sort again.
@DanielBitters
@DanielBitters 4 күн бұрын
@@RezaDorraniI mean once I create the search capability, it completely removes the sorting functionality altogether. I am unable to sort anymore, even if I am not searching in that instance, even if I click “ascending” or “descending” on the table.
@RezaDorrani
@RezaDorrani 4 күн бұрын
I have not experienced that issue
@khanmali68
@khanmali68 3 ай бұрын
Thanks, Reza. The edit function keeps giving the error "Network error when using patch function: An Error occurred on the server." Just to let you know that I am using SharePoint List
@RezaDorrani
@RezaDorrani 3 ай бұрын
I have not come experienced this 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
@nodirjonsattarov6296
@nodirjonsattarov6296 Ай бұрын
is it possible to patch from the modern table to another list in SP?
@RezaDorrani
@RezaDorrani Ай бұрын
Possible but not something I have tried
@bokinloch9045
@bokinloch9045 3 ай бұрын
will the modern table control work with data sources other than dataverse? e.g., SharePoint list?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Yes as per documentation
@thomasboden4053
@thomasboden4053 3 ай бұрын
Is there a way to have the secondary table display different linked data depending on what you select from the primary table? Also would this work with lists?
@RezaDorrani
@RezaDorrani 3 ай бұрын
What does different linked data mean? Currently it shows linked data depending upon the relationship. End of the day, there must be some reference with main table. Can also work with SharePoint lists - formulas wont be same though.
@thomasboden4053
@thomasboden4053 3 ай бұрын
@@RezaDorrani so if I had two tables references from the primary, so if I clicked ‘name’ it would show all associated projects as in yours, but if I had another table with financial data could I select a separate column and display the other referenced data? Would and ‘if’ statement work with table.selected? Do you happen to know the lists formulas?
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@thomasboden4053 It should work but not something I have tried. Give it a shot and check
@thomasboden4053
@thomasboden4053 3 ай бұрын
@@RezaDorrani thanks for replying 😊
@khanmali68
@khanmali68 3 ай бұрын
I figured it out by removing the data fields and adding them back.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Great
@PankilBhatt71
@PankilBhatt71 3 ай бұрын
Hi That is really helpfull content but one more question when we are adding lookup column in modern table control it will not works getting blank column why is that?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Lookup column for which data source? Works fine with Dataverse
@PankilBhatt71
@PankilBhatt71 3 ай бұрын
@@RezaDorrani SharePoint data source .
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@PankilBhatt71 Currently table control (preview) works best with Dataverse (video shows Dataverse)
@robertomarra2431
@robertomarra2431 8 күн бұрын
Hi Reza, everything is great and your video helped me a lot, I got a problem though. Let say that at the beginning my table got only one record. I used the OnSelect property of the table to open a container where I got the form to edit data. Problem is that when I close the side container to go back to the table I can't re-open the edit form container, because the record is already selected and doesn't respond anymore to the OnSelect event and so far I didn't find any solution to this. Any Idea how could I solve this?
@RezaDorrani
@RezaDorrani 8 күн бұрын
When you close the side container- you can set a variable to false and then set that same variable to true. Then use that variables as filter on items property of table.
@robertomarra2431
@robertomarra2431 7 күн бұрын
@@RezaDorrani First, thank you for your kind reply! Sorry but don't know if I right understood but, when I close the container (I mean, when I set Visible = false) I set variable Set(var_test, false); Set(var_test, true); one after the other. But in the items property of the table (considering that is a collection) how can I use it? I mean I tried with Filter(, var_test) but of course doesn't work.
@RezaDorrani
@RezaDorrani 7 күн бұрын
@@robertomarra2431 why a collection on table? Collections are not delegable
@robertomarra2431
@robertomarra2431 7 күн бұрын
@@RezaDorrani doing this the second time because apparently didn't save my answer. Anyway I'm using a collection and there is no problem about delegation because record will be top 20-30 no more, and mostly I'm using it because I make use of those default SharePoint fields like "Created", "Modified".. date field that I can't format with dd/mm/yyyy so I wrote the following code ClearCollect(cl_activity_project, AddColumns(TPL_Internal_Project_Activities, CreateDate, Text(Created, "dd/mm/yyyy"), ModifyDate, Text(Modified, "dd/mm/yyyy"), CreatedBy, 'Created By'.DisplayName, ModifiyBy, 'Modified By'.DisplayName ) ); In any case, sorry, but the first solution you gave me, I got hard time to understand what I've to do (mostly within the items property of the table)
@RezaDorrani
@RezaDorrani 7 күн бұрын
@@robertomarra2431 Its difficult to understand on chat by looking at formulas. I would suggest you post your issue on forums in case someone has tried something similar powerusers.microsoft.com/
@JustinDixon-o2p
@JustinDixon-o2p 18 күн бұрын
Hi, Can you point me to a tutorial video for the Timesheet app #2 ? Thanks.
@RezaDorrani
@RezaDorrani 18 күн бұрын
I do not have a video tutorial on that
@joywindsouza817
@joywindsouza817 2 ай бұрын
For searching, when you added the search function on items property of Table you did not get any delegation warning. When i tried, it is showing delegation warning. Any idea?
@RezaDorrani
@RezaDorrani 2 ай бұрын
My data source is Dataverse and I am searching on text columns.
@Coco-lr1sc
@Coco-lr1sc Ай бұрын
I had the same issue. I wasn't able to set the Search function on the Project panels. Hope you'll make a video to show us how to troubleshoot it @RezaDorrani
@RezaDorrani
@RezaDorrani Ай бұрын
@@Coco-lr1sc I have no plans for a follow up video on this topic
@Coco-lr1sc
@Coco-lr1sc Ай бұрын
I found this vid (kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html) but it's the (old) problem that's supposed to happen with SP lists. No idea why it happens to Dataverse dtb
@bcobra1
@bcobra1 Ай бұрын
Does table sorting work for lists larger than 15 items? My list doesn't sort at all when clicking the sort buttons
@RezaDorrani
@RezaDorrani Ай бұрын
It does sort on data > 15 items. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@bcobra1
@bcobra1 Ай бұрын
@@RezaDorrani the issue is with non U.S. date formats. You have to convert them to text then they can't sort correctly because of text conversion format. The modern table only shows dates in U.S format
@Ramen1991
@Ramen1991 2 ай бұрын
Hello! This video is really helpful for someone like me whose a beginner in powerapps. However, I'm struggling to insert the data table inside the container. Wheneve I tried to insert it, the data table is shows as a new screen. Please help. Thank you
@RezaDorrani
@RezaDorrani 2 ай бұрын
I have not come across this issue. Video shows step by step how I add the control into container. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@Ramen1991
@Ramen1991 2 ай бұрын
@@RezaDorrani Thank you so much! Really this video is very helpful. Can i ask another question? For the side container, I only what to view the selected items? What can i do? Thanks
@RezaDorrani
@RezaDorrani 2 ай бұрын
@@Ramen1991 You mean the main table? User can select 1 item there. Not sure I understood your question
@miteshs3270
@miteshs3270 3 ай бұрын
Why that in sort dropdown ..filter by option is disabled?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Because that’s a feature coming in future
@ArunKumar-zj6zd
@ArunKumar-zj6zd 3 ай бұрын
Table column width been resetting every time, is there a way to auto fit?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Currently, No. This is called out in documentation of table control
@work_in_projects608
@work_in_projects608 11 күн бұрын
so this layout does not have the capability of editing the actual table by clicking on the items , right? Seems like it only displays the values as text input and you can change it to "edit" for the data type....
@RezaDorrani
@RezaDorrani 11 күн бұрын
Currently, its a read only table experience.
@misterh1
@misterh1 Ай бұрын
This gets me part way, but I really need someone to model multiple tables in a header/detail line fashion. In this tutorial you have two forms and two tables, but it's not a parent/child table relationship and I need to find something like that. Not sure if that's something you could model here or if anyone knows of resources for that type of powerapp. I've been scouring the tutorials and haven't seen anything to really explain that process.
@RezaDorrani
@RezaDorrani Ай бұрын
I do not have a video reference on this. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@misterh1
@misterh1 Ай бұрын
@@RezaDorrani Actually, I stumbled on your 'Editable Grid' series which looks like I may be able to extrapolate what I need from. But thank you, I will also check the forum.
@coelhow
@coelhow 3 ай бұрын
Reza, why working with table intead of sharepoint list?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Why not? I plan to mix things up with Dataverse and SharePoint
@coelhow
@coelhow 3 ай бұрын
@@RezaDorrani Great, I don't even consider using tables since the SP lists are so workable
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@coelhow Tables are 10 times more powerful. If SharePoint works, then you should use it.
@neney83
@neney83 2 ай бұрын
Thanks for the video and the good explanations, but there is something I don't get, why making a video and promoting something that is in preview and that might be fundamentally changed before GA? For example the property "Selected" has been removed from the table even though it is still in the documentation. Maybe because it was never working properly and it was always returning an incorrect value.
@RezaDorrani
@RezaDorrani 2 ай бұрын
Because I make videos based on topics that subscribers suggest.
@joywindsouza817
@joywindsouza817 Ай бұрын
When you add the search on the items property, the sorting feature of table stops working. Please check this
@RezaDorrani
@RezaDorrani Ай бұрын
You mean the filter on the Table control? After you apply the filter, sorting is working (atleast on my side)
@joywindsouza817
@joywindsouza817 Ай бұрын
@@RezaDorrani yes. I think i figured why is it happening. My data source is sharepoint and the search query gives delegation warning. Hence the sorting on modern table fails to work
@sppsghosh
@sppsghosh 2 ай бұрын
Here is my statement : 'data_prospector.DP_UserSummary'.Selected.'data_prospector.DP_UserDatabaseList' in the formula for items for the detailed sidebarContainer Somehow it is not liking the "Selected" as a valid property or function. My intention is to access the selected row of the DP_UserSummary' table, to get to the details of Dp_UserDatabaseList It i also not liking the '.' (dot operator ). Can you help me to resolve it ?
@RezaDorrani
@RezaDorrani 2 ай бұрын
I will recommend posting your issue on forums powerusers.microsoft.com
@sppsghosh
@sppsghosh 2 ай бұрын
@@RezaDorrani Thanks! ... will do
@ruchiketjadhav4031
@ruchiketjadhav4031 Ай бұрын
How you inserted emoji in Placeholder If anyone know please answer
@RezaDorrani
@RezaDorrani Ай бұрын
Windows+. to insert emojis
@ruchiketjadhav4031
@ruchiketjadhav4031 Ай бұрын
@@RezaDorrani thank you
@leenashreeindrani532
@leenashreeindrani532 2 ай бұрын
Hi Reza Dorani, My self pavani I have been following the videos most of the time I need a quick help from you In the Power Platform There are many environments Each environment contains solutions, Independent Canvas application, Flows etc I am trying to fetch those details using PowerShell script but it does not give much details Could you share your thoughts on how we can fetch details
@RezaDorrani
@RezaDorrani 2 ай бұрын
I have not done any videos with powershell. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@leenashreeindrani532
@leenashreeindrani532 2 ай бұрын
I am looking for a solution to extract details could you please suggest other approaches
@leenashreeindrani532
@leenashreeindrani532 2 ай бұрын
Could you please step by step on Power Platform Centre of Excellence starter Kit if there is chance to get details
@RezaDorrani
@RezaDorrani 2 ай бұрын
@@leenashreeindrani532 My rule for making videos is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.”
@evaldasilginis3119
@evaldasilginis3119 28 күн бұрын
That table control looks incomplete. Does not show lookup column values. I had to create additional formula columns in the data source table to display the values ​​of the related lookup records. Column reordering by drag-and-drop is buggy, column order is better set in column control properties. I can't figure out how to display the date in a format other than "8/7/2024 12:00 AM". It looks like you need to create an extra formula column in the data source table just to display the dates in the desired format (but this appear also unavailable due the Dataverse column limitations). That's stupid. This widget is only suitable for the simplest scenario with no additional formatting, no lookup values.
@RezaDorrani
@RezaDorrani 28 күн бұрын
Table control is currently in preview. There are known bugs and limitations.
DELEGATION in Power Apps | Must Know to build efficient Apps
13:00
Reza Dorrani
Рет қаралды 43 М.
Editable Grid in Power Apps | SharePoint List
42:49
Reza Dorrani
Рет қаралды 364 М.
Box jumping challenge, who stepped on the trap? #FunnyFamily #PartyGames
00:31
Family Games Media
Рет қаралды 19 МЛН
Это реально работает?!
00:33
БРУНО
Рет қаралды 3,3 МЛН
Complete Project with Power BI, Power Apps, Power Automate and Dataverse
1:12:45
Named Formulas & User Defined Functions in Power Apps
13:41
Reza Dorrani
Рет қаралды 31 М.
Top 5 Must-Know GALLERY Features in Power Apps
15:55
Reza Dorrani
Рет қаралды 30 М.
Nvidia CEO: "We're Completely F**ked & Nobody Realizes It..."
13:47
Nvidia Latest News
Рет қаралды 8 М.
iPhone 15 Pro в реальной жизни
24:07
HUDAKOV
Рет қаралды 502 М.
Новые iPhone 16 и 16 Pro Max
0:42
Romancev768
Рет қаралды 2,4 МЛН
#samsung #retrophone #nostalgia #x100
0:14
mobijunk
Рет қаралды 14 МЛН
Look, this is the 97th generation of the phone?
0:13
Edcers
Рет қаралды 8 МЛН