August 12, 2020

Get Attendance Report from Microsoft Teams Meeting

Overview:
In this article, we will learn how we can get an attendance report from Microsoft Teams scheduled call. There are times where we need know number of users who join the call and their duration in a meeting. At that time this concept is very useful to us.

Note: This feature is only available for the Meeting organizers. Attendees will not able to see this option. So, now let’s get started!

Example: Consider the following meeting invite.

Here, Dhruvin is an organizer. Tejal, Shriraj are attendees. To, view the attendance report, Dhruvin (as organizer) needs to click on the “Show Participants” option.

This will open the right pane where Organizer (in this example, Dhruvin) can see an option to download the attendance report. Organizer can download the attendance report before leaving the call.
The report will be downloaded in CSV format and will look as below:
Add caption

Note: If any attendees click on Show Participants, then they will not have an option to download attendance report. See below screen from Attendee's view - Tejal.
Conclusion: This is how we can download the attendance report in MS Teams. Hope this tip helps you.

If you have any questions you can reach out our SharePoint Consulting team here.

[Resolved]: Getting null values from Multiline Text field with Append Changes Option in Power Automate

Problem statement:

We had a requirement where we need to get values of multiline text field from SharePoint list and use it in one of the action in Power Automate. The real twister was when we found that multiline text column was setup with Append changes to existing text option. The problem was we were getting blank/null response when we try to access that field directly in Email body action using Power Automate.


Analysis & Findings:

We dig out the issue and found that when we set multiline text field with append changes option, and add any value in that field, it stores the value as separate version of an item and not storing directly to that field.

Solution:

We need to get those values from the version history of an item but there is no direct way for it. So, we need to follow below steps to get values from multiline text field in power automate.

First, we need to initialize below variables that will be used to get version history of an item in Power Automate.

 

  • Add an action name “Initialize Variables”.

  • It will ask following information.
    • Name
    • Type
    • Value

  • Now, let’s create first variable name “AppendComment”.
    • Name AppendComment
    • Type String
    • Value <div class="ReactFieldEditor-AppendedData"><div>

  • In a similar way, we need to create a variable - “ColumnName”.
    • Name ColumnName
    • Type String
    • Value Column name from the list. Use the internal name. [Multiline Text Column]

  • And third variable will be “ListName”.
    • Name ListName
    • Type String
    • Value Your list display name. [ SharePoint Custom List Name]

  • Now, add an action for “Send an HTTP request to SharePoint”.

  • Add the following information in that action:
    • SiteAddress - URL of your SharePoint Site
    • Method - GET
    • Uri  - /_api/web/lists/GetByTitle('@{variables('ListName')}')/Items(@{triggerBody()?['ID']})/Versions
    • Headers
      • Accept (should be added as key)
      • application/json; odata=nometadata (should be added as value)

  • Now add an action called - “Apply to each”.

  • And set below value in that action.
    • body('Send_an_HTTP_request_to_SharePoint' )['value']

  • Now add "compose" action inside Apply to each action.

  • Add below value in Inputs textbox.
    • formatdatetime(items('Apply_to_each')['Modified'],'MM/dd/yyyy hh:mm tt')

  • Then we need to add Condition action.

  • Add below expression in First section:
    • items('Apply_to_each')[variables('ColumnName')]


  • Then select "is not equal to" in second section.

  • And then in third section, add null as value in expression as shown below. 

  • In YES side condition, add an action “Append to string variable”.

  • Please set below expression and click ok
    • Name - select AppendComment
    • Value - In expression, add below value:
      • concat('<div>',items('Apply_to_each')['Editor']['LookupValue'],' (<span>',outputs('Compose'),'</span>)',': ',items('Apply_to_each')[variables('ColumnName')],'</div>')

  • Finally, Value is set in AppendComment variable. And we can use "AppendComment" variable in Send an email action.

  • By following all above steps, finally we got correct output:


If you have any questions you can reach out our SharePoint Consulting team here.

August 6, 2020

Introduction to SharePoint Spaces

Overview:
Microsoft recently launched SharePoint Spaces and it is in preview at this moment. During this article we will cover the following things.
  • What is SharePoint Spaces?
  • Characteristics of SharePoint Spaces
  • Real-Life Use cases for SharePoint Spaces

What is SharePoint Space?
  • SharePoint spaces is a web-based, immersive platform, which allows us to create and share, secure, and extensible mixed reality experiences.
  • SharePoint Space adds a new dimension to our intranet by using 2D and 3D web parts to create a mixed-reality vision.
  • Building space is a lot like building a modern site -- that is, we create the space by choosing options such as structure, background, and theme. And then add web parts using 3D objects, 360° images & videos, 2D images, text, and more.

Characteristics of SharePoint Spaces:
  • Cross-platformSupports a wide range of web browsers and mixed reality devices.
  • Made for creatorsCommingle 2D and 3D content to create custom experience that tells our stories in stunning 360° view.
  • Secure and compliantSecure on Microsoft 365 ecosystem.
  • Integrated and extensibleSince this is a platform, Microsoft will grow over time to include 3rd party web parts and extensions using the SharePoint Framework.

Real-Life Use Cases where SharePoint Spaces can be utilized:
We all know SharePoint Spaces provide Mixed Reality experience to our SharePoint intranet portal. It can be used in the following areas:
  • Virtual Tours - Tour of a New Building, Demo of  New Product Launch
  • Training - Training with 3D Models and 360° videos. Virtual Simulation is more affordable and can be repeated multiple times so that your employees have the practice they need to accomplish their work.
  • Learning beyond the classroom - Teachers can import visual lessons, visualizations, and videos (2D, 3D, and 360°) that support their lessons and create a powerfully engaging learning environment.
  • Onboarding Activities - SharePoint Spaces help new employees with their organizations and teammates more quickly by exploring the company and their colleagues via a virtual organizational chart. Also, 3-D office maps can help newcomers to get used with the new environment faster.

If you have any questions you can reach out our SharePoint Consulting team here.