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