Example configuration Microsoft PowerApps for Change Skill Scores

Introduction

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:

    Filter(SkillsPerAgent, EndsWith(Agent.Value, User().Email))


  10. Select the item, insert two buttons and move them in position
  11. Add the following code to the Sign in icon (OnSelect)

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

    Note On some clients the ',' needs to be ';'.

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

    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)

    If(Score = 100, RGBA(141, 198, 63, 1), RGBA(166, 166, 166, 1))

  14. (Optional) Add to following code to the Sign out icon (Color)

    If(Score = 100, 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:

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

    2. Prio 2
      1. Text = 100
      2. OnSelect:

        Patch(SkillsPerAgent,ThisItem,{Score: 50})

    3. Sign out
      1. Text = Off
      2. OnSelect:

        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)

    ThisItem.Score

  3. Add the following code to the Slider (OnChange)

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