Microsoft 365 Community Column and view formatting tips, 21 Mar 2019

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Community demo - Conditionally Launch Flows using List Formatting

Description

This community call demo is taken from the SharePoint General Development Special Interest Group recording on 21st of March 2019 (streamed live from MVP Summit). In this video, Chris Kent (DMI) shows how to create a view formatting definition, which supports alternating row styles.

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-21st-of-march-2019/

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

A

B

Right so I'm chris camps, there's my foot tweets and all that long ago that those things are wound on, though so got a classic go or society. We've all got right things. I think a little heated things get a little crazy right, so they've got to prepare for battle to the further develop their production schedule, some special or your birth year. It's totally not made up on the spot. Okay, so who are here list right? So now we got this.

B

So we've done this to create a series of flows right, so we've got flows associated with our here. Let's make that a little bigger here, whoa there you go first, if I select I move below menu, we wait a while Google see some player. They are. We got things to manage. The save are here right, so you might write that as a simple flow.

C

That looks at say.

B

A stage of development right the branches off from there, but even then you want prompt users right because it's not obvious one white pick for the item. I've selected right. So let's make that a little easier. So the past we've done something.

A

Very added a nice flow button.

B

We're gonna do that really quickly double customize it further. So, but we do that I'm going to go you're going to add a format, only column and the way you do that app. They just simply pick a calculated column and you're gonna, say equals and formula you say: equals a stuck with a smart, some station markers a very complicated formula, but that's it. Okay. Now we have a column that can all that we used in the display.

B

So it's not going to get in the way when you're editing items or you create new items, and we get have four matches. Don't come back here in the column, settings format, this column and.

C

We over here on.

B

Our type in it or I'm gonna do wait up we'll just do this. There we go probably over here, so dark classic. Have samples brief, other students on a face, a linkage chat, rightz RSP dead list for me to get over. We've got 60 samples now tons of stuff to choose from. If we go to our column, samples we've have this one for a while got the generic start book. All you bet ability to grab. This is Jason right here and right paste it right in there. All this is doing from a very quick recap.

B

Is you create a button? Has a custom action here execute flow, and we do this. Jason's there's been escape to put inside Jason, because Jason can't handle subject. Okay, but maybe this here we put in here the IDE overflow we want Rock will go back just make a little bit of pretty with the buttons and text, so it grabs the backup reading that this nice, it's full-time button right here.

B

Right now, then, click on writing off that particular year. So that's cool I want to show based on the stage right here. Alright, so I only want to do the right one so I'm starting to do custom things right, so I can change. How that looks. I think some of that text conditionally based on another column, will do so, but they can look at that. The thumps that inference problems do this one over here right. So the easiest one is tax content right so set of explodes on.

B

We want to give the user a little gentle tap equals if reference our stage problem, losing the internal name right. So we say: if it's blank, then you know that's the deploy. Alright, if it's a little a little sub yep, it's like a switch stage is.

B

Spellers we got my notes: user development, precipice on its development.

B

To the boy Oh perfect, so we preview that text right. It's still the same flow still do the same thing, conditional logic, Reggie just prompting users. So they know why they're looking that right, but some of these they don't want to show the bottom ball Riley the gear has been destroyed, there's nothing more to do it like it's out of the loop right. So how do we get rid of that so this day they have conditionally these hiding and showing entire totals right.

B

So you can only apply logic with inside property, so you can't do it through properties or exclude properties. You can't do it to include or exclude elements, but you can't come here to display element right, so I'm just a second display and then we're saying another nice additional private equals if the stage right equals destroyed.

B

Although we want to say none for this all right.

B

So these are not.

C

Prompted so lost something when they should be.

B

B

More important to natural club.

B

This is just a spring, but soon you can do our same string, concatenation conditional with all those different items right, so we just wrap that up, and so we say the equals nil. Now we put all that on single quotes they're just so now. All we're doing is doing the exact same kind of logic, so you have state equals so long. So for now this one has several IV, so I'm, just gonna at this point, I'm gonna cheat. So if we go back so we got to start flow.

B

There's a brand new sample, both start flow conditionally, so CB designed it makes a click on it. The exact same thing and the key difference here is it just has all that same logic that conditional logic that we take a look at with the text was the icon down here with the single to display we're even doing with the classes, so two different colors and here's the key right.

B

So you guys can see this div, so we build it first, so building that escaped action parameter for building Maggie and we're just taking that same stage right to figure out which ID from which of our flows we're going to pop it out. Okay, now one thing to note is that one of the very few properties you can offset conditionally with an expression this action up here. So if you need to set action conditionally say, maybe you want to edit props right versus display the items be both click you're.

C

Gonna have to create that as.

B

A separate element all together and use the displacement choose which elements from our office. You cannot do that site, but you can.

A

C

B

What we're gonna do so we'll go back to our site.

B

It doesn't work, so don't be alarmed when you just preview. This button doesn't work refresh it right. So now we have development we get develop here right then we come down here. We get deployed, we get to boolean here. So the whole idea is I as an end user. I don't have to click here, go the flow menu and figure out what I'm actually doing at this stage do the pump users through the entire process but I'm using one column, to do that. We even use quite a few different things raises completed already.

B

It was a whole. You can make some pretty complicated logic and even then also handle that lots of your flow but prompt user for a.

C

Quick question: that's funny because there are tracks on the table on the front as well, and this is a good double speed, question on dying and the chap and we'll go back on the other questions, hopefully or.

A

C

Time for Q&A at.

A

C

There was a question related on: could I actually start to flow without your left panel so directly under on the clicking good button and I'll? Take the microphone call Jax just in case time, so.

A

This is integrated with how flows are excused your mind, so the battle is the way how we treat the experience of executing a flow against the resource and shared mine. So that's what we can't get if you wanna, do it a new tab? I? Don't really, then that command what you need to do, but you may not be using the in boot command to watch the flow. It's good command in CD format. You have to use some URL link.

B

So, just to recap all right so conditional.

C

Logical properties can.

B

Hold each additional reset the value, so that's something that comes up a lot of people are trying to say: I will want lose the colors. You know text color right when it makes sense to include it now. You have to always include the property, and then you conditionally set price. You can set it to inherit because of empty strings. We don't want to actually set that value right. Your else condition, so you always have to include or exclude properties or you can't you.

A

B

C

There's four elements: so it's not a thing.

B

You cannot additionally glue to hide element, so the team there's create an empty parent, did earlier container and then side, the children conditionally turn them on or off, which is okay.

C

In some conditions, if you're getting really complicated, that.

B

Gets to be a real nuisance, so hopefully we'll get that eventually, but for now that's how you handle that so, especially in the case of trying to do a different action. Wait and last thing here so go check out the docs. This is the repo against 60-plus samples, go cut and paste those things customize them submit.

C

B

New ones, and then we've got a ride-along each of those things so the first part where I show you how to format when we fall kind of through that, through that real, quick, so conditional problem, that's @ll format, molding, and if you want a little more about multiple, oh, where do you copy that idea? All that written up for you less than the most? That's it for me, thanks.