September 3, 2020

Power of AI in Power Apps – Enhance your Business Capabilities with AI using Power Platform AI Builder (Webinar)

Overview:

AI refers to the simulation of human intelligence in the Business Applications. With the help of AI, we can automate so many business processes without any human interactions. 

With Power Platform AI Builder, we can utilize AI capabilities inside our Power Apps and Power Automate (MS Flow). Today, we are covering several real-time use cases and scenarios in order to see the power of AI in Power Apps. Please check the full video session of webinar, covering the followings:

Chapters of the session:

  • Overview of AI 
  • Overview of Power Platform AI Builder
    • Custom AI Model
    • Pre-Built AI Model
  • Real-life use case and scenarios where we can use Object Detection AI Model
  • Real-life use case and scenarios where we can use Form Processing AI Model
  • Real-life use case and scenarios where we can use Prediction AI Model
  • Real-life use case and scenarios where we can use Category Classification AI Model
  • Real-life use case and scenarios where we can use Entity Extraction AI Model
The session is more focused for Business Users. Here, we have covered all custom AI models available in AI Builder.

Recording of the live session:


Conclusion:

This is the Power of AI in Power Apps which can be utilized with the help of AI Builder in Power Platform. Happy PowerApping!!!

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

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.