On Premises

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://make.powerapps.com

  2. Select Create and Blank app

  3. Select Blank canvas app and hit Create

  4. Give the app a Name and select Phone layout and hit Create

  5. Select Create a gallery

  6. Select a data source (SharePoint)

  7. Enter or select your UCC site url and Connect

  8. Choose SkillsPerAgent and Connect

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

  10. 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).

  11. (Optional) Delete NextArrow

  12. (Optional) Delete Rectangle

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

    Proceed to Program the Icons

  14. To program the behavior of the buttons Add the following code to the Sign in icon (OnSelect)

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

    Note

    On some clients the ',' (comma) needs to be ';' (semi-colon).

  15. Add the following code to the Sign out icon (OnSelect)

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

    Note

    On some clients the ',' (comma) needs to be ';' (semi-colon).

  16. (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))
  17. (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 level buttons

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})