Need help in developing Interview Evaluation form

(0) Share

Report

Posted on by 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.

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Jay2814 33 on at

Like
a
(1)

Report
Copy link

Link copied!
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:
Select the Data button on the left action bar.
Select Add data
Search for SharePoint
Select SharePoint
Select connection
Connect to SharePoint site side panel will open on right-hand side
Search for the site where you created the SharePoint list
Select the List
Select Connect at the bottom
Add Form Control
From Insert action, select Edit Form
Connect Edit Form to data source by selecting the list you added to the Power App
The form will load with default fields
Customize your form with the fields you created
Adding a submit button to the bottom of the form
Add a custom card to fields
Select custom card
Add button
On the OnSelect button enter: SubmitForm(Form1);

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

Was this reply helpful? Yes No
sunilbsrv2k-1 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Jay2814 33 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No