Microsoft 365 Community Column and view formatting tips, 8 Aug 2019

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Community Demo - Column and view formatting with Quick Edit experience

Description

This community call demo is taken from the SharePoint General SIG community call recording on 8th of August 2019. In this video, Chris Kent (DMI) demonstrates how column and view formatting works with quick editing and the experience with the list copying.

Presenter - Chris Kent (DMI) - @thechriskent

Full details on the community call from https://developer.microsoft.com/en-us/sharepoint/blogs/sharepoint-dev-community-pnp-general-sp-dev-sig-recording-7th-of-august-2019/

More details on the column formatting - https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

Open-source samples for column and view formatting - https://github.com/SharePoint/sp-dev-list-formatting

More details on the SharePoint dev community calls from http://aka.ms/sppnp.

A

B

You guys know me I'm Chris, all right there, you so I want to talk about list formatting a couple of different things with it. So we're not going to talk about the kind of internals of formatting. Today, I want to talk about a couple of changes to some of the list, experiences that affect formatting, to make it even more powerful. So, let's head over to our classic warhorses site.

B

Finally seen this a number of times trying to go over to like our agents list over here, no take a look, and we have our formats all kind of aligned on here. We've got a field, no customizer here and that's cool all that works great, but now in the targeted release, if we hit quick edit, we actually see those formats are applying directly within the quick edit, which is really really awesome. So you'll notice, even my my row, formatter with the real class, starts happening here.

B

So I click in here I can actually edit these things. When I hit to edit you can see the format is removed and I have my kind of classic editing experience here. So I can uncheck coupling as soon as I click off of that there is my updated changes here. Alright, so that's really really powerful. It's super awesome.

B

Now there are a couple of limitations with it right number, one being that few of customizers obviously aren't supported in the quick edit mode, but the formatting called formatting and row for matters that are row class are fully supported. If we look at a row formatter review format that is a full on row, formatter we've got the whole thing. Alright, we hit quick edit. We actually be relieved. This does not try and draw it all in that way and try and figure out where on earth I should click for various things. Ok, alright!

B

So that's one thing: that's really really cool, but there's also some other stuff you guys may or man I've seen, which is this idea here. If I go over to our hipster stuff site, Brian I hit this new and I go new list. I get this thing, we've seen forever boring, but good news.

B

We get site contents here, no idea why these experiences are different, but they are, but if I go to site constants and hit new I got a new list, we see I get this whole fancy create a list experience alright, if you guys haven't seen this. This is really awesome, and this is both in standard release and target release, except for this from Excel, and that's just targeted release right now, but excuse us from existing list and I can come in here, and we give this a second, your loads up.

B

My sites trying to come down here and I can actually grab from my warrior horses site. Any of these lists, alright, so say: I want to grab an hour classic things list here. I'll grab that and we call that hipster things cuz.

B

You know that sounds great, so create that, and you know it automatically moves everything over all my columns here and if I hit this new one randoms gonna do a thing right will so progress is 54% and sign to myself right and we'll just kind of leave it there, we'll uncheck that we'll hit save all right, you'll notice that all my formats came over no problem right, so we've got the the fancy gauge we showed off in the last call. Alright, we've got our face pile or our check boxes.

B

Everything came over with it, so all our formats hugely powerful. So now your formats work all across the board right. We even get all our views over here. So when I do things, like my alternating view, right I've only got one item but you'll notice, because I use the theme classes right. It matches the hipster stuff theme rather than the wari horses site theme here. So you can see now there's even more and more power to all this.

B

A couple of strange things to know right now is that you'll know titles here and completes over here when I copied it. The order changed, alright, didn't change, no change before that's great. You know what I said, but a couple of things here is I, so it's because I am I all items.

A

E there, it is you.

B

Notice there it's swapped in the default view a couple other strange things is, although if I click, this I got a flow I, don't have any flow setup for this list. Right I just created this list, but you'll notice. My flow button did come over if I click that I wouldn't rely on this, because it seems a little strange, I click that I can actually still launch that flow from my other site and if I run, it actually does work. With this list item.

A

B

I'm not quite sure, what's going on there, but it's interesting. The main point is that all my formats came over now. If I come back to my site, contents I want to try one more thing here: I go new and I create a new list. We go back to this experience from an existing list. Now this time, I'm gonna grab that agents list. We were looking at before. So it's my warrior horse. The site agents will also call it agents because hipsters also need agents.

B

That's here, I've got some additional, listen fields, that's because I've got a sight column. It's actually that reorder column has that field. Customizer SharePoint framework extensions associated with it and I grab that and of course we need to add a couple of items here. So let's add really don't Billy son. That sounds like a great name. Alright, we'll say that's the phone number and we'll just grab a picture right here. So we just have that.

B

Okay sounds great, so we save that I mean those all those formats are coming over, let's create just one more, so we can see things in action right. So you call this bold man. I should really think about these ahead of time. All right, that's good! Grab this guy and we're gonna save that so I've got these things here, so you get all our formats game over, but you'll notice. Something really interesting is that our field customizer also came over right. So this is our reorder field customizer.

B

All that came over that was not activated on this site that custom action, but because I had ten of deployment on that extension, it appears to have come over, which is awesome news, so really really cool stuff, as you can see, making your formats far more useful across your entire tenant, with some of these new experiences across your quick headed across everything else so perfect time to get far more involved in creating these things. So to summarize, we're forming a quick edit, your column formats, fully supported when you click on it.

B

You're going to go back to your standard, edit interface role. Formats are partially supported right, so class formats are gonna work. Great one thing to note that if you're you know, you've got a color across that entire bar. When you edit an item, it seems to be put in kind of a blue shade, regardless your theme, for whatever reason on there to kind of Mark that it's not a big deal, but just something to note or something you're doing wrong. That's just part of the quick edit experience and again only and targeted released for now.

B

So, if you log into your standard tenant and it's not, there don't cry it'll come soon and then the new illustration experience right. This is just from the site contents for now I. Imagine that will move also to the main page, but it's copying all your formats. The fields you customize, your extensions are coming along, but ListView command sets are not at least as far as I could see from my kind of limited testing on that.

B

But all this is available in standard release and finally check out the full documentation on called format and view formatting. Because again this is the perfect time to get involved in some of that. We've got a ton of samples available for you here at this link with the list. Formatting samples we've got nearly I think we have 60 plus samples at this point. Try to do everything I showed here today, plus a bunch more stuff, and if you want to read more about what happened with the quick headed experience check this out right here.

B

Alright, that's all for now. Thanks thank.

A

You Chris just a few additional kind of points on the on the column: formatting : formatting, an H by the way is the number one most viewed ship on developer and documentation page so every single month it's been like that for past six months. So clearly, Chris's demos are causing a lot of attention on the on this. One and people are eager really want to test the things, but please go to the kids, hump I think there's how many samples github has.

A

Which is really good now, one thing to notice on the under column. Formatting also is study partially works well. Column, formatting partially works in shape on 2019, but then sharepoint online always has the latest and greatest capabilities, because sharepoint 2019 is quite an old version already, even though it's currently 2019, but it was actually created for shipment online a while back and when one is getting the new and quick latest and greatest capabilities every single week. So it's always evolving once faster. But thank you Chris for this demo.