Microsoft has changed calculated fields to block the execution of custom markup. That means calculated fields that contain any unsupported markup will not display correctly.

This change went into effect on June 13, 2017. Administrators can request an extension through September 10, 2017 at the latest. During this extension, execution of custom markup in calculated fields will not be blocked. This request can be submitted through Microsoft Support. However, beginning September 10, 2017, all unsupported markup will be ignored. This change can be controlled in on-premise SharePoint 2013 and 2016 using CustomMarkupInCalculatedFieldDisabled setting.

Alternatives

SharePoint Framework Field Customizer

To extend the SharePoint user experience within modern pages and list/document libraries

Provides modified views to data for fields within a list/library

more powerful and can write custom code

End users need developer help to deploy the solution

For more advanced scenarios that column formatting does not support

Not supported in classic experience

Column Formatting

To customize how fields in SharePoint list/library is displayed

No change in data; only changes how it is displayed to the users who browse the list/library

Anyone who can manage list/library views in a list can use column formatting

MSGraphClient is used to perform REST calls against Microsoft Graph. The Microsoft Graph JavaScript client library is a lightweight wrapper around the Microsoft Graph API. This class allows developers to start making REST calls to MSGraph without needing to initialize the the MSGraph client library.

Note: Microsoft Graph API is replacing the previously released GraphHttpClient, which is now considered to be deprecated.

In this post, I am going to show you a SharePoint Framework WebPart to fetch my User Profile details using Microsoft Graph API. I consider that you have a SharePoint Framework HelloWorldWebPart WebPart, if you don’t, take a look at this article.

Note: API Management can be performed only on first release tenant.

Import the MSGraphClient in the HelloWorldWebPart.ts file as shown below

Write the following code snippet inside the render function.

Open the package-solution.json file and update the Graph API permission

Update the CDN cdnBasePath parameter in write-manifests.json file as per your setup

Execute the gulp bundle and gulp package-solution with ship attribute to prepare the build

Upload the CDN files in the CDN location specified in the write-manifests.json file

Upload the SPPKG file in the app catalog site. As shown below, We have to approve the Microsoft Graph API permission requested by the developer in the package-solution.json.

Click Deploy

Open the New SharePoint Admin Center and click on API Management

Select the permission and approve the request

Install the HelloWorld WebPart in a SharePoint Site and add the same in a page

Verify if HelloWorld WebPart is printing the current user display name and mail in browser console.

Workflows help people to collaborate on documents and to manage project tasks by implementing business processes on documents and items in a SharePoint site. Workflows help organizations to adhere to consistent business processes, and they also improve organizational efficiency and productivity by managing the tasks and steps involved in business processes. This enables the people who perform these tasks to concentrate on performing the work rather than managing the workflow.

In the below example I am going to show you how to ADD/UPDATE a sharepoint list item with MMD Column.

Create Item

Step 1 – Create the following variables in the SharePoint Designer 2013 workflow and set the values accordingly

Step 2 – Add Call HTTP Web Service action and configure the same as shown below using the advanced properties

Step 3 – Based on POST Response Code you can perform your action using an If condition

Step 4 – Publish the workflow and test

Update Item

To update an item we have to slightly adjust the EndPointUrl and POST_RequestHeader variables as shown below

You can perform basic create, read, update, and delete (CRUD) operations by using the Representational State Transfer (REST) interface provided by SharePoint. The REST interface exposes all the SharePoint entities and operations that are available in the other SharePoint client APIs. One advantage of using REST is that you don’t have to add references to any SharePoint libraries or client assemblies. Instead, you make HTTP requests to the appropriate endpoints to retrieve or update SharePoint entities, such as webs, lists, and list items.

If you have a requirement to select a taxonomy field from SharePoint Designer workflow using Call HTTP action, it is not a straightforward approach. The below article is going to talk about few workarounds for this problem.

My List

Note: Job Title is a Taxonomy field.

Problem 1 – Select query will not return Taxonomy Term Label

Problem 2 – Filter query can not be applied against the Taxonomy field.

Solution 1 – CAML Based REST Call

The following POST query help you to get the necessary results but the problem with this approach is we can not call this REST Endpoint from SharePoint Designer workflow as it contains curly braces and curly braces are used as tokens in SharePoint Designer.

Summary

This is an experimental web part. Because this technology’s specification has not stabilized, check the compatibility table for usage in various browsers. Also note that the syntax and behavior of an experimental technology is subject to change in future versions of browsers as the specification changes