Collecting answers to a survey with an app and saving answers to Sharepoint

[Anonymous]

I'm not an IT person and may be misunderstanding what PowerApps was intended for, but I have created a PowerApp that is ten screens, each with a different question and a set of radio buttons that the user can select to respond to the question.  Upon completion, how do I connect it to our Sharepoint site so that the answers populate a new list - or is that even possible?  Also, the final result of the ten questions creates a number or a score - can I get the PowerApp to use the resulting score to reference an excel file in Sharepoint to return a message to the respondent of the questionaire?  Thanks for any help you might be able to provide.

[murali]

Here are some suggestions:

1. You can declare each field as a SP "Choice" field and provide a set of choices right there. The Connecting to Sharepoint article will tell you how to hook up this SP list and how you can create an app from scratch. You can create forms to represent questions 1 and 2 on one screen, 3 and 4 on another screen and so on. On the last screen you can do something like

Patch(Survey, Defaults(Survey), Form1.Updates, Form2.Updates, ....)

2. Alternatively, you can declare the fields as "Text" on SP and follow the above mentioned article. You should then replace the input text boxes with Radio buttons and hook up the formulas accordingly. This however means the choices are going to be hardcoded in the app. You could alternatively create SP lists for every question and then bring in each list and set the Radiobutton.Items to those list values. There are a lot of possibilities.

Once done, you can use the same formula to create a new item in the list.

To answer your other question about getting an excel file in SP, there is currently not a way to pull in excel files on SP. You could however create a list to map the score-to-string value and then bring in the list (follow the above mentioned article for pulling in SP lists). Once done, it's just a simple matter of filtering the list rows given a score.

For instance, if the list contained two columns: Score and Message, you can do LookUp(Map, Score = CalculatedScore, Message).Message to retrieve the message corresponding to a score.

Hope this helps.

Thanks

Murali

[Anonymous]

Hello, 

I am having the same problem but trying to connect the results to an existing excel (empty) in OneDrive. I have created an excel with a Table and connected the file through connections, so I have it now on the list on connections as Table1, store in OneDrive. Now I want the fields of my survey that the user can input to be stored directly on that excel. The fields are a mixture of text-input and list-box with multiple choice. 

I want that for each new respondent to the survey a new line is created in the excel and that captures the inputs when the user clicks on the button "next". Is this possible? If not possible through excel in oneDrive, what would be the best option? 

Thanks in advance,