cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Englishweb Post Patron
Post Patron

Building a Quiz from Excel

Hello

Sorry if this is a really stupid question but,

If I use data in an excel file on Onedrive to build a Quiz App, do all users of that app need access to the excel file? I don't want the students to have access the answers!! What do other people do in this case?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Bulding a Quiz from Excel

Hi @Englishweb 

No, it's not a stupid question 🙂

In answer to your question, yes, all users of the app need access to the Excel file.

With an Excel data source, you can import your spreadsheet as static data through the View > Data sources menu. This way, your users won't have direct access to the spreadsheet and won't be able to see the answers. The disadvantage is that you'd need to republish your app each time your questions change.

Another method is to store the answers outside of the app and to use Flow or some other external process to score your answers outside of PowerApps. However, this method would involve more work.

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Bulding a Quiz from Excel

Hi @Englishweb 

No, it's not a stupid question 🙂

In answer to your question, yes, all users of the app need access to the Excel file.

With an Excel data source, you can import your spreadsheet as static data through the View > Data sources menu. This way, your users won't have direct access to the spreadsheet and won't be able to see the answers. The disadvantage is that you'd need to republish your app each time your questions change.

Another method is to store the answers outside of the app and to use Flow or some other external process to score your answers outside of PowerApps. However, this method would involve more work.

View solution in original post

Englishweb Post Patron
Post Patron

Re: Bulding a Quiz from Excel

@timl 

Thanks for your reply. I think I'll go for the static data through the View data sources menu, as republishing the app is very quick and straightforward. Perhaps a SP list would be a better option than an Excel file for the quiz data?

Super User
Super User

Re: Bulding a Quiz from Excel

Hi @Englishweb 

Glad to be of help. I think if you need to frequently change your questions and answers, SharePoint is possibly a better option. However, you would have the same problem in that the end users could connect to the SharePoint list outside your app and see the answers. Therefore, there would be some work involved in hiding/securing the list from users.

 

Englishweb Post Patron
Post Patron

Re: Building a Quiz from Excel

@timl 

Thanks for the info, could you explain how I could hide/secure the questions and answers from users please?

I would like to use Powerapps (rather than Microsoft forms) for building tests, due to the import restriction in Microsoft forms. 

Englishweb Post Patron
Post Patron

Re: Building a Quiz from Excel

@timl 

Just an idea! Are collections a secure way to hold question/answer data?

What about importing questions from a datasource into a Collection, for use in the App? Would this restrict user access to the questions/answers?

Super User
Super User

Re: Building a Quiz from Excel

Hi @Englishweb 

The problem with collections is that provide in-memory storage. When a user closes an app, the contents of a collection will be cleared. To populate a collection from a data source when the app, the user would still need access to the source data. Therefore, the problem still remains that user can view the answers from the source data.

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,368)