Dialogue Cloud

Configuring Microsoft PowerApps to Change Skill Scores

This example shows you how you can use Microsoft PowerApps to sign in and out of Skill.

Prerequisites

Create PowerApp

  1. Navigate to https://web.powerapps.com

  2. Select Create and Canvas App from blank

  3. Insert Blank vertical

  4. Select a data source (if connection is not already created, then select New connection)

  5. Enter your UCC site url and Connect

  6. Choose SkillsPerAgent and Connect

  7. Change Layout to Title, Edit fields, Set Title to Skill, Set Display value to Value

  8. (Optional) Remove NextArrow

  9. If you want to filter the list to only show the logged in user, then you need to filter the data.
    Go to Advanced, change the value of Items to:

    Copy
    Formula
    Filter(SkillsPerAgent, EndsWith(Agent.Value, User().Email))
    Note: On some clients the ',' (comma) needs to be ';' (semi-colon).

  10. Select the item, insert two buttons and move them in position

  11. Add the following code to the Sign in icon (OnSelect)

    Copy
    Formula
    Patch(SkillsPerAgent,ThisItem,{Score: 100})
    Note: On some clients the ',' needs to be ';'.
  12. Add the following code to the Sign out icon (OnSelect)

    Copy
    Formula
    Patch(SkillsPerAgent,ThisItem,{Score: 0})
    Note: On some clients the ',' needs to be ';'.
  13. (Optional) Add to following code to the Sign in icon (Color)

    Copy
    Formula
    If(ThisItem.Score = 100, RGBA(141, 198, 63, 1), RGBA(166, 166, 166, 1))
  14. (Optional) Add to following code to the Sign out icon (Color)

    Copy
    Formula
    If(ThisItem.Score = 0, RGBA(168, 0, 0, 1), RGBA(166, 166, 166, 1))

Result

When following the steps, you will have the following result:

Optional Items

Use multiple prio levels

Introduction

Beside sign in and sign out, you can also use multiple buttons to set prio levels.

Example

Configure

  1. Add 3 buttons

    1. Prio 1

      1. Text = 100

      2. OnSelect:

        Copy
        Formula
        Patch(SkillsPerAgent,ThisItem,{Score: 100})
    2. Prio 2

      1. Text = 100

      2. OnSelect:

        Copy
        Formula
        Patch(SkillsPerAgent,ThisItem,{Score: 50})
    3. Sign out

      1. Text = Off

      2. OnSelect:

        Copy
        Formula
        Patch(SkillsPerAgent,ThisItem,{Score: 0})

Use prio sliders

Introduction

You can also use a slider to set prio.

Example

Configure

  1. Add Slider to item

  2. Add the following code to the Slider (Default)

    Copy
    Formula
    ThisItem.Score
  3. Add the following code to the Slider (OnChange)

    Copy
    Formula
    Patch(SkillsPerAgent,ThisItem,{Score: Slider2.Value})