Microsoft Flow – Get Item from SharePoint List

I wanted to write this blog post for a while. This one is on how to use Microsoft Flow and get SharePoint list item.

So when using Flow you have two actions for getting a SharePoint list Item.

  1. SharePoint  – Get Item
  2. SharePoint – Get Items

 

Picture above displays the description of each action.

Lets talk about the SharePoint – Get Item action first. As you can see that when using this action you will need to specify item ID to get the item. Now for the most part this would not work unless you have a context of the item and you are passing the ID using the context. We will talk about this in details when I cover For Each action. But for now my recommendation is do not use this action using the hard-coded ID unless you are in a situation where you have pretty static list and ID never changes.

Now the second action, SharePoint – get Items is the real deal. I mean do not judge that action by the description provided by Microsoft. That description does not justify the action. 😀

This action allows us to specify query to get the items and also allows us to specify Order By and Item count.

You need to specify ODATA filter query. You can get some general ideal about ODATA query using THIS article.

Basically you would have to specify field’s internal name and then your expression and then your value.

If you are expecting more than one item returned then you can use the Apply to Each action which I will cover in future blog post.

Office 365 – Cannot add Plan to your favorites – Planner

For anyone that is new to Office 365 and not know what Planner is then you should spend time understanding MS Planner service. Planner makes it easy for your team to create new plans, organize and assign tasks, share files, chat about what you’re working on, and get updates on progress.

In this blog post, I am not going to talk about Planner much but I am going to talk about potential issue that you may face depending on your tenant configuration.

When you are on the Planner Hub you see various options to visualize your plans. One of the feature is to add plan to your favorites.

When you add planner to your favorites you may receive the following error. As I said earlier this is not going to be the case for the most part but as far as I know in one specific scenario you may receive the following error when adding plans to your favorites.

Upon researching I found the following very useful blog post.

https://blogs.msdn.microsoft.com/brismith/2017/07/14/microsoft-planner-why-cant-i-add-favorites-or-comment/

With all credits to Brian (author of the blog post) I am posting scenario that I ran into where I go the above error.

In hybrid scenarios we do not support comments or favorites for users with their mailboxes on-premises as the users needs to have an Exchange Online mailbox to engage with these features.  EXCEPT – if the user does have an external email address configured and is configured as a MailUser in Exchange AD.  In this scenario the user will be able to use these features even though they have no EXO mailbox.  If the user is configured as a User rather than MailUser – and has no external email address then things won’t work.  This has explained the situations where some users work and some don’t in a hybrid environment.  Also of course some users may be fully in EXO and others in on-premises mailboxes.

So, if you run into the above error make sure to read the above blog post.

I hope this helps someone who is currently using Exchange in Hybrid scenario and running into this planner error.

 

Microsoft Teams now rolling out Guest Access

If you are using Microsoft Teams then you must know that  the #1 request feature on Microsoft Teams uservoice is to allow Guest Access. Microsoft Announced on September 11 that they will start rolling out Guest Access to Microsoft Teams.

This is awesome news and I am looking forward to testing the guest access with Microsoft Teams.

Now there are couple of things that we must know. Microsoft Teams have decided to only allow Azure AD accounts that are currently part of Office 365 tenant. This means if you are inviting external user as Guest to your MS Teams they must be part of any other Office 365 tenant as a regular user. Then you will be able to add them to your Team.

Now to add external users you will need to make sure that this setting is enabled at the admin level.

  • Navigate to your Office 365 Admin Center
  • Click Settings –> Services and add-ins –> Click Microsoft Teams
  • Select Guest from the “Select the user/license type you want to configure” dropdown
  • Turn ON the “Turn Microsoft Teams on or off for all users of this type” switch.

Once this is turned on you will be able to go to your MS Teams and add external users. Once the external users are added they can switch their tenants to access the Teams. Currently switching the tenant option is not supported on mobile devices and hence you must use the desktop app or browser to switch the tenant.

This is a great start by Microsoft Teams and hopefully in future we will more improvements around this area specifically allowing any external users and allow switching the Teams using mobile devices.

SharePoint 2013 – SSRS – The permission granted to user Error

In this blog post I am going to talk about SharePoint Server 2013 and SQL Server Reporting Services integration. If you want to configure SSRS in SharePoint integration mode then you can refer to the article below.

https://blogs.msdn.microsoft.com/biblog/2012/12/04/installing-and-configuring-sql-reporting-services-on-sharepoint-2013/

Once you have SSRS configured in SharePoint Integration mode and you try to create a new report depending on the configuration you may receive the following error.

The permission granted to user ‘NT AUTHORITY\ANONYMOUS LOGON’ are insufficient for performing this operation.

Upon some search I found that you will receive this error if you have turned on Anonymous Access at your Web application level.

  • Go to your SharePoint Central Administration
  • Click Manage Web Applications under Application Management.
  • Select the Web Application where you are getting the above error and click Authentication Provider.
  • Select the Authentication Provider Zone(default is Default).
  • Confirm that you have not checked Enable Anonymous access.

Now if you must have the Anonymous access enabled on your web application the only way you can get it working is by creating a new web application where Anonymous access is not enabled. Get your report ready on that web application and then move it to the web application where you will be using it.

Basically your report would work just fine but you will not be able to design it when you have Anonymous access enabled.

I hope this helps.

 

New Office 365 profile experience

This is pretty exciting news. Microsoft announced that they will be rolling out an extended profile card experience across Office 365 to enhance the way you collaborate with colleagues and external contacts. There are several big improvements on top of the current user profile experience that we get on O365.

Some of the key improvements are

1) Quickly look up documents that have been shared with you, independent of how they were sent.

2) The new Organization view shows a complete picture of the highlighted user’s position in the company, including their direct reports and co-workers.

3) New profile card is integrated everywhere you see a person’s name on Office 365 without interrupting your productivity.

You can read details about this new change in the following blog post.

https://blogs.office.com/2017/03/10/introducing-the-new-office-365-profile-experience/

 

Using Javascript Object Model (JSOM) with Nintex Forms

Recently working on a project I came across an interesting scenario where I had to use Nintex form. As a part of the process the form will be querying multiple lists and displaying data on the form.

You can achieve this using the Nintex Form out of the box controls but there were specific requirements which could be achieved using the out of the box controls.

I decided to use the JSOM to complete the task and plugged in my JSOM code into Form’s custom JavaScript section. To my surprise when I ran the Nintex form nothing happened.

Quickly I figured that my code was getting executed before SharePoint finish loading all the files and required SP.js file was missing at the time of code execution.

So I tried Script on Demand to make sure that my function only gets executed after the SP.js is available.

Here is the code I have added to my Nintex form.

NWF.FormFiller.Events.RegisterAfterReady(function () {

               SP.SOD.executeFunc('sp.js', 'SP.ClientContext', myFunction);

}




function myFunction() {

.

.

.

.

}

Once I added that one line my code worked like a charm. So if you are working with Nintex forms and would like to use JavaScript Object Model then you might run into the same issue and in that case just make sure to use Script On-Demand.