cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BoatrightIL
Level: Powered On

Help with Survey for a Needs Assessment APP

Hello everyone, I am new to power apps, and I am honestly wondering if I bit more than I can chew. 

 

I wanted to create an app for taking a staffing needs assessment survey to determine just how many of a particular position we need to hire for the upcoming school year.  Need it to do the following:

 

1. Have a selection of schools ( IE: Adams Academy, Bobby's Academy, Cayton Academy.)

2. Based on which school is selected, it opens a new slide that has the survey questions determining if a school needs particular roles filled.  (IE. Adams Academy is selected, and one of the questions are "Do you require art teachers for the 2017-2018 School Year?")

3. If yes, it automatically opens another slide to determine the number of positions (IE Text Type "Five Art Teachers"). If no, then no need to move forward. 

 

What would be the best method of populating this data and make it an app?( either in Excel or common data service?) Or am I a little too ambitious here?

 

Any help would be greatly appreciated. 

 

 

2 REPLIES 2
hpkeong
Level 10

Re: Help with Survey for a Needs Assessment APP

Hi

 

You are not ambitious but those are really possible.

So, you need to learn from the Learn.Documenation and start with you apps using/with:

- Sign-in with your username/password

- Connect to Excel in DropBox (the fastest so far) or CDS (buy Plan 20

 

Then

- Create Table in Excel or Entities in CDS

- As you wish to have Selections of Schools, Questions pertaining to Survey, Positions,... I would suggest that you

- Creae a 3 Tables (Excel) / 3 Entities (CDS)

   for:

    Schools,

    Questions and,

    Positions

 

Now, start to Create apps from Scratch or From CDS or Excel, to generate apps.

- Screen 1: Selection of School [please learn to use DropDown, with Distinct, etc.]

- Screen 2: Questions for survey and Navigate to another Screen 3, which has position to check

- for Screen 2: you can also use DropDown, and

- for Screen 3: you can use CheckBox

 

All the final actions can then be Collected (Temporarily) and then Permanently Saved into Excel or CDS in real time.

 

Use Gallery to view all your data, if you wish.

 

Hope this helps.

 

have a nice day.

hpkeong
BoatrightIL
Level: Powered On

Re: Help with Survey for a Needs Assessment APP

Okay, so this is what I have so far, but I am not sure what I am doing that isn't allowing it to flow correctly. Maybe it is how I organized my excel sheet or I'm missing a command somewhere.

 

So I have the screen with the drop down school selection.

 

a0c83c716567585985af241db49aaa96

It goes to the next screen which provides all the questions.

 

1d77a7ec061a5658a997f08e0567bbbd

 

Once selected, it brings up the following screen for a more detailed review to answer. 

 

bd704d76216d38435f7b7914e19aa20c

 

If the need is "Yes" then it navigates to the following screen where one can select the job req numbers.

 

4e17b8376692ce24377ec44a97c2c5eb

 

My problem is that i have it navigating back to the questions, and it is not pulling up a fresh new "yes" or "no" page and still contains the information selected before.

 

It likely it is a very easy fix, but again, this is all new to me.  How can I make it so that it prompts a new screen every time so that it can record the answers and I can collect them?

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,025)