Microsoft 365 Community Development, 31 May 2018

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: General SharePoint Dev Special Interest Group (SIG) - May 31st 2018

Description

Recording of the SIG from May 31st. Latest SharePoint Development news from engineering. SharePoint Developer news recap from the SharePoint Conference 2018.

Microsoft Flow and PowerApps news and latest demos from SharePoint Conference 2018. Detailed agenda and covered topics are available via the Microsoft Tech Community (http://aka.ms/spdev-community).

Download recurrent invite from http://aka.ms/spdev-sig-call.

A

B

Welcome everybody: this is a SharePoint Patterson practices, general shape on development and sick and sick, basically and special interest group, and this is the by vacation trunk, where we talk about all the other stuff finish upon development except kind of client-side and JavaScript development. So there is a special interest group also for SharePoint framework, because there's so much to talk about those stuff as well.

B

So we're balancing out these, let's say special interest groups, so you can actually decide which of these you actually want to join and which you want to avoid now, and then we on top of that, we also have the monthly community call up it's more like summery around what has happened within the past month, around SharePoint development, quickly kind of repeating what I just said so general different developers seek is all about kind of a general shape on development topics to all of the other stuff in SharePoint framework.

B

Obviously we can touch upon framework here as well in the questions as we move along on the topics today. We kind of talk about, for example, the announcements in the SBC and yes, a lot of those SharePoint development. Announcements in SBC were around shape on framework, so I'm gonna quickly. If you go to a few slides, just to repeat the story, because also because our session are recording related on SharePoint framework from last week was only released one or two hours ago. So that was due technical reasons.

B

My traveling computer had some issues and basically I needed to well. We needed to wait until I got home to actually process the video and get it out into YouTube anyway, so this concentrates on the internet solutions, provisioning, automation, PMP, PowerShell and all of that stuff or the related technologies. So today, as an example, we'll cover checks we'll go through the demo from SPC related on we Microsoft flow and power apps, which is obviously closely involved in the SharePoint context as well.

B

But let's get back on that one in a second okay, MSSP PNP community, a great place to actually have a discussion on the on the SharePoint dev topics, so that is Mike's of tech community and you can always see see people from Microsoft on those discussions as well.

B

If you need to have enough- and they came as SPF ducks our documentation platform now, opportunities to participate in a community today, we'll have demos or I will talk like 15 to 20 minutes or 15 minutes, hopefully or faster than that, and then checks will do actually entrance a really long demo related on what he presented in SPC. Now, typically, we actually have caught up also community demos in this course, so that's absolutely one option as well.

B

So if you have a cool technology cool solution and it doesn't have to be open source solution, you are more than welcome to actually use this call to demonstrate those things as well. It's all about showing a pattern so in a model showing how you utilize SharePoint as to your developer platform, and you can easily bring me Bert, Patrick Patrick or somebody from the core team and we'll setup you up to 10 to 15 minutes to do that, you can absolutely contribute in a kitab kitab. A sharepoint is on sharepoint organization.

B

Where have we are actually gradually also extending some of the topics to PMP github organization, but we'll talk about that one more in the upcoming monthly community call, and the key point also is to provide feedback. So please please, please, please remember to meet yourself as well. That was a loud noise. Let's actually make sure that people are absolutely mirrored in here.

B

Yes, somebody was almost taking off that sacred comment, so let's actually meet the people. Here we go now. It looks pretty clean good now so provide us feedback. So if there's something which you don't like, something where, if something isn't working, there's a buck whatever, please use the social media channels use the github issue list, use whatever max of support channels to. Let us know that we're able to fix that.

B

Don't assume that somebody else has already reported your stuff, because we actually want to also know if multiple issues are running and running into the same issue or have two similar feedback that has a different meaning. Then it's one of feedback from a one person. Now, let's actually get moving on today's topic, so we'll talk about few announcements and updates on the sharepoint development side. I'm not actually that much new stuff.

B

But what I wanted to do is first, it's on the recap of SBCC to an 18 ship on Devon on Smith's and then go to the Chuck's accession. I will go through relatively fast without Adam, most distant and potentially on the next week on the shipment framework session. We can absolutely do live demos on certain topics which people have found interesting, but we want to make sure sure sure that chucks has sufficient amount of time to go through his content, and we did do some of the SharePoint conference demos already in the last week.

B

So if you want to check those out, the recording is already in the YouTube channel. So you can actually have a look on that, so typical announcements, documentation and guidance, AKM, SSP, dev Docs, so our documentation platform Emma stand in is gonna be shut down by end of June. It's currently current estimate and it's good to see that people are finding more and more to Doc's platform.

B

So on May we have roughly eight hundred and seventy thousand views on the platform which is really cool so by end of June or July, we'll probably hit the bottom. It 1 million views, which is really really cool, that people are actually finding this new location from here you can find latest guidance, tutorials links, our community call details and everything else so from a one single location. The second thing: what I wanted to remind everybody is the issue list.

B

Right now, for the past few weeks, we haven't been really found a time to do triage on the issues and I do apologize on that, and thank you for submitting those issues which we have been found now to be clear. We do to the three times in a week triage together with our engineers to figure out which of those issues are actually requiring our attention or our immediate attention.

B

But this is really around for you to give the option of record reporting an issue directly for SharePoint engineering, because these we need to know if there are issues which are plotting you to be a successful as well now, moving on on things quickly, recap on the shipment to an 18 conference announcement.

B

So what were the new things from SharePoint 2018 conference, because one of those sessions were not recorded, only the keynote is recorded and you can actually go and check it out from the I think that link or shared in the max of tech community on a SharePoint space or SharePoint crew. If somebody by the way has to link for the keynote recording, it's it's great if somebody could actually share that into in dialog windows because to keno.

B

This actually really really creates summary on what were the announcements in the SharePoint conference to an eighty now in general for developers, we kind of divided two developer content or developer announcement in four different kind of a sections number one of those sections is the all developers welcome and already right now we are in a nice situation where getting started on SharePoint following up on our tutorials, it's properly ten minutes to set up your developer machine and mainly because you run if you need to run a few installers and that's it, and after that you can actually start creating our first tutorial web part and it's less than ten minutes, actually that you will have your first wet part available, sure, there's a lot to learn, but there's a lot of guidance available as well.

B

So if you can find the time to follow up on the tutorials and guidance and documentation, you absolutely can learn how to do that now in future. As part of 1.5 release, we will add support for yarn and B and B M. These are package managers, so you're able to actually use alternative package managers on top of NPM if you prefer to do so.

B

If that's that's, not definitely needed, but some people actually want to use yarn or PMB P and B M package manager, so that is absolutely supported in SPF X starting from 1.5 1.5 will go out within a matter of days rather than weeks, but I can give you an exit date at this point. The month 1 / 5 will also have the yeoman extensibility. This one will mean that we're able to start creating our own PMP yeoman extension, which will then enable us to start providing stuff like angular elements, templates native little bit from it.

B

Yeoman templates more on that one within few weeks. So, but this is a great thing as well, for those who are interested on having the angular support in the SharePoint framework absolutely possible. Is that really the recommended way, not necessarily because you can use any framework? What you want? We Microsoft use react which is going to be pumped to react 16 and we provide reusable controls for react, angular absolutely great framework, and we cannot be supporting that.

B

We actually technically support angular or ready from SharePoint framework perspective, but angular isn't really suitable for a web part or multi-which at UIs, and that's that's been really the challenge until until release of angular elements or angular 6.0 and we'll talk about that. One with enough coming up coming and being more detailed, SharePoint 2019 will support also the modern experiences.

B

So you can absolutely build an extension in SharePoint 2019 or you can use the same extensions, footers and headers in the into on premises as well and not to avoid any confusion because I got this question in European Cooperation summit yesterday, Shep and 2019 will also support classic experiences, so you don't have to move to the modern. If you don't want to so you have that choice. You have that option to choose in SharePoint Online or in the on-premises as well, even actually in SharePoint Online.

B

You can even still today use classic onedrive experience if you would prefer to do so again, a big, simple governance. We released actually quite a lot of stuff on the on the covenant-- site within the past six months after the ignite. So there's a lot of cool stuff. The next big things will be turn on for deployment of extensions, so you're able from one centralized location, control widths of the extensions are available on which of the sites and also for new sites and also for old sides, and this is really really really great capability.

B

I quickly demonstrated that in the keynote recording, so you can actually check out recording from the of the keynote and spc to understand what it actually means. This content security policy available, which gives you the possibility of limiting which are two domains from where javascript is allowed to love, to be loaded, really cool capability capability as well, because it adds additional layer of security, isolated web parts quickly explaining that one as well.

B

If you don't trust somebody who has provided you an SP, PKG file or a bit part like AC, is giving you a SP pkg file, you're, not asus, really, shady guy, you never know what is actually adding on those web part packages. So you actually then are able to isolate that web part to be running in a knife frame and that's really cool so you're able to basically say that oh this webpart I'm not really sure, let's actually put it in the more isolated sandbox, and it's done it's gonna be executed over there.

B

That's really really cool capability, additional Web, API management, support and also protein sight designs. So we will add additional set of actions as we move along towards to ignite as well already today, there's quite a nice set of actions available in the site, designs and you're able to create them.

B

Yeah. Please don't quote me on the AC, it's a shady guy, oh he's, gonna call! This is no! Okay, anyway expose more UX surfaces, it's really important as well. So we do understand that in the modern experience is and the customization options are still quite limited. So we're adding additional case additional content placeholders there, and these are like the content, header and content footer. The difference between the existing at top and button placeholders is that the content footer is actually last thing in the content.

B

It is not floating on the top of the content, like the existing content for an existing button. Placeholder does so really important thing as well. Application beta is really cool thing. It's not precisely single page application, but it basically gives you more flexibility. As a designer or an application developer, you can create betas which do not support edit page capability for end-users and we'll clarify that more detailed as we move along with in this journey towards ignite SPF X target team step.

B

So you can actually write a one single code base as a web part, and you can use that in SharePoint and also as a teams, Microsoft themes, tab and that's mind-blowing, I think to demo again from the SPC keynote at the my section, where I showed two extensibility on SharePoint actually demonstrate that's pretty cool pretty nicely. You can take a one web part and actually use that as a max of things to tap. So again, it doesn't matter which of the tools is, it makes its sharepoint or is max of teams.

B

Your employees prefer to use, they can access the same application and you as a developer. You do not have to worry about space, take UI elements or frameworks, depending on which service are using in SharePoint or sorry in office 365, and that's a really cool thing, one single way of implementing stuff and it will work on all of the services in the future, really really cool stuff. And then the fourth thing on the on the web we are heading is to SharePoint spaces and to demo from the SP tsukino. It was pretty impressive.

B

Nobody there isn't that many people who actually have hololens and they can play around with the sharepoint spaces, but it's pretty cool idea of introducing virtual reality to the enterprises and, let's see how that one moves alone and how many people will get involved in that community as well. By ignite we already promised that will create some of the community demos for microsoft, spaces as well or SharePoint spaces as well. So we'll actually start this community sample. I've worked for that one as well and I.

B

Think the final thing from the sections is easily accessed data, so the Microsoft graph, scope, management and accessing all of the microscopes photoshop and framework will go to GA in production. Use. Dynamic data is a really important thing, as well. You're able to share data between your SharePoint framework components in a pages, so web part are communicating between web parts or with extensions, or they can actually access other data in debates as well.

B

It's like contextually accessing user profile information and all of that and then the final thing is socket IO and what it basically means that you're able to subscribe to events from a list using the socket IO framework directly using a craft as well, technically, not craft but craft like api's, so your web part can immediately react when somebody actually changes something in a list. You don't have to pull and double check. That is there any changes.

B

Analyst you rather actually get a notification when something is said, changes in the life or is or lists a really cool thing as well. The next big thing in SBC and I do apologize. We're rushing on this one, but I want to make sure that Jax has enough time to for the demos as well. The big thing in SBC big thing in the European cooperation summit, which we announced the still require some level of a polishing, is the BMPs target for modern experiences.

B

So we're really trying to help you and the community, our ISPs and system integrators and customers to understand what's possible with the modern experiences. So right now, if you go a kms s/pdif starter kit, that will redirect you to a kit hub for location where we have the starter kit available. It requires the additional level of documentation, additional testing additional things, but it is already a pretty cool start and many of the our developers have been able to get it up and running in their tenants.

B

Basic idea is following will: give you automatic provision of simple demo content in communication site plus two additional, actually other site collections which are associated to that communication site, which is automatically set to be a hop site. So k basically have this hierarchy of site collection automatically, and we give you also sample content, news and documents and presentations inside of those site collections as well.

B

We give you well, you can provision this to any tenant in matter of minutes, so it takes roughly five minutes to complete the provisioning, and after that you have up and running a cool portal which is using webparts custom, webparts, out-of-the-box, webparts and there's a few extensions there as well. The site designs the side scripts available automatically within your channel. It's also using our custom theme, which the default theme is orange and we've been getting this question quite a lot. Why orange the orange?

B

Is there because my favorite color is orange, so I do apologize if that's freaking out people, but you can easily 550 the the color from origins to something else. It's also a reminder on the times backing ship on 2010 beta1 timeframe. When suddenly, SharePoint blue was flipped to SharePoint Orange, and that was quite horrifying for those who actually saw that until we actually flipped it back to blue and it also. This is an open source community event, development model and it is MIT license, and what it means is that you can pull this down.

B

You can read back his site. You can use the code, you can use any of the SATs inside of that github repository in any way you want. You do not have to ask any permissions. You can just get up and running with this one and use them anywhere. You want anywhere, you want, which is really cool, and it also sets the automatic size, script and slide design. So if you go to the Cree, SharePoint home and start creating sites- and you actually can see news like designs available there- all of the source code is available.

B

All of the the web parts everything else how they're being built is available on github as well, so you're able to learn from this example. If you want, you can also just download this be PKG file and this the web parts individually in your talents. So you can use the web parts and functionalities individually indigence.

B

You do not have to provision the whole tree site collections or or the whole and demonstration as well and we'll add more documentation, more testing on this one, as we move along to make sure that anybody can get it up and running within 30 months as well. Now the next step for this one like set documentation, guidance, the following step, is add, more demo content, so more news material, no more other material on the slides as well, and the final thing is really interesting on the slide.

B

So pi ignite we're planning to release a website where you can go sign in as a tenant, administrator and you're able to then change. The custom theme file change some of the default images which you have on this package and then you're able to say provision, and that will actually then take two five to six minutes or whatever. But you will get everything ready for you to start demonstrating so you're able to actually use this also as a pre-sales tool as an example.

B

So, if you're a consultant- and you have a pre-sales meeting tomorrow- for let's say a random company which have a specific color- which they want to use some specific images- you can go and and kind of a pre create something for them to demonstrate, what's possible on the ship on platform and that's really really really cool cool good.

B

That was a really quick summary I do apologize and we will keep on repeating a lot of this stuff in the upcoming community cause we'll keep you up-to-date on what's happening when something is coming out that the latest new thing really under development is more and more and more on the SharePoint framework site, because that's where the main invest so actually done. But there's a lot of kind of other stuff which we cover in this particular special interest group called like the Mike's of flow and power, apps and site designs and end-to-end provisioning solutions.

B

But today let's actually concentrate now to the checks and chucks demo from the sharepoint conference and 2018, because that was really cool setup as well, and I and it's good to show what was actually announced to be available for you to take advantage so checks. You are still minute.

B

A

B

Yes, yes, you are excellent, so feel free to take over the presentation and I do apologize. That I wasn't really paying attention what's happening in the iron window. There were so many discussions over there, so I'll summarize and I'll go through the vinyl window as we move along.

A

So let me know if you can see my screen: it stills is loading here.

B

My skype is saying not responding, so it might be turn I'll be back in a few minutes not again.

A

Cool I think people can see my screen nice.

A

So let me quickly go through some of the things housekeeping so just to announce some of the stuff that we have been doing in power absent flow and what we announced at SPC. So basically, this is the session I presented with my group. Engineering manager, Cyrus well Sarah, so he's my guy. If I want to go, make things happen, you know I have to go and talk to him, so that was his first presentation public as a public speaker.

A

So it was very interesting for him to come to SPC and deliver at the start and he absolutely enjoyed it. So for folks that don't know I'm Chuck's I'm, one of the program managers in the SharePoint team, working with VESA I, initially started my work with SPF X and that part. So that's where I basically worked on revamping their platform along with VESA and others. You can reach me at Twitter or my blog.

A

So if you're not following me, make sure you follow so I'll be posting some awesome stuff with flow and power apps and SharePoint in general.

A

One thing I want to reiterate is that power, apps and flow are the tools you need for your business users and for building business process solutions in SharePoint. It's been roughly I think two years now, since we said hey guys, if you can move from InfoPath, you know make a plan for it. If you can move from sharepoint designer workflows, you know make a plan for it, but I think this is the year.

A

I feel very confident that we have a strong set of tools with strong set of capabilities and features that basically map back to those two tools. So you can move your customers out from those to these new tools and the new. We call it modern way of working with the business processes and since these are all not part of SharePoint but kind of like having their independent roadmap with Azure we're getting a lot of traction in how things get introduced and how things get managed.

A

So we see a lot of innovation happening in both power, apps and flow platform. That's a good thing because those when they happen they automatically get to SharePoint very easily so Microsoft flow for folks. That don't know is the new will flow engine platform. That's built on at your logic, apps and basically it's a designer, so businesses can go build flow. On top of it. We have around 200 services, 200 plus services, I think last week they announced some connectors for the ServiceNow platform as well.

A

So it's a growing platform people is, we can publish their templates Microsoft and have it available to users in Microsoft flow website, so you can also build custom connectors for your enterprise and deploy it in your enterprise and use that in the flow with actions. So there's a lot of opportunities here, especially for developers to go and make that migration and other things with respect to SharePoint designer work with Microsoft flow.

A

It also has approvals, which is another big thing which you usually is the you know one that using SharePoint designer today we have launch panel. You can run the flow as a user, which means that you can have anybody who's using the list or a library run. A flow so, for example, copy file or archive file, and things like that, it's integrated with modern UI, only classic you can use the list, but there's no UI integration.

A

There are some new features like request, sign-off, which is basically available out of the box for users to do some lightweight approval process over a document or a list item we also introduced new flow actions. Item deleted trigger is now available, so if something gets deleted, it gives you the ID and the name or the title, depending on document or the list item from the list, and then we also introduced a new action called SharePoint HTTP action. This is a developer action, so you need to know the rest API and execute that with SharePoint.

A

This opens up too many possibilities. We have so many API surfaces in SharePoint. We just can't build an action for every API surface, so we decided to release a HTTP action to unblock several enterprises that need those capabilities, so they don't have to wait for us to build those actions. Rather they can go today and use the well-known brisk api's to go. Do those actions in SharePoint from Flo same with so upcoming Flo integration? We have lots of stuff I, think you saw on that keynote demo. We showed the page approvals for communication sites.

A

So now you can actually edit a page and submit for approval, we're going to be coming up with new suggested flow, starting with reminder flows. So if you do have date columns, we can remind you, remind users to create reminder, flows based off of that they've column, and you can imagine that expanding up to various levels like if you have a person column.

A

Maybe you want to remain something to that person when something changes on that item, so those kind of suggested flows is something we are building and finally we're going to be having approvals for joining hub sites. So this is one of the early feedback we received when we did. Some pilot testing and dock coding with customers is that they want an approval process or a business process to be specific right when you join a heart, so we are working on that and that's something also will be released soon.

A

So these are some of the upcoming flow integrations and you know: there's lots more. I can talk right here now, but I think at ignite. We will see more stuff coming in custom forms with power apps. So that is the answer for kind of the forum views. So if you want to have a new view or new item view list item view and edit item view, you can do that with custom forms of power apps now for lists and libraries, so it's integrated again into modern SharePoint experience not available in the classic.

A

It gives you the full surface to go customize and flexible enough to add several other data sources. If you do want to pull them in. So that's the power of custom forms. We also released power apps where power in targeted release. So if you do have an app those in power apps, you can now embed that directly in a SharePoint page using the power apps web part.

A

It works in mobile in your SharePoint mobile as well, and you know now you get the opportunity to bring in related data together and have it in your SharePoint site, regardless of whether that data is coming from SharePoint or it's coming from other different data sources in your organization.

A

So with that I'm gonna go into my demo that we did so. We basically wanted to give a simple solution that will show certain capabilities of these different tools that we just were talking about. So we called it now code and there was a lot of questions in Twitter like why? Is it not good? It's not good. It's low code that the reason being you know in SharePoint a code requires deployment and kind of some sort of approval.

A

If you look at all our SPF X packages, you just can't deploy it and just use it without a tenant, admin approval or a site collection has been approved.

A

These things, what you're seeing here is is basically, if you are a site owner and a list owner, you can go, build custom forms and make it available for your business users and that's the power of these tools. It is there for you to go, build the things you want and that's why we somehow the terminology came down to no code solutions. He didn't have to acquire it's there for you to go work on it.

A

So we'll see a simple interview, feedback solution, I'm going to show you the demo and I think we'll go through the flow and how we did build this. So.

A

Let me open up so yeah. Somebody needs to be muted, I, don't know who.

A

Just making sure I think better. If you can look into the questions, I think I would be able to. After the call we can address them separate.

B

Yeah I'm still processing the questions during my or Miriam paper. Okay,.

A

Okay, here is our control Human Resources website. Here we have three lists. We have candidates, interview, prep and interview feedback. The candidates list is a simple list within about the candidate, the email and their CV attached to it don't see me and then I have my interview prep list. So this is a list where, basically, the scenario is that the HR resource comes and creates a new interview, prep item, so the interview is scheduled with three interviewers and interview.

A

Feedback is a list where you will see all of the interview line items coming up here, so people enjoy the interviewers can go and give feedback on their specific candidate. So let's look at the flow. So initially you know, I'm logged in as Melissa Melissa comes in and creates an interview, prep item, and now you can see here instead of the default SharePoint list form, we open up highly customized form here, which is coming from power apps and you can see some of the things I have here is I.

A

Have the candidate, which is a lookup field to the candidate list? I have some title and sort of some subtitles to help users understand. What's going on, I have three interviewers: first interviewer, first interviewer start time, second interviewer and their start time and then finally, the approver approver start time and you can see some of the values have been set to default. So this one is today's date and daven a.m.

A

and this one is today's date plus an hour so that you can accommodate you know all the interviews should be after an hour by default, for example, and here I can basically search for the candidates, and you can see that as soon as I type I got the candidates from my lookup list. I can say like that and notice how the first interviewer got enabled as soon as I selected a candidate. So there's something conditional stuff that you can do in power, apps and now.

A

I can here select the first interviewer so I'm going to select Jeremy master as a people. Picker everything is coming from power, apps and then the second interviewer I can say that home and then final interviewer, you know, say Melissa.

A

So once I click Save, that's going to create an item here and basically, what is going to happen behind the scenes is: there's a flow getting kicked and that will create three items for the three interviewers that we created here: I'm just going to click Edit, so three interviewers, Jeremy, mass murder, Dan home and Melissa a Taurus. So we're going to have three feedback items created in this list once the flow gets executed.

A

There is a first item.

A

And there's a reason: I think it's just taking time, because there's a lot of steps that I have in the flow.

A

Still working and here's the flow that's actually running right now you can see that flow is running in him from a since a minute there you go so he got three items with the title for interview for that candidate and then we have the interviewers and not just that. If I switch to Dan home or Jeremy master.

A

Here's Jeremy master and go to his outlook. I.

A

Actually got a Skype meeting invite Outlook, even with the Skype meeting and the Skype details for the interview for that candidate and I also have the information about the candidate. I can even download the resume of that candidate and I also have a direct interview, feedback link. So when I click this it directly, it takes me to that particular item for that feedback. Now.

A

This is something interesting that you seen here will will come to this really soon, but the key idea is things got set up in the list in the feedback list and it created event in the Outlook, with all the details that I want to format with a sky plane and the candidate details and interview feedback link, so they can directly go click and you feedback now, one of the other things that happened along this with all these steps is that the flow also made sure that these three items are only accessible to these three interviewers, so it basically assigned unique permissions, choose these three interviewers.

A

So when somebody comes to this feedback Liz, you know you don't want to see them all the interviews that is happening along the side. They just want to be focused on the things they have access to, or they can give feedback to.

A

In this case, I only have one candidate right now, but that home in Jeremy, who are kind of the interviewers and melissa postal, an HR owner jet dan and Jeremy, would only see their specific items in this list, while Melissa who's, the owner can see every item on this list, so it basically broke all the permissions and unique permissions and set only to those interviewers that we need them to. So that's the flow, and now what happens is basically you're now set to give feedback and and sort of rest of the stuff.

A

Let me go and show you the flow for this step and then you'll see what happens and how people give interviews you provide feedback. So here is the flow that just ran when a new item was added to the interview prep list and what I'm doing here is. Basically, there is a trigger and after the trigger I'm, getting the details of the item. So here I get the details of the interview, prep item and then I get the candidate. Now here's a cool tip, lookup fields are always paying to work with right.

A

Sometimes you need to write, select and expand queries if you are doing c-sharp and JavaScript code, and if this doesn't give you everything out of the box. So there's a lot of work needs to be done, but here's a simple neat trick that happened that you can do with the flow. So in my interview, prep list when I created the list along with and I when I set up that column, the candidate column, what I did was I said: hey, add email and ID as well to this list so that they are available.

A

In my view now flow takes advantage of this and since the values, when you get the item for the interview crap, if this actually loads right now and will give you the all of the values in the view, which means you will get the candidate email as the candidate title as a default along with candidate email and candidate ID. Now you got the ID so with that ID you can now easily query the candidates list to get the candidate based off of that ID. You get from the gate.

A

Item action, so it's a pretty cool trick, I think so that way, you can basically easily query the lookup values from SharePoint list waiting for this to come up.

A

For some reason this is really slow anyway. So that's how I kind of get the candidate value as whatever the value associated with with this list and then I use the gate. Attachments action, which is an action in shape on connector, should get the attachment of the particular list item in this case the candidate and then, let's talk about the initialization variable later a little bit. The first step in in the next is breaking the permissions and assigning unique permissions to those items that I created right so now to do that. I want three.

A

The way that you do in SharePoint is you use the add role assignment API now, let me go to. Let me skip this user principle stuff, because I think once I show you what happens behind the built-in. The bottom you'll know what why the top? We have the user principle, so I created scopes for first interviewer, second interviewer and the approver interviewer, so the first interviewer you create the first interview item. This means you're, creating the feedback item that we saw.

A

So now you have the feedback item creator and then, basically now we go and use the SharePoint West HTTP action to use the SharePoint api's REST API to break the item. Permissions on that list item that work that we created here.

A

So I'm just going to load the rest for some reason: it's taking time there you go. So this is a HTTP action, so I'm executing against the site, giving a post and now I have the well-known API that I think most of our SharePoint developers would be very familiar with get the list yet item and then break role, inheritance and then false is basically don't bring up all the permissions down to this list item from the list, so this breaks the inheritance. So immediately, once you create this, the item is gone because it's it's.

A

The permissions are broken now and then I basically create the first interview meeting using the Skype action. So there is a Skype app action available that we can use and you can create all the details and do all the stuff using the dynamic values from previous actions. And then we have the create first interview item, which is a create in to create outlook event, action that creates the values based off of all the dynamic content. We have and then builds the email in HTML. So that's pretty much it. What happens? I do that.

A

For second interview and approve an interview and finally I do set item permission, so we create those items. I need to go and set the permissions on each of those list. Item to those unique permissions for those three users, that's reinterviews, so I do an apply to each on the user principles and that's where the top variables come in so for each person, I need the SharePoint user principle, and this is how SharePoint has been working through the old days right now.

A

There is like a share dialog and all those new api's we're working with that team to make the simpler and we can build these things for you, but right now. This is a reason why we release the HTTP connector HTTP action, so you can go. Do these things. We got lots of folks asking for this specific scenario, and this just gave us the freedom to go. Do the things that we want to do.

A

That's why it's a bit complex right now, but if you know the API is it's pretty straightforward, so I get the user principles and for each of the user principle, I need to go set. The permissions for the three items so I capture those user principles in a variable now now everything what I'm using here, as you can see, the header is JSON light now.

A

Json light is something where it focuses to give you only the JSON result back and not all of the metadata that usually the extra baggage that comes up with SharePoint when you call a REST API. So when I get this, the value is really really simple, just a JSON value, and that basically looks like this, the body of that action and then ID. That's it and I'll show you what it is from the from the flow that executed.

A

You can see this in the output, but basically, if you query the body and then say, I need the ID of that. You will get the principle ID, and this is exactly similar to how you would go. Write a Java, Script SPF expressed API and try to pass the result resulting JSON output. Again, if you use the ODA or the JSON light with no metadata, this will work. If you don't use that, then you have to traverse through underscore underscore metadata and then be and, and some extra stuff says really is not required.

A

It's just really hard. So now, I have all the user principles in the variable. So all I do here is I initialize, an array using the variable act, initialize variable action, inflow and I create a user principles array and every time I get the user principle back.

A

I append that user principle to that array object and then at the bottom, I basically go through loop, those user principles and now I use the SharePoint API to set item level permissions, which is basically your item in list items, slash role, assignment, slash, add role assignment principle: ID is whatever the current item I have in the array, which is going through the loop and roll def ID. This is a constant that map's back to contribution contributor rights.

A

Now this is where this is again, the same SharePoint stuff for the past I, don't know 15 years, that's using those api's, but they're always KPIs gladly they're, not SMX api's, so it uses the same old SharePoint stuff. So that's why this is not intended for business users. This is something for us who are power.

A

Users and no rest api is to go and basically do the things we want to do and share here again I'm using no metadata just to make sure that if there are any results out back back from this action may be errors or whatever I get the light JSON light, rather than all the metadata included in it. So I do that for the second post in feedback item I created and the third feedback item and created, so it's pretty straightforward now and it does for three times for all three principles on that three list items.

A

So that's the flow that got executed, basic created all of those items and sent an interview even request, along with all the details with the candidate and the Skype interview event. So now what happens is that people can go and give feedback, but before that, if you look at this list, this is very boring like this is something what we have been doing forever right.

A

We do have column four matters, so if you, if you you, can use the column formatter and make this a little bit prettier, but it still doesn't give you the surface to go, modify the view. So that's where Silas actually was this fed project as hackathon project? Actually he said: hey I can do this in row. Why can I do I can do this in column? What can I apply the same rule for the row, so it becomes something where I can now customize the view completely. So here's a simple thing that we created.

A

So we made all items view, and this is the view now you get. If you go to that view, that uses a row formatter row format is not available, yet we're still working on it. It's pretty early stage, but I think in the next few months we should have it available for you to go use it. It uses the same syntax as the column. Formatter. The things that you go build may be a little bit different, but everything else is exactly the same. You can see what we did here is.

A

Basically, we said oh I'm gonna, give it's not beautiful and that's another thing. We want to make it easily fabric and all those stuff. Now you can see I have the title all of the details as an interview in progress, interview, feedback contact, interviewers contact candidates, some sort of something that applies to my business process and then I have the interview feedback. Here again, if I switch my view to all items you can see, I have a very good view for focusing on that.

A

Candidate and I also have your feedback button that comes up to that particular user. That logged in so they can cap both the things they want to do. So let me go to Jeremy and.

A

A

Okay, so now this is cool. So now I can go to my interview, feedback list, so I'm logged in as Jeremy here and you can see now. I have the give feedback button, but I can't basically that home and other side of see those here melissa is logged in so I see Melissa giving feedback. So I'm gonna give my feedback I'm going to say no higher, not good. Let's put just one thing and you can see now it basically put red instead of green and I got an email as well.

A

That said, hey basically Jeremy gave feedback and we here's a decision, and here is the message.

A

Okay, you get the idea here this so then Dan, so let me go to Dan. Do the same thing.

A

I'm going to say higher.

A

A

Why am I seeing Jeremy Messner, okay, something happened.

B

You are the you are the PM of this functionality. You should know just kidding just I.

A

Do know, but it's a secret.

B

A

Damn now gives a no higher decision, so there it is, and then let's come back to Melissa, so I got an email again.

A

And Melissa is the approver, so you can see final, approver and and stuff like that. That is very specific to let me just refresh this page. Just there you go and I'm going to say, I'm the final approval, I, don't care what others have done, whether they decided to hire or not but I'm, going to yeah. There's some bug here that I think that's getting fixed, which basically brings up the old values.

A

There you go so I'm, gonna, say, hire hired and now Melissa has approved. So if I go to the emails, you can see, I get two emails interview, feedback and candidate Elise is higher. So that's how it closes the loop to finally say the candidate is hired and one thing that also happens up. If you go to the interview prep list it also now, if you switch the view, it would have updated that to say from interview in progress to higher and we have a green.

A

So the row for matters are I'm not going to go into deep, because we don't have time for this today, but basically uses the same construct that the Rufe, the column format is used. But this time it's working against the view. So that's how it is applied to the view and everything else. For example, if you are doing setting a background color, you can see here, I have the operator.

A

If, if the condition is equal to higher, then I set a different color and if the operand is no higher, if the decision is no higher, then it's this color, if not no color right and this dollar decision is the way you access the column that is available in your view. And similarly, if you look at the things that we did for the final approver in the text, we said: okay in the children, you're kind of like building your divs.

A

If you get the title and after the title, if this person is approver through because the Easter floor is a boolean value and we are just checking is if approval is true, then up in this final approval string and it goes on to building again. This is something we are still working on. Some things maybe simplify. If some things may be just the way, we will have to tell how people build it initially, this JSON. This is a quickest way.

A

We can get out the door, but I think our option is to make this much more accessible to business users and have you experiment in a new experiment way of building these things, but right now this is what we are trying out to see. What are all the different things we can do and then later bring this into the product and the give feedback button is also interesting because I think that's the.

A

Where is the give me there? It is the give feedback button which you saw only comes up for the particular item. So this is what we do. The display property of the new feedback has checked to see. If the mean which is the column is the interviewer dot email is both are equal, then, basically, you kind of get the give feedback button. If not, you don't get the feed but and that's how they figure.

A

Feedback comes up to very specific set of people, so that's the row formatter and if I quickly go into the dough, here's Melissa the flow that got kicked off for every time when somebody did some changes, so that list is interview, feedback updated. Now, here's a cool trick every time there so there's one trigger Calvin and I can is created or modified. So this is the trigger you have to use for both item creation and modified.

A

If you want to get the modified version, there is a trigger call when an item is created that won't give you the modified triggers, but this will give you the alerts for the modified as well. So once it's modified get into you item and the way that I am checking this right now, whether this is a modified or a new item, there is basically I'm checking the Creator. Date/Time is not equal to modified date time. If they are not equal, then I know this item has been modified. So this is a simple trick.

A

I know we can make this simpler right now. This is what we have got.

A

There's a whole history around this thing, but once this is updated right, I sent an email, Joe update the interviewers on hey, someone gave a feedback on the candidate and here's a hiring decision value and then I also checked if this is coming from an approver, because if Melissa approves I have to go and do certain things so I'm checking if the email is equal to the approval, email right, if the person email modified by, if it is then is the value higher.

A

If the candidate is hired, if someone is an approver and if they changed the decision to hire, then I need to go. Do a bunch of things. I go and need to set the interview, prep item to hire because I need to close the loop there and then I have to send an email so that people know that the candidate is higher. So that's this flow, so it's pretty neat like it breaks down to different set of conditions, and now, basically you know the three-step flow that you have.

A

It's basically three steps, but if you break down it's actually going into different levels based on the conditions you build again here, we didn't use any of the HTTP action here. We just used all of the default flow actions available to us with some conditions so that we can check and ensure that people are able to do the right things in the flow. So this was the demo that I did it as PC 18, and one thing I did not show is custom. Fonts I think we have very little time. Yeah.

B

We have quite a few questions on the pipeline as well, but it away yeah, but.

A

I'm going to quickly show because I think this is something very important. You can do a lot of things in power apps. You can build some awesome, stuff, complicated, stuff trust me it's difficult to build those things in power, apps right now, so the the thing that you should do our concentrate with your customers is: what are the simple things we can change, especially with custom forms if you're going and building an app, a standalone app that connects you SharePoint multiple data sources. You've got a lot of options.

A

You can make some awesome UI there, but custom phones are meant to be kept. It's simple, so you can build the things you need to build and give the things very quickly. So users find it very relevant. You enter the data right so here you can see that I split my screen to basically three screens instead of one screen so I have a new edit and view screen in the new screen. I have basically the items that we saw on the demo.

A

You can see everything is enabled disabled by default, so power apps uses this concept called data card for every control that appears in the form. So this is the viewer control you have the form and in the display mode, is where I actually go and write the condition if the candidate value.

A

So if my candidate data card value is blank, then I make it disabled else, I change them, what you edit, so that's how it switches back and forth between enable and disable most the same thing for the first interview item, the second interview item: if you look at it, I would have just switched that back to first interviewer value does lecture so pretty stable one and then for the default values for the date you can see. I have default, and basically it says text. However, now and then localized to you know, Ian us.

A

So that way it actually puts the default value and for the next one, it's basically plus one. So these are simple things you can. You can put some colors, add some titles and whatnot and and give them some simple forms and to get started with some are complex. I do get it but I think to get started with power apps. This is a nice little way to focus on the simplicity, rather than the complexity that you want, and you can have some complexity here with respect to how the controller needs to be displayed.

A

Especially if you split this into three views, I will tweet a link on how to separate these three views. There's a blog post from the power app scheme. I can I'll treat that as soon as this call is done so that you get an idea of how to do that from a single one form to the three forms. So that's my demo, Chuck's.

B

A few minutes, let's actually culture, a few questions. Okay, one comment by the way on the government or cloud: there was quite a lot of questions there. When will this be in government alone, based on information from Tom? Thank you, Tom, for sharing mics of conduct set by end of this end of this calendar year. So it's not available yet, but to be honest, mere checks, and not the people who would know that now Chuck's following is for you from Brian Russell I. To start this started pretty early on the discussion.

B

Will there be any way to export ship when the integrated power apps- and this was quite quick question which was on the iron window? Quite a lot yeah.

A

So we are working on that. We are trying to basically give you a way to export a list, and if that list has a flow attached to it or a custom form attached to it, we will export that as well and actually, when you import back the list when you created this from the package, will create everything. This is something we showed in the keynote as well. If you have seen the keynote, there was like a new list, wizard and said include flows and all those stuff.

A

It's a work item that is crossing the power, apps flow and pretty much the business apps group and SharePoint so that we have a consistent package format for all of these tools. Cool.

B

Cool yeah, an egg hello, still on a corkage, a class, the exactly the same question. The following question was from binoy: can we create a flow that is common for many sites flow.

A

Common for many sites right now, no a flow needs mean you can. So there are two ways to build. This I'd say a different way to build this. The default SharePoint triggers are basically only available to a list or a library. They can't be associated with multiple lists or multiple library. You have to run. Do you ever duplicate the flow and basically change the trigger to point through the list or the library that you want, and that will end up creating if you 100 less than hundred flows.

A

The other way the complex way to create this, if that is a real business need, is to create a trigger that uses say, create a flow that uses a recurrence trigger that runs every minute or every hour and then pulls SharePoint for new items. You can use the HTTP rest action for that and then get back the items to see if there are anything new, that's the kind of way how flow has associated with a list. We don't have a flow associated with the site.

B

Yeah cute just coming back on a Rahul s, asking can only power a form, P exports and I think right now it would be the list X portion exporting at least just a step. One right, yeah.

A

Right now we don't have power. Apps doesn't have the capability to export a form, I think they're. Working on that we have got the request, because you can export an app. You can say we bring it back and change everything that you want. This is not something I read in form, because form is not an app form is a special thing that built for SharePoint and other constructs and power apps. So that's why they don't have that yet, but they are working on it. Yeah.

B

And paranoid is commenting also, there should be a way to register an existing flower logica in price solutions and the aperture once the time we do it, and that would.

A

Be the yeah there will be the case for all the package, export and import and exactly doing yeah.

B

Now Steven still had a question: does the custom power a form come with a list if it's saved as a template with data answer is no, it did that's not the case if you're using the classic saves list, as the data capability safely save list as an ST pay file, the answer is absolutely no right.

A

But the same list, even though it's available in online, you can't import that and create list template and create lists based off of that. So yes, yes,.

B

True DN was asking more administrative question: any plans for that flow and power-ups for the service health, page and I. Think somebody said that it's potentially there already, if I miss the discussion just to share that, and then there was a comment from you in yours, our power, our platform supposed to be working, sort of power. Us web part tried that, but with no luck.

A

Yeah, so custom forms have special things like you know it it from new form and stuff like that. That needs to work, so the web part does not handle it. Web part is basically for the apps. We are building a list forms web part that will specifically handle the user scenarios for the custom forms. I mean you can try it, but it's very difficult. It's hacky, because you need to know what form you need to load and what list and all those stuff so yeah.

B

Okay, that was all what I collected. I'm I was looking into our messages as well. I think that's it for now and anyway, we have four minutes on the on top of the yeah and I.

A

Do want to add one thing if so, I'm gonna be doing this little early, showing stuff in power apps and talk about flow. If you guys have some demos that you want to share with us, let us know we'll have that in the community call and basically see what solutions you guys have built using flow and power ups. Yes,.

B

Absolutely so, let's please typically. Obviously we want power, apps and flow to be part of these course as well. But it's this is not gonna be transplant just for flow and power apps. No, it's just making sure.

A

B

Clear as well, but yeah like once a month or twice a month, why not? Actually this is really really close part of sharepoint and then we'll talk about the site, designs and themes and all of the other topics in this call as well and now a Cal you offer it already me Mimi, please send me or checks an email checks. Email might be slightly or sorry. Please send me an email or Burt Johnson, an email and we'll catch.

B

Your skirts scheduled based on the time what you need or private message in Microsoft tech, community or in a Twitter or whatever. So we can actually have that discussion and then there, but next general SharePoint developers, special interest. We've call is on June 14th and the next SharePoint framework special interest group call is on a one week from now, a seventh of June, but that's it from this one, the URL, where you can find all of the documentation. Information community call details, options open source projects.

B

Everything else is take a MSSP PMPs or our community channels for sharepoint development. But thank you everybody for watching. Thank you for your comments. Thank you for your feedback, Thank You Jax for great demos, brilliant demos want, and once again and I'd, like checks that we will absolutely get on doing this flow and power ups content in here as well. Thank you. Everybody! Please, keep the feedback coming bye-bye.