Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Avoid current user to duplicate the registration

Hi All,


I have a sp list which will be updated by the form using canvas app.


Each entry will have Team including 5 team members. eg ,  ....

Now if any of the user from this entry comes and try to register it should check the current logged in user with the entry and if the user exists in the entry he should be navigated to "Already Registered" page , Else he should be navigated to "Home Page"

where he can continue to register as usual.


I have tried On start of App

If(IsBlank(LookUp('List name', User().Email ='Team Member 1 - Mail'.Email)),Navigate('Already Registered',ScreenTransition.Fade),Navigate('Home Screen',ScreenTransition.None))


Not sure what is going wrong here but the new user is also prompted to Already registered page. Even if he is not part of any entry.



Helper I
Helper I

Hey @Drrickryp ,


It worked like a charm Thanks a lot, Anyways if i want to compare all the Team members in the List with the current user so that no one from the team who are part of a team cannot be in any other team should i use Or function ? or AND function 


Set(UserEmail,User().Email); Collect(listname,'ListName'); If(!IsBlank(LookUp(listname, 'Team Member 1 - Employee Mail'.Email =UserEmail Or 'Team Member 2 - Employee Mail'.Email =UserEmail)),Navigate('Already Registered',ScreenTransition.Fade),Navigate('Home Screen',ScreenTransition.None))


does it make sense.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,560)