Create an employee recognition form

[ohadWebbing]

Hi,

I would like to create 2 employee appreciation forms. The forms need to include the following:

1. Choosing a name from all the employees in the company (all are office 365 users). The list of employees needs to be updated automatically (as employees join/ leave the company). first form with an option to choose only 1 employee, and 2nd form with an option to choose any number of employees. 
2. once the form is submitted, the request is sent for approval to the manager of the employee who sent the request and to the manager of the employee who was chosen in the form.

Today I use a simple form and update the list of employees manually in the form + power automation for the approval process. 

I would appreciate help in building this form

Thanks

[JR-BejeweledOne · Accepted solution]

For #1 use the Office365Users connector as the items property of a ComboBox, set like this, it will only show you accounts that are enabled.

Filter(Office365Users.SearchUser({searchTerm: ComboBoxEmployeeInfo.SearchText}), AccountEnabled=true)

For #2 consider using the Office365Users connector like this to retrieve the manager information.

For the first form, set a couple labels with the manager information.  The labels can have their visible property set to false so they don't appear on the screen anywhere.

Like this:

Office365Users.ManagerV2(ComboBoxX.Selected.mail).displayName

And

Office365Users.ManagerV2(ComboBoxX.Selected.mail).mail

For the second form you will do something similar.   You will need to use a collection to capture the information for multiple users.   Like this:

If(
  CountRows(ComboBoxX.SelectedItems) >0,
    Collect(CollName,
        ForAll(ComboxBoxX.SelectedItems As _item,
          {
            Name: Office365Users.ManagerV2(_item.mail).displayName
            Email: Office365Users.ManagerV2(_item.mail).mail
          }
         )
      )
  )

You can then call a Flow from your Power App and use the information from your labels and collection to provide the manager information for approvals.  You may need 2 Flows to handle the single approval and the multiple approval for form 2.

You can look at this for passing the collection information to Flow.

https://powerobjects.com/powerapps/send-a-collection-from-powerapps-to-flow/