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.
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
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.
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 ruclips.net/video/8CBosd_PG74/видео.html
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!
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).
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.
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?
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 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.
@@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.
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)
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.
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.
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
Thankyou Daniel. This really has come as my rescue this morning ! Perfect timing
You're so welcome!
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.
Thanks for the input Hristo,
I couldn't have said that any better 👌
Great video explaining differences, thanks Daniel!
Glad it was helpful!
Another grear video!!! Thank you.
Glad you enjoyed it!
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
Your welcome Fernando and thanks for the compliment.
Helpful explanations... Thank you Daniel!
Your welcome Epic Biz Hero and thanks very much for the compliment.
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.
Glad it was helpful!
Hey Daniel - we can do Horizontal Scroll bar in Gallery as well using Scroll control, i did that in my POC
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 ruclips.net/video/8CBosd_PG74/видео.html
Thank you Daniel! This was quite insightful!
Your welcome!
Brilliant Video Daniel. Can you please help me how you have develop these pop screen?
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!
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).
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.
Brilliant this was very useful thanks Daniel, always wanted to know the differences.
Thanks for the compliment and your welcome!
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?
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.
@@DanielChristian19 Yes, I tried that actually, but sometimes the two consecutive ids get evn or odd, then this doesn't solve the issue..
@@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.
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?
First, I would recommend making it a landscape form with a tablet or desktop screen ratio. Second, I would go with a gallery.
@@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.
Hey Daniel, super content again. Does data table allow for copy and paste like quick edit does in SP?
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)
Hi Daniel, Is it possible to make a field in datatable clickable and point to the same item navigating to a different screen?
Not in a data table. You can with a gallery.
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. =)
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.
Hi Sir, for the data table how to freeze the left most column? any work around? tks
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.
@@DanielChristian19 Thank very much Sir, appreciate your help
Thanks Daniel for the fantastic video. Is it possible to add more than 100 column labels on gallery like excel spreadsheet.
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
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.
Thank you Daniel ..
My pleasure!
Muito bom, me ajudou muito. Aqui do Brasil.
Your welcome. Glad to hear this video helped you.
Thanks Daniel
You are welcome Sundra.
Why must I choose between these two? One have really low functionality and another one you need to build it from scratch
Tsz,
Those are the two options you have available out-of-box
Summary : never use tables ^^
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.