Need help in developing Interview Evaluation form

[sunilbsrv2k-1]

Hi All,

I am trying to build an Interview evaluation form in Power app using the template available in MS Excel.

In the first case, want to develop the basic feature, with options (should be able to select one of these options in a and b):
a. Department: abc, xyz etc
b. Position: 1. Analyst,

                   2. Manager

                  3. Senior Manager

Note: Below questionnaire should change as per the above selection; these are all available in Excel template

c. Evaluation 1:

           1. Question 1: Yes/No/ NA

           2. 1. Question 2: Yes/No/ NA
            3. Etc.

d. Evaluation 2:

           1. Question 1: Yes/No/ NA

           2. 1. Question 2: Yes/No/ NA
            3. Etc.

e. 

Evaluation 2:

           1. Question 1: Yes/No/ NA

           2. 1. Question 2: Yes/No/ NA
            3. Etc.

Finally, these should be collected in some place and retrievable.

Could you please let me know, if this is possible and how to achieve this

Thanks and Regards

Sunil B S

[Jay2814 · Accepted solution]

Hi Sunil,

This is very possible; there are a variety of ways to accomplish this but for this example I will use SharePoint. The first step would be determining which datasource you want to use to store information. If you have access to SharePoint I recommend using a SharePoint list as a datasource to store information.

Here is a rough/quick guide on how to get started:

Creating Datasource

When creating a SharePoint list you will have a variety of column types that you can choose from. Judging based off of the fields that you provided, this is how I would create the SharePoint List.

• Department
  • Choice Field
• Position
  • Choice Field
    • Analyst
    • Manager
    • Senior Manager
• Evaluation Questions (This is just for storing the yes/no values. The questions will have to be labels in the datacards).
  • Choice
    • Yes
    • No

Connecting Datasource

Once you setup your datasource you can go into Power Apps and create a blank canvas app:

1. Select the Data button on the left action bar.
2. Select Add data
3. Search for SharePoint
4. Select SharePoint
5. Select connection
6. Connect to SharePoint site side panel will open on right-hand side
7. Search for the site where you created the SharePoint list
8. Select the List
9. Select Connect at the bottom

Add Form Control

1. From Insert action, select Edit Form
2. Connect Edit Form to data source by selecting the list you added to the Power App
3. The form will load with default fields
   1. Customize your form with the fields you created

Adding a submit button to the bottom of the form

1. Add a custom card to fields
2. Select custom card
3. Add button
4. On the OnSelect button enter: SubmitForm(Form1);

The information will be added to that data source for you to retrieve.

[sunilbsrv2k-1]

Hi Jay2814,

Thank you very much for your detailed explanation with steps.

I have followed all the steps and got through to creating the app.

However, I am now stuck at creating the column with drop down selection;

For Example, Position should have drop down with options Manager, Analyst etc... It is not happening.

Can you please help me on this.

Thanks,

Sunil 

[Jay2814]

Hi Sunil,

I will be delighted to help. Did you create the choice column in your SharePoint datasource? If so you should be able to add the field in your EditForm element. May you show a screenshot of your current Power App and SharePoint environment?