Microsoft 365 Community Development, 17 May 2018

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: General SharePoint Dev (CSOM, Provisioning, PnP) SIG - May 17th 2018

Description

Recording of the SIG from May 17th. Latest SharePoint Development news from engineering and concentration on the Microsoft Flow and PowerApps in the context of SharePoint. 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

Everybody, this is chef, Anne, Patterson practices webcast, and this is not a webcast. Well, how did I do that again, so this is the general chef and development special interest group. This is the bi-weekly call now where we talk about SharePoint development in the kind of an largest scale. So in these pie weekly calls, we will typically moving into the direction where we take one topic like a site designs or a column formatting, and then we concentrate on covering that throughout today.

B

We'll have checks talking about the flow and power apps, but I'll come back on that one in a second, so just quickly introducing what to SharePoint patterns and practices and all about the chip on Patterson practice is basically equals shape on developer community. So this is community which was started many many years ago, which has been evolving to be the SharePoint developer messaging for official messaging from the Microsoft.

B

So we are the people who also are responsible of all of the documentation and all of the other messaging and marketing efforts in in the Microsoft site, so I personally I'm working as a senior program manager from Microsoft in the engineering team, which is responsible of the SharePoint framework and api's and all of that.

B

But my role is also to explain how we use those things which is pretty important, so the general dev, a special interest group gold, has a biweekly schedule, and in here this is an open discussion around the chino roshi open development topics. We do have another one which is called the special interest group call for SharePoint framework. So in there we talk about more specifics on a SharePoint framework in here.

B

This is kind of a more open topic like in this case, we'll talk about the flow and power apps, now opportunities to participate with the community. So this is just keeping this one in the slides as well, and we absolutely welcome people to demo their solutions or samples or technical patterns in this call just reach out to me Burt or Patrick, or somebody in the team or any of the MVPs anything and both gates, you're scheduled on this call.

B

This is actually by the way, a create opportunity, if you are an existing MVP or your wanna, be an MVP in the future. If you want to have visibility and those let's say in quotes the MVP it's collected to yourself, this is a great way to do that. So you'll get a free, 15, 15, minutes, demos it to do component whatever you want small. My reminder, people please please, please remember to meet yourself.

B

So there's no background noise, except what's coming behind a fee now you can always contribute on key top as well so issues for requests all that stuff and then in general, provide feedback used to the technical community and at the tooling, to tell us what's wrong. So don't just let's say: don't have a discussion with your colleagues and complain that Microsoft isn't listening and they don't know what to do. Tell us how we can help you that's a really important thing as well, so we know those things in many of the things.

B

Yes, we know that there's always a problems. For example, enough stress is defined, that's a massive massive platform, so there's always bugs here and there or things which could be better and we are working on many of them. But getting your feedback using the user voice and alternative channels is super important for us as well now moving on our thing so today, I have few slides and general announcements and let's have a look on the on the roadmap up to a road map update on the stuff which was announced in built, and we can.

B

We can't really talk about. What's gonna happen next week in Las Vegas, so we can announce additional stuff there as well, but then we'll kind of leave the stage for checks to go through Microsoft flow and power apps in the context of SharePoint. So this is the latest changes from that sign and these are actually really interesting as well, so because they give you a humongous amount of actually, let's say tools and opportunities without you being forced to write the whole thing by yourself, but I'll, let Jax on explaining what that means.

B

Actually, in practice now moving on I think so documentation guidance promised to keep this slide in the in the presentation. Essence dawn of the whatever future. So s, PDF, Doc's, a game, a game, SSP, dev, Docs or dogster.com. Slash upon a developer is where you can find all of our official documentation. You can contribute, you can have discussions in the communities. Please let us know something is wrong.

B

You can also submit a pull request for us towards us, so we'll get it your type of fixes or article fixes process this book now the other thing I run into an issue put a potential buck in the service. Please let us know as well.

B

We are synchronizing these twice a week, typically to our VSO, to both via so synchronization happens all the time, but we process these twice a week now to be fair right now we have a pretty big queue on issues to get processed because a lot of the key mail players have been in built and we've been prepping on SBC, which is coming on next week, so we're slightly behind schedule on getting all of this processed.

B

But if you run into critical issues, please please please let us know so we can act on potential, critical issues ASAP and if it's not a critical issue, just let us know still and we'll get our will kit on it as soon as possible. Now, if you have a few additional kind of announcements on those two, because on top of the typical slides today, we will release the new version of SharePoint Online management show just let everybody know this not technically a developer topic, but well as a developer.

B

You quite often have to do certain things. There is have one new powershell commandlets, which I somehow magically didn't actually mention in the slide, so that powershell command, let name is- and it go to my twitter and double check that, because I just can't remember what it was, but I'm gonna paste in the power comment let or the link to the documentation of that powershell commandlets in the ion window. It's this one and the powershell commandlets name is export.

B

Spo, query locks and this is around the TDP- are, let's say, requirements for sharepoint online and office 365. So this is around export being able to export data based on a user profile in sharepoint online. So if somebody's asking those that to happen, there's a tool to make that happen within the tenant level know what else roadmap quick comments on this one, so we wintered well. We are now stopped edit roadmap in microsoft built last week and we recovered this one.

B

Briefly in the last, we special interest group call as well the main changes in a road map. Well, obviously, ALM api's, let's actually quickly go to the store LM ap is are out. You can use you can use them in the site, collection, app, catalog or in the channel app catalog. So that's completely generally available as a packaging. That's the thing that we have an automatic CD and testing and sitting hosting, which is pretty cool. Then our properties is generally available.

B

Cyclic amp, catalog generally available the spring as well native craft access for sharepoint online is in preview and, like said in the build session, which is also recorded, unfortunately, this will not go to GA in the SP c, so we need to wait until the following version, which will come out in unknown time. So I can't. Actually we don't actually technically know the time for that so right now. Unfortunately, this capability is not yet ready to go general available available. So we need to delay that slightly API and dev.

B

Support for numerous other features refers to well, for example, site design actions and such as reactions, which have been added and during the spring now somewhere for native craft access for SharePoint framework th, so GA will happen absolutely yeah roughly on summer or fall timeframe.

B

We're trying to make that happen as fast as possible for the craft access, but for now it's not going to happen next week, just a bit of a warning on tougher enterprise solutions from SharePoint max of themes, huge thing if you've seen the recording from built, it's pretty cool setup, and we will actually talk about this one in a much more detailed way in upcoming SPC, starting from Sunday actually from the workshops, then IV solutions, Mike's a team's to SharePoint and this interesting scenario, as well so by ignite we're looking into having you the opportunity of associating any of those.

B

Is we ISVs, which are in the teams tab to also host in a SharePoint site, so not just good to SharePoint web parts to teams, but also get the existing SharePoint? Sorry teams customizations in the SharePoint site- and this is really a personal- it just reinforced message here. It's a really fundamental change in our internal thinking as well. We want to start consolidating the way we support and implement. Customizations in officer testified. So basically, we already have discussion with other teams so, for example, office add-ins, extensibility team.

B

It would kind of make sense for using SharePoint framework for that as well and a few other teams as well. Will those things happen, no idea, but we are having this consolidation between SharePoint and teams, and that starts moving forward, which is absolutely brilliant. Now we are obviously the other teams are looking into how this is going from a developer perspective. I think it's the best thing ever, because you built once a using the same tooling cross all of the services and then you're able to certain or service your customization in a different locations.

B

So super super super. Create direction will still need to absolutely wait for some time to get everything available for you as a developer, but it's it's absolutely coming. We are making significant investment on that now. Club all departments for SharePoint frameworks, supercool thing you're able to push shell, for example, extensions and comment line, comment view comment set view you know. If you list view common sense, that's the writer list will come instead to the lists. Globalist are able to say from a local location that hey this button, put it visible in all of the document.

B

Libraries, without any additional thing, so you have a centralized control of making stuff happen. Dynamic data in SharePoint, favorite components. That's basically web part web part communications, including the extensions. So you are much more aware and you're able to bypass data between the components in a pace page and also SharePoint framework at SharePoint 2019. The exact dates for that one.

B

Coming later most likely, you will see that here two dates in next week in SBAC, I, don't I, think there's a session actually on Monday on SharePoint, Server, 2019 and so more details on that one over there now quick quickly addressing the question from Joe anywhere the modern UI for document sets. There is an internal discussion ongoing on this one. We are absolutely aware of that gap. There are other gaps in the modern us and we're criteria getting those at rest as well.

B

Now, if there is a user voice entry for that, one I can't remember. I would ask people always that votes on the UserVoice entries, because more votes means that it will be more visible in the senior leadership level and then the senior leadership level who decides our priorities will basically say well this thing which we're planning to do that's a number two in a user voice. Well, absolutely makes this happen if it's a random, whatever ask from a and PN which, let's say some random VM from Microsoft comes with a great idea. It's like okay.

B

Is anybody asking this so the pride? The use of those points do actually matter quite a lot in the our priorities. So we know what other things which we need to do it first, obviously, there's certain things which don't go through the use of voice, but please remember that channel as well. Good.

B

Cool so quickly, moving on are things so more details about SharePoint, Conference 2018, starting from Sunday the Monday is the keynote will have a really great keynote full of announcements in here and there and there point a lot of stuff coming up on that keynote. If you cannot make Las Vegas that keynote is streamed, so you're able to actually join on that one I think it is the virtual summit and I'll get the link for that one when Chuck's starting to talk, unless somebody else has it already in their hands.

B

So basically the Mondays keynote will be streamed, live from Las Vegas, so you're able to join on that one and have a look on what's actually being announced. Then the actual sessions in Las Vegas are not, unfortunately recorded, but the key announcements will happen in a keynote and then after the Las Vegas, esterday SBC will keep on having special interest group calls, for example, of shape and framework next Thursday and then the following one. So whatever will be announced last week, sorry next week, we'll talk about them in the community course as well.

B

Cool good comment from Ross, not kind of comment, anything on that one good. So let's actually switch to check so I took pretty typical 15 minutes from the start. So Tex has the stage for following let's say, 30 minutes, depending on how much we actually want to talk and Chuck sorry, I I did meet with you, so you probably can get yourself on miracle and do this. Can you hear me hello again.

A

B

Okay, did you by the way I ended up in office already, it's just out of curiosity or are you at home no.

A

I am still I'm just joining to my home, okay, I haven't but I'm all set to go to office.

B

Yeah, it's a 7 a.m. in Pacific time. So it's it's slightly early, but that's fine, yep I'm.

A

Gonna take over as presenters. No absolutely this isn't my district, so hi everyone I, am chakra deep. Many of you know me as Chuck's I was part of the SharePoint framework and the web parts when it all started three years ago.

A

It was a good journey, so after that I went to focus on the maker scenarios, so basically even its flow and power apps integration with SharePoint, especially putting the same thinking hat of what we started with SharePoint framework, is how can we make the framework work for both parties and third parties?

A

And one of my new you know, challenges in this new role is also to look at how can flow and power apps be part of the first party scenarios as well, and you will hear a lot next week in SharePoint conference on all the investments we're making in in both the platforms today, I wanted to concentrate more on the various releases we have done and released as part of the sprint update.

A

So if you haven't been in this maker area, which is really you know, not really making something very specific to your target audience, but it's basically makers tool as mean that people who don't have to write code or for the projects that well, you don't have to write code and just use the out-of-the-box tools and other applications to build the things you want to build in the platform and with Microsoft having power as the key business app platform to build your apps.

A

So power apps is the choice that SharePoint has taken forward when you consider the olden days of InfoPath right so info part, let you build a lot of custom forms and also build you standalone applications and have it in apply to SharePoint and many other areas. So power apps are similar to that. Where now you can actually do the things you can do in InfoPath in power, apps and the same thing is with the Microsoft flow.

A

This is our work flow, orchestration platform that connects not just to SharePoint, but also to many other services, and you can see today we already have around 200 plus services in flow, where you can go and say hey. If something happens, and you know Google photos or email, you know go, do something or something happens in office, 365 exchange or SharePoint. Let's go do something in the workflow orchestration tool, so both of these have lots of power and we're going to be flowing with power.

A

If you consider the pun and see a lot of updates, excuse me so in the tech community, blog post I will paste this link in the chat window. Chris McNulty, who is our marketing counterpart, just added a blog post in the tech community portal on the various updates that we released and some of the updates that are rolling out now in inflow and power apps area. Can you guys see my screen.

B

Yes, ok! Ok! Now we caught at sir excellent.

A

So we have been very busy, so there is like a lot of cool stuff that was completed, and this was based on a lot of feedback. We heard from you guys supporting multivalued fields and some refuse in power app, so you can bring those in into your app and custom forms rewrite for attachments. So that's another big update that happened a few weeks ago, roughly I, think during the MVP supplement that we had, and that was really good. There's a flow launch panel I will show you the demo.

A

So there's a lot of stuff in here that, if you read through this blog post, you will find what I am concentrating on. Today is kind of going to show you some of the things with the power apps web part review that is available today in the first released tenants the attachment support, Lakes hell. Let's have a look at that.

A

There's a new out-of-the-box flow called request, sign-off, it's a very simple lightweight approval, workflow that you can ask someone for feedback and kind of sign off certain documents or list items, and then the content, approval flow action. So Kanaan approval is a very key feature in ECM.

A

You know you can have pages and documents or list items in draft pending and approved and projected stages, and then we have our mighty powerful sharepoint HTTP, request flow action, and then the item deleted flow trigger so I'm going to go through these one by one and show you a demo of what we have been doing in this area now before going to the demos I want to I want to just ask something from the community. Is that I am going to be more prevalent in the community with the maker scenario?

A

So if you have feedback, if you have any sort of issues that you're going through, feel free to reach us yrp and be you know the official channels that you already know where you go with your feedback, we we are going to take it seriously and we are going to be part of the community. We haven't been in a truth, be told. We haven't been that open yet, but I think now.

A

This is our chance to have maker scenarios as part of this whole developer platform, and you know, make things simple for everyone should go build so we're part. So let's have a look at the web part so for a webpart.

A

So here's an app that I just built and it's basically an art browser that you see in the sample power apps and that's just going to load the app and you can see how big the app is for a reason that it is built to fit them or by layout, and then it basically gives you all the akshar of your in your art. So what I'm gonna do is I'm going to put this app, basically in, but this app in a SharePoint page.

A

Previously, you could select the content embed web part and then you put the URL of the you know the you pull the iframe code and then you put the iframe code middle with the height width and even auth right, because that doesn't continent but web part doesn't really know what power app means and how to authenticate and do all the other things that needs to do the setup. So now, with the power apps web part, which is available in first released tenants as a preview.

A

If you search for power, you'll get power, apps web part, and then there you can put the app web link or ID in this case, I copied the app link.

A

So now, as soon as I put that you will see the app loading here in my screen and there it is that's the app and some of the things if you see here was it didn't ask for my sign in information, so we handle the assignment information for the user here when you add the web part now one thing we don't do, is we don't grant permissions to the users, so you have to ensure that the app is shared with the appropriate folks, whether it's shared with everyone in the art or the specific group group site, so that users have access to the app the other things we also provide option is to increase the resize, the app so at the bottom.

A

You can now resize the app to its maximum size. Maybe you just want it much smaller. You can do that as well. So we give you that opportunity and we also scale the app to kind of percentage that it fits the SharePoint.

A

You know visualization, so it doesn't look really good, as you saw in this particular scenario, where I open the app in the browser. So now, if I publish this is going to behave as any other their path, and now I can basically do all my stuff in here. I don't have to go beyond the site and then it's gonna basically work the same way. It is supposed to work in power app web browser.

A

Now this is a first really like this is probably the first step in making power apps and but in the SharePoint page, and we have lots of updates. There was a reason why it's called preview here, kind of making sure things are all aligned in the backend. The performance is right. You know we don't get much if the page you know it needs to look good. It needs to behave like a web part on a page.

A

So there's a lot of stuff in here that we are looking at you and you will see us pushing more updates before we go GA for this web part. But if you have, if you are using this web partner, if you haven't yet I, would suggest you to use the web power and give us as much as feedback we can get from you guys. So we can then get that time to go see. If we can.

A

You know, there's some problem, that we need to fix before going GA or is there some options that we are missing before we go GA as well, so that is the web part or absolutely pop demo. Any questions on this.

A

Okay, I'm gonna go to the demo, not some demo, so attachment support. So.

A

So I have a list here called projects, and this project has attachments column. So basically, I want to attach some project information, some documents for a project. Now, what I have done here is I, have created custom form, I added the custom form capability here, so basically I was too quick. Let me go to that list again and show you what I did.

A

Everyone familiar with custom forms anybody new to custom forms.

A

Okay, if you are on a list, are visiting on a SharePoint list, you can click on this power, apps and then customers forms which will take you to the power apps and will have the custom form in place and will give you the necessary integration with the SharePoint list and will build you a form and a screen as well. So you can get go or you can go from the stop and one of the things if you click the SharePoint farm.

A

If you want to manage the fields that you see or you want to hide certain things, you have the data property with the SharePoint form. You click that and you will see the data source that you're connecting to, in this case my projects list and all the fields available for me to add or remove and one of the fields if you scroll down you'll, see attachments. So once you add this attachment field, now, it's actually going to give you the attachment control.

A

Where now this will be visible to users when they create a new item and similarly, when they view our edit the item. So, let's save this and publish this to SharePoint. That means that now this will be the version that the SharePoint lists will use whenever somebody creates a new edit or view form. So now, I can go back to my list.

A

I'll probably do few refresh so that it doesn't have any cash in place.

A

Hey so now I click new you can see the power I perform is getting loaded rather than the SharePoint list form. Now I can give a title to this. Let's say: project six: let's give this project your intern John Doe due date. Let's set maybe.

A

Very first and then oh I know this hasn't yet loaded. My new form because he's you didn't see the attachment control.

A

There you go now we have the new phone, so let me give project. Six owner is John Doe due date. Let's say: five 31 2018.

A

It's for India and now I have the option to attach a file, so I can just click on attach a file. It's going to load. My you know in our file. Dialog I can click open and then it is my file and if I click Save now you should see the new item creator with the attachment in the attachment column.

A

Oh I, don't have the attachment.

A

A

Oh, something happened. Let me attach again.

A

A

Good times it's interesting, let us see what this is doing.

A

There isn't anything, it shouldn't happen anyways this should work, and if you find here custom farms, you should see you should see it working, and this was actually working when I when I tried it yesterday night. Well, let's see one quick.

A

Maybe it's a list problem.

A

A

Yep, it's there.

A

One last thing before I give up on this.

A

Attachments to the list are enabled so yeah I, don't know, what's happening, I need to go back and bring few folks to see. If this is actually working or not it's supposed to work. It was working yesterday when they tried it out for the demo, which is also a demo I'm, going to be doing at the PC I'm going to be showing attachment. Oh so, what this works at SPC, ol.

B

Kid Jack's we're gonna cut this section from a video just kidding.

A

Yeah, so let's so those were the two things in the power apps world. Now, let's go to the flow world where there has been a lot of new stuff flowing through the first one. Is the request, signup flow? So imagine you wanted to get some feedback around this list item here and you wanted to send it to someone so I can actually now, if select a list item or in the case of documents, you can select document and I will have a request, signup flow.

A

So this is something that will be available out of the box. You don't have to do any setup. I can click request, sign-off and that's going to.

A

Launch my flow panel, which, for some reason it should.

A

There you go, and basically it will take me through the steps that I want to do for this particular flow OOP. The demo goes I'm not being good to me today morning. That's how what did you do.

B

Now I can take full responsibility of this room. Oh the the switches I was wasn't supposed to change them in the data center. You see yeah.

B

Yeah, it's a Skype Skype trauma.

A

We should have used themes so anyway, it's working now so in the approver I can say. Let me put John Doe, as my approver hey. Can you.

A

Look at this project run flow and then now what that, what the flow did was it added a column, call sign of status and then it put the basically the state of spending. Now this is not content approval. This is a very lightweight. Feedback system meant to be really simple and straightforward, so we don't do any sort of you know, locking the item or any such thing in here now, if I, actually log in as.

A

A

Actually think I know what's the problem with the attachments control but I'm not going to do that now.

A

And let me open my email.

A

Yes, I have got an email saying, please approve project, 1 and.

A

And I actually get an actionable message along with the original message that the flow sent me with the information about the project. One list item so I can either click on this list. Item I can go look at it and that will basically give me the view form of that list. Item which is going to load my power app or if I am really good.

A

If I'm, an internal need to be, you know, making my boss, happy I can just say, looks good, find out and then once you submit that's going to go back to the list and then, if we refresh the page, it should be approved. So this is a very lightweight sign-off request, sign-off feature where we are not using any of the SharePoint capabilities, but just making in our lightweight approval and sending some message to whoever you want to send it and get it approved.

A

So the next demo is on the content. Approval flow action, so Connor approvals are basically used when, especially in the document, libraries, where you have certain approval status that you want to maintain on. What's the contract status, for example, has it been approved, rejected or is a draft? So basically the way you turn on this is. If you go to library, settings and then versioning settings, you will have the option to enable content approvals and then create a version each time, depending on whether you are doing major version or major and minor.

A

The way how you build these things would be very different. I'm going to show you today what happens with major and minor and I will tell you what's the change in the major version, so what I have done is I?

A

Have a flow here called document approval that I created that is attached to this document library that I just showed you and in there it's going to say, run this flow and a file is created and then I'm going to get the file metadata, because I need all the information that I can from the document item and then I use this set content approval status action. So this action takes the item id of for the particular item. You want to step back on an approval status in this case.

A

It's the item ID from our when a file is created and then the particular action I want. So some it is pending. Approvers approve, reject this, reject and there's a status called drafts, and that would be the one that would be the default case in the major and minor version content approval sitting.

A

So whenever you upload a document it becomes, it is good to draft it initially until you go and say it's now pending or somebody changes it for some approvals, so once I put some it, it puts the document approval status depending and then it starts an approval and if the approval status is approved, I use the same content approval status, action this time, I approve the status.

A

So now the document will be approved with the approval comments and one of the things if you notice in my previous corner of all action as well, I'm using the e-tag variable here so e-tank is very important when you are working with documents or pages in the pages library, the e-tag represents a particular version that is waiting for the approval. So, along with the document URL, you have to happen.

A

The e-tag in order to get and look at that particular version that we are approving, so that's something you need to put it here in the action and then I just send an email saying that your document was approved if it's rejected, when the approval is rejected, I go and set the action of this content of who-ville status to reject. So it's that simple to use it. Now, let's see if this actually works, and hopefully this time it works.

A

It's going to upload this dock right now.

A

No I actually think that's a problem with the sync engine.

A

Yeah, it's the onedrive sync engine.

A

And guess what my attachment didn't work so I'm gonna drop it here.

A

What is happening?

A

Hi? It's an MP document. You please him. The MP document is no. Oh! No, it's not! Okay. Maybe that's why my attachment to didn't work so there's like a few options like that didn't work, but we can try yeah. Okay, thank you.

B

Should welcome.

B

A

Have some sample stuff in here.

A

I have no to what's happening with word as well. It uploaded now and now it's going to put everything in draft and basically, if I look my mail cuz I'm the approval for this library and if you go back to your flow, you see there's a flow running seventeen seconds ago and that set the control state is Chu pending and if I actually refresh this page, you should see the approval status depending right now and I should have received an email.

A

There is document records your approval.

A

And now it has my review and approve the contract document. The link to that particular document here again: I can click the link or I can just approve right from the actionable message and once I click approve.

A

Now it should see this running and it set the content approval status to approved, and now it's going to send an email in a second address, and it should go back to my library and refresh it. If you see my document, status approved and I should have got an email as well there. It is so. This is how you can use the content, approval status, action with the list items, document, libraries and even with pages and pages library. One thing to note, with pages, is that you won't get.

A

People would still be seeing the publish button and they will still be doing that. There's no any integration. Yet the only thing that will help you is. Whenever a page is created, you can have someone set up flow, so it can set the page status exactly the same thing. We saw with the document and go through the approval process manually. So that's the content.

A

Approval status action the next one, the interesting one is the SharePoint HTTP request flow action, so SharePoint is a very big platform with lots of api's and lots of scenarios to cover right. Of course. Unfortunately, we can't build a flow action that represents every single API in the platform. So we decided that it would be helpful if we can have flow action that executes SharePoint API requests.

A

So that means it opens up you the possibility of using the REST API eyes, even for the scenarios or even in the same action that may not support certain things to use this flow action. This is very developer, oriented action and we wanted to unblock those developers who are jumping into the space, so they're not they're, not feeling that it's very limited to their capabilities. So, of course you know looking at how customers use and what feedback you are giving us.

A

We will improve this action as well as we will see which wants to promote to the you know, a negative flow action for those specific scenarios. I've seen lots of Twitter engagement on this people have created unique permissions. People have used the share and copy to move to UI. So there's a lot of stuff that going on with this I should be requestable action. Let's look at one of the demos of this, so if this demo works, I'm really good like this is going to be the ultimatum of this.

A

So what I have is I have projects list and I have research and development lists, and each project has a owner right. So in this case here I have created a flow where I can select this project and now I can say, create a research project. It will create a new list item on the research and development list and we'll set the permissions of that list item. Only the owner of that project right, pretty cool, so honest, so I'm gonna, say create research. Project I have pretty much any input there.

A

As long as my flow panel comes up and I'm going to say, run flow and that's started and I'm gonna go to my research and development. That was, my project was created and I'm going to see. Who has permission on this so I'll go to details. I'm gonna see manage access and I have access a John Doe myself and my team owner. It's not a fake you once you should see. This list item has unique permissions, so that worked.

A

So let me check this so I'm going to go to my in private window is John Doe, just making sure John Doe can see this because we just actually use this account except the unique permissions.

A

The iris project to is there now I'm, going to sign out and log in as another user.

A

This time, I'm going to log in as.

A

One of my emails ACCC, it's actually Frodo Baggins I, hired him as one of my employees. So now I don't see the project to where, as I was able to see for John Doe, it's pretty cool right. So now let's go and look at the flow. What we did here so in my flow I, have a flow named, create research project. The trigger I have for this flow is when for a selected item. So for a selected item means for that particular item.

A

When you sell like the flow will show up so then you can actually run the flow so for a selected item. I get that and then I get. The item for that which item is selected, I, create a new item in the research and development our list and then now I go into setting up the unique function. So the steps for setting up unique permission is you need to first break the role in there. It ends, and then you need to set a drone assignments to set to basically break the item permission.

A

You pretty much only need the ID ID of the item that you created, which is here, but here now I'm using the HTTP action and basically saying with site address. So this is my team and then what method? So here I have post put patch all the rest, API methods right so I'm, saying, post and then I'm using the brake role, inheritance.

A

No I think it's good, so here I am using the brake roll hareton's API and saying don't copy over the existing concepts, which means I'm putting false there for that particular ID that I used in my create item, which is a research project right. So it's pretty straightforward. If you know the SharePoint API that you are dealing with, then you can basically use this action, so this is good, but then, when I use, my set unique permissions I need another extra input that I need to supply to this here.

A

I use the API, roll assignment, splash, add roll assignment with the principal ID and then the roll definition right now. The role definition ID is a constant. If you google, for it you're going to get it. This means contribute. There's a number for read and there's number for edit.

A

The principal ID is the prints checkpoint, principal ID, for the user, that you want to provide, assign the unique permissions and the item ID is the one that we created in the research project so now to get this ID I am using another API called the get by email and for the site uses in point right. So previously we use lists and now I'm using the site users. In point now, you can see how it actually goes. You know, gives you the possibility of interacting with the various API.

A

Is you have in SharePoint and here when I say get by email, I'm getting the owner email from the item of that for the flow that I selected to run the flow in my projects, you list so here it gave me John Doe, the other thing you can see here and putting the header and saying oh data equals no metadata. This is called JSON light. Syntax.

A

This means, whatever returns, whatever gets returned as a response from SharePoint will not have any rest metadata, and we only have the response, the JSON value of the response, so it makes easier for you to pass. It makes easier to even create a JSON object here in the flow using the schema and finally I use that ID in my principle, ID now one thing if you're not here is that you can see the body is here the way I access.

A

It is body of that particular action which is sp a request, get user principle and then I straightaway request ID. Now because I said no metadata, I don't have anything else and I just get the JSON array. I'll show you in a moment and I just basically clearly that I need property from them. Json object and, and that's pretty much it and that will now set me basically create the item.

A

Great they're, all inheritance in that item and then set the unique permissions for that user, and that's how I can make this work now? If I don't have this action, this scenario? Doesn't it doesn't exist right? So this is one way you can use the HTTP action. There's also another flow that I wanted to show which is much less complex, get items by lookup field, so I will get items, doesn't support filtering by lookup fields, because lookup fields need to be expanded and selected right.

A

So we don't support both select and expand in the default, get items action in flow, so rather what I'm doing here is I'm actually now using the same HTP request to sharepoint and in my projects list the country is look up to this countries list right. So it's very simple setup. So in my flow you can see what I'm doing here is I'm doing a get action and basically saying for the list in project.

A

Get me the items select the title and then country, slash title means that I'm selecting the expander the lookup column country, ash title, which is the. If you go to my projects list you'll see the column. Name is country right so that slash title this will tell sharepoint is a lookup column and then I'm expanding country slash title I'm, telling SharePoint to expand that and I'm adding a filter that country slash title equals New, Zealand right so now.

A

This will basically pull you only the items with that look up the mattresses quickly with the look of field and again I'm putting here no metadata. So let's dis this now in order to test this before you have to basically go through. You know several hoops here we go and we actually trigger the trigger. Now we have this test button. So with this, this button, I can actually say I'll go from this trigger action or use a data from previous ones. Right so I'll say: let's use my trigger action.

A

It's a recurrence trigger so I'm gonna run my flow right here in my flow portal, and now it's going to show me the run activity and you can see the response of this action that we just executed. It basically gives you a JSON array, which is a JSON string, there's an object, and then the value is an array which has the result from the ayah grants right.

A

If this was not using the light metadata, you have like underscore the score metadata at the you know, so much information that you it'll just make you so hard to use it. So that way now you can basically go and write really simple expressions to pass the output from this object. So this on object from the HTTP action is select an outputs of view and applied to each because we want to traverse through the value array you can say body of send and a shape, a action name and then the value.

A

So that will give you the our way. So since it's an array, I can do apply to each and inside the array you can see now I'm saying sorry here is and I'm sending an email which basically says items apply to each which is sort of what flow users. If you want to now get the particular item in this for each loop. Since we are not using named properties, we are using a you know, just a JSON object. That's the reason why you are writing these expressions.

A

We have items of that apply to each action and then, in that my lookup field is country and then title right. So it's an array again so I have country entitled you want this idea. I can just just IV or forget the title, just title of the list item here, country and title, and that would have sent me an email here, this country's New Zealand right. So you can use the HTTP action for that as well. Now one last topic item delete a flow trigger, so a new trigger will released a few weeks back.

A

Is the item deleted? So we had item created, be an item creator and modified, and then we were missing the item deleted figure. So now you can have the item deleted trigger in SharePoint. So basically, if you create a flow.

A

And search for connectors and triggers.

A

And then click SharePoint, you should see when an item is deleted trigger. So this way when a file is deleted trigger, so both are different because of the metadata that gets returned, but you can use this now if you are tracking the items in a very different data set or some other applications, and if you want to know something changed in SharePoint, let's push a deleted, you can get the ID and the title back, and then you can use that in your system to go, manage any synchronization that you need to do so.

A

Those were some of the updates that I wanted to come and show you guys of all the things that are happening in the flow and power apps I will make this something regular, so I can give you some updates and talk some of the scenarios. Maybe you guys have do some great solutions that you want to show us. Let Bazaar know: let's do that as well in these calls and get you know better with flow and power. Apps.

B

Absolutely so, if there's channel you or Paul or whoever wants to demonstrate something in this course as well, but I'm more than welcome, so this would be the call where we talk about these things as well. Obviously we talked about power show, but about other architectural solutions and architectures here as well, but our show power apps and follow absolutely welcome. Thank you. Checks for the demo I will jump to the right slide, or that was key a nice line. We do have five minutes for random Q&A for towards me or checks and yep.

B

Bending on the questions. If there's anything.

B

Even though they said this is a developer, quotes call and it's it's clicked or what is it? It's, the what's the right term for that people use the citizen developer.

A

B

Plans to support for content types and power apps.

A

Yes, we are thinking about it, it's it's on the roadmap. We we don't know when there are other things that we're looking to fix as well, along with carbon types.

B

John Leo has a question that explained run oh yeah, so.

A

For flows that you create, when item is selected or when a file is selected, meaning the demo that you saw of create research project where I selected a project and then I click on the flow menu and then it said, create research project, so those kind of flows are called manual trigger flows and for that flow, if you go to the flow portal, as an owner of that flow, you will see manage run only permissions. The run only permissions.

A

What it does is it allows you to pick the context of the user that is running the flow to be used for the sharepoint connection or any other connection if it matters so in the sharepoint, you can say, for this run, for this sharepoint connection use the run only user context.

A

Now, at that time it will take the context of the user and use that context to execute the sharepoint actions you have in your flow, so this is only available for manual triggers and not for the automatic triggers, which is the even items created or modified of the liter. That runs with the owner context.

A

I'm not sure about P and P J's expressions.

A

There was another question about that: I.

B

Think I missed it today, but that would be for Patrick, because Patrick is gonna call as well. So thinking also about being various expressions is the question from Vincent I I.

A

Don't know Jax could maybe answer this better, but I don't know that there's any real way to sort of include external libraries into flows at this point yeah, so that I mean that's if that would almost be like doing an azure function at that point, so you could use the HTTP call stuff I suppose- and this is just off the top of my head.

B

So you can call out to an azure function and do whatever you want in that or an.

A

Azure web app using the HTTP connection and there you could use P and pjs or really anything at that point. But of course it should be P in PJs or.

B

Pmpa some core it away. That's.

A

The pond please the SharePoint HTTP action. Let's be very clear, it is SharePoint if you it takes the share context of the user. It uses that context and works with share form if you are working with other set of risk. Api's that Microsoft doesn't own- or you know, put in the platform like a third party API or PNP API is the P and P API REST API needs to support that.

A

It's not that we can't do it, but you know there needs to be an action for that API and you need to basically take the context of the user and pass it along. So that's why you? We can't have other external libraries unless it's part of the SharePoint om, we can use a non REST API.

B

A

Been claimed, as we see I've seen that working I don't think everything works there because of the like metadata stuff, I, don't think it works, it might be flaky, it's it will just execute I, don't know how much of that would be useful in this action.

B

Yeah, it depends on a process query, so it depends on a scenario but cool I think we're hitting tower. So, let's actually close up gradually the thing we do apologize. If we missed some of the questions there were so many questions. We need to really really pay more attention that there's more time for Q&A in the future. That is in our attention. We're gonna drop down more, but we never will have any more tree demos in a caller because that's pretty insane so having a two demos and plenty of time for Q&A.

B

Is it's more efficient so but I think that's it for this one. So thank you, everybody for joining if it will be be in SBC next week, come and drop by, but there is a shape on deaf community booth, where we have BMP crew as well and they're engineering people inside as well so see you and the power.

A

Absent flow and there's.

B

A power us and flows booth as well, absolutely and then, if you're not in there, but you will be in european--, communicate European collaboration summit on following week. There's a lot of the BMP guys will be there as well so drop by and ask questions and give us feedback. But thank you everybody for joining. Thank you, Chuck's, for a great demo and run-through of the different capabilities. The video will be a video was recorded successfully.

B

My skype worked for a once in a tenth time and the video will be properly request to the YouTube channel within 24 hours. But thank you and we'll be absolutely in touch. Oh boy. Thank you.