Power Apps: Data Table Vs Gallery

  Рет қаралды 27,293

Daniel Christian

Daniel Christian

Күн бұрын

Пікірлер: 53
@taru250706
@taru250706 4 жыл бұрын
Thankyou Daniel. This really has come as my rescue this morning ! Perfect timing
@DanielChristian19
@DanielChristian19 4 жыл бұрын
You're so welcome!
@cchristoff
@cchristoff 4 жыл бұрын
Related to non-text controls, I would add that in a gallery you may handle input (e.g. a number or yes/no toggle) per each item. So if you just display data, then go with a data table. Otherwise the gallery is much more flexible.
@DanielChristian19
@DanielChristian19 4 жыл бұрын
Thanks for the input Hristo, I couldn't have said that any better 👌
@mehulchawhan6900
@mehulchawhan6900 3 жыл бұрын
Hey Daniel - we can do Horizontal Scroll bar in Gallery as well using Scroll control, i did that in my POC
@DanielChristian19
@DanielChristian19 3 жыл бұрын
Hi MehuL Horizontal scroll is available for horizontal galleries only and not for vertical. However, I have a a work around using containers and have shown how in this video kzbin.info/www/bejne/bnSloKaalLV6bZY
@PhilDennison
@PhilDennison 3 жыл бұрын
Great video, thanks. Makes me think due to the speed I could plan out using a data table and then replicate as a gallery when I’m happy with the layout/order etc.
@DanielChristian19
@DanielChristian19 3 жыл бұрын
Glad it was helpful!
@mukulchandravanshi5580
@mukulchandravanshi5580 3 жыл бұрын
Brilliant Video Daniel. Can you please help me how you have develop these pop screen?
@DanielChristian19
@DanielChristian19 3 жыл бұрын
Hey Mukul, Thanks for the compliment. For Pop screen, I add a label with some text and two buttons (Submit & cancel). Then I group them together. For the app's OnStart i use Set(varPop, false). I use varPop for the visible of the group we just created. In the first submit button I add set(varPop, true). This will make the group visible. In the final submit button I add all the formulas for Submit() or Patch and I also add set(varPop, false) Hope this helps!
@russellniebolt1493
@russellniebolt1493 3 жыл бұрын
Great video explaining differences, thanks Daniel!
@DanielChristian19
@DanielChristian19 3 жыл бұрын
Glad it was helpful!
@tenisviejos
@tenisviejos 4 жыл бұрын
Thank you Daniel, great video, as usual. This video is a great tool to help us choosing our data source, controls and improving UI/UX. Keep it up! Added: you can add HTML text to improve the URL functionality. This implies additional steps, but you can get the functionality via HTML tags w/o using the launch function
@DanielChristian19
@DanielChristian19 4 жыл бұрын
Your welcome Fernando and thanks for the compliment.
@optimisesocialmedia
@optimisesocialmedia 3 жыл бұрын
Excellent video, again, Daniel. Everything is really well explained, thank you. Is it possible to filter for distinct values in a column within a table or a gallery? I have a client / interactions app, where the client is in one table and is only in once, and interactions in another, but each client will have several interactions with a 'next contact date' field. I want a list of up and coming interactions showing each client only once and the latest interaction. Any suggestions? have you already done a video on this (I loved your Planning SharePoint List Relationships videos).
@DanielChristian19
@DanielChristian19 3 жыл бұрын
Thanks for the compliment. Yes, you can use Distinct in one table or gallery and based on the selection filter the other. Watch out for Distinct because based on your datasource and the formula you use, it will refer to only the first 500 or 2000 items / rows it sees.
@EpicBizHero
@EpicBizHero Жыл бұрын
Helpful explanations... Thank you Daniel!
@DanielChristian19
@DanielChristian19 Жыл бұрын
Your welcome Epic Biz Hero and thanks very much for the compliment.
@designmycity
@designmycity 2 жыл бұрын
Another grear video!!! Thank you.
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Glad you enjoyed it!
@kenrickfagan628
@kenrickfagan628 4 жыл бұрын
Brilliant this was very useful thanks Daniel, always wanted to know the differences.
@DanielChristian19
@DanielChristian19 4 жыл бұрын
Thanks for the compliment and your welcome!
@stefancochrane2723
@stefancochrane2723 3 жыл бұрын
Many thanks! If the table entries can be updated inline, and the table is in the middle of a long customized SPO list form, what would you suggest?
@DanielChristian19
@DanielChristian19 3 жыл бұрын
First, I would recommend making it a landscape form with a tablet or desktop screen ratio. Second, I would go with a gallery.
@stefancochrane2723
@stefancochrane2723 3 жыл бұрын
@@DanielChristian19 Many thanks! So, to summarize the steps: 1. In SPO, customize form. 2. Delete form from PowerApps. 3. Add all 100 field controls, plus the gallery, then, 4. Use Patch to update everything. It's really a shame a gallery can't fit into a datacard. Otherwise, many of these steps would not be needed. Oh, well.
@emanuelarcas1
@emanuelarcas1 2 жыл бұрын
Hi Daniel, Is it possible to make a field in datatable clickable and point to the same item navigating to a different screen?
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Not in a data table. You can with a gallery.
@kishorec1117
@kishorec1117 4 жыл бұрын
Thanks Daniel, cool one and a quick reckoner.. one case on conditional formating; can we color alternate rows of a gallery with unique colors? What I am trying this to use 2 colors for the entire table alternatively; there's a way to do it by using collection and indexing, but in more complicated query collections seem as hinderence; is there a way out using only gallery items to do so?
@DanielChristian19
@DanielChristian19 4 жыл бұрын
Hi Kishore, Here's what I have been doing. For the gallery's TemplateFill, add this formula = If(Mod(ThisItem.ID,2)=0,Green, Yellow). You can change the color to whatever you.
@kishorec1117
@kishorec1117 4 жыл бұрын
@@DanielChristian19 Yes, I tried that actually, but sometimes the two consecutive ids get evn or odd, then this doesn't solve the issue..
@artkarp
@artkarp 4 жыл бұрын
@@kishorec1117 Add a calculated row number when you populate the collection. Here is a detailed blog of how to do that: powerappsguide.com/blog/post/generating-row-numbers Then in the Daniel's formula above change it to ThisItem.RowNumber. The RowNumber doesn't need to be displayed. It's just for the color formatting calculation.
@MicrosoftPowerAppsTutorials
@MicrosoftPowerAppsTutorials 4 жыл бұрын
Thank you Daniel! This was quite insightful!
@DanielChristian19
@DanielChristian19 4 жыл бұрын
Your welcome!
@almirjunior6313
@almirjunior6313 4 жыл бұрын
Thanks Daniel for your video. Can you help me? How do I fill the entire line when hovering over the gallery? I'm a PowerApps beginner. =)
@DanielChristian19
@DanielChristian19 4 жыл бұрын
Your welcome. I need a a little more info to point you in the right direction. Do you want controls in the gallery item to be automatically populated? What are the control types? Are there an conditions? What is the back-end data source? I'd look into the hover property of the controls to start with.
@silverwhite11
@silverwhite11 3 жыл бұрын
Hi Sir, for the data table how to freeze the left most column? any work around? tks
@DanielChristian19
@DanielChristian19 3 жыл бұрын
That is a good question. My immediate response is to use either two datatables or one gallery and one data table. I'll have to do a few POCs to come up with a good solution. I'll add that to my to-do list.
@silverwhite11
@silverwhite11 3 жыл бұрын
@@DanielChristian19 Thank very much Sir, appreciate your help
@DevendraSingh-tx2pt
@DevendraSingh-tx2pt 3 жыл бұрын
Thanks Daniel for the fantastic video. Is it possible to add more than 100 column labels on gallery like excel spreadsheet.
@DanielChristian19
@DanielChristian19 3 жыл бұрын
Your welcome, Devendra. I haven't tried 100 columns of type labels. I haven't seen any limits mentioned in the Microsoft Doc. My question to you is why add that many columns together? Even when a widescreen you will have to scroll. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-data-table
@DevendraSingh-tx2pt
@DevendraSingh-tx2pt 3 жыл бұрын
Thanks for quick reply, my requirement is to show 100+ columns like excel but some columns should be editable which is not possible in data table.
@MacPaulos
@MacPaulos 4 жыл бұрын
Hey Daniel, super content again. Does data table allow for copy and paste like quick edit does in SP?
@DanielChristian19
@DanielChristian19 4 жыл бұрын
Thanks Paul. It does not have the same built-in feature like the SP list does, however, you can reproduce it using a Collect(CollectionName, ThisItem.IsSelected)
@suporterisit5242
@suporterisit5242 2 жыл бұрын
Muito bom, me ajudou muito. Aqui do Brasil.
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Your welcome. Glad to hear this video helped you.
@yashwantsuryawanshi9080
@yashwantsuryawanshi9080 4 жыл бұрын
Thank you Daniel ..
@DanielChristian19
@DanielChristian19 4 жыл бұрын
My pleasure!
@ericlam6696
@ericlam6696 3 жыл бұрын
Why must I choose between these two? One have really low functionality and another one you need to build it from scratch
@DanielChristian19
@DanielChristian19 3 жыл бұрын
Tsz, Those are the two options you have available out-of-box
@sundrapillay6668
@sundrapillay6668 4 жыл бұрын
Thanks Daniel
@DanielChristian19
@DanielChristian19 4 жыл бұрын
You are welcome Sundra.
@jdriele
@jdriele 4 жыл бұрын
Summary : never use tables ^^
@DanielChristian19
@DanielChristian19 4 жыл бұрын
Tables are great for a quick test to see what data is coming in, but for an app to be production ready, I use galleries.
Power Apps Gallery Pagination
20:00
Reza Dorrani
Рет қаралды 76 М.
Tightening the SharePoint List permissions for Power Apps
27:56
Daniel Christian
Рет қаралды 17 М.
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 158 МЛН
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
Mastering Delegation in Power Apps: A Comprehensive Guide
23:13
Shane Young
Рет қаралды 45 М.
PowerApps Patch Function
26:45
Shane Young
Рет қаралды 213 М.
Power Apps: Planning SharePoint Lists Relationships
41:17
Daniel Christian
Рет қаралды 114 М.
Running SQL in an Excel Worksheet
22:08
Bob Flisser
Рет қаралды 3,4 М.
Power Apps Editable Grid using Gallery & Modern Controls (2023)
23:49
Create Grid View in Power Apps with Custom Gallery Control
27:07
Dhruvin Shah
Рет қаралды 83 М.
Power Apps Gallery Design Ideas
18:24
Reza Dorrani
Рет қаралды 131 М.
PowerApps filter gallery by dropdown
28:06
Shane Young
Рет қаралды 280 М.