Unanswered

Survey App - One-Time access per user

(0) Share

Report

Posted on by Paul1896

Hello,

I've created a Survey app and it works so far quite good. As a next improvement I would like to limit the access per user so that only each user can fill out the survey one time.

Is there any OOTB solution for something like that? Would be great to get some input.

Thank you very much!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Nirav Raval (Akira28) 153 Moderator on at

Like (1)

Report

Hi Paul1896 ,

As far as I know there is no direct OOTB feature to limit the survey responses per user in PowerApps but however may be you can implement using custom logic with user email checks. 🤞

If this post solved your issue, clicking 'Does this answer your question' will help others discover the solution and close the topic. If you found it helpful, a Like would be awesome!

Regards,
Nirav J Raval (Akira28)

Was this reply helpful? Yes No
Suggested answer

Kenobi 71 on at

Like (1)

Report

If the survey it not anonymous, you can save the User().Email upon submission to a SP list, then on App Onstart you can check if the user has completed the survey or not.

In the form OnSuccess you can put something like this:

Patch(ListOfUsersCompletedTheSurvey, Defaults(ListOfUsersCompletedTheSurvey), {Email : User().Email})

Then add this to the OnStart property:

Set(vCompleted, If(IsBlank(LookUp(ListOfUsersCompletedTheSurvey, Title = User().Email)),false, true));

If(vCompleted, /Show page telling them they already completed/, /Show Survey questions/)

Note that all users who will be populating the survey should have read access to the SP list in order
for this to work, which might introduce some issues if the data is sensitive.

Alternatively, you can add and remove members from O365 groups you created to check access and that will not require
them to have direct access:
Office365Groups.AddMemberToGroup
Office365Groups.RemoveMemberFromGroup

Was this reply helpful? Yes No
Paul1896 32 on at

Like (0)

Report

Thanks for your feedback! Okay my dats source and destination is Dataverse that I missed to mention in my initial post.

So I could iterate over the responses table and check if a colleague already exists in the "Responses" based on the internal fields "Created by" or/and "Modified by".

Is there way to get the Given & Family name when the user starts the survey app and check it against the mentioned table? And based on that result the survey will stat or not.

Was this reply helpful? Yes No
Kenobi 71 on at

Like (1)

Report

Given & Family names are not necessarily unique as there can be more than one John Smith, i suggest you avoid referencing that.

Was this reply helpful? Yes No
Paul1896 32 on at

Like (0)

Report

Oh, yeah. That was a kind of stupid question :D

But then let's modify my last question a little bit:

Is there way to get the mail adress when the user starts the survey app and check it against the mentioned table? And based on that result the survey will stat or not.

Was this reply helpful? Yes No
Verified answer

Paul1896 32 on at

Like (0)

Report

Thank you very much for all your answers they helped me a lot to find the solution for my problem.

Finally I've set the StartScreen Property with following formula:

If(!IsBlank(LookUp(Responses,'Created By'.'Full Name'=User().FullName)),Error_Screen,Home_Screen)

Was this reply helpful? Yes No