Additional Details when User logins for first time

(1) Share

Report

Posted on by Sidhant_02

986

Hi everyone,
I have implemented the login functionality in my Canvas App using SharePoint list as DB which is:

In this I am checking if the user exists in the DB and have entered correct information then only they can login and the dashboard screen is shown, else Incorrect details page is displayed.
But now what I want to do is if the user is logging in the application for the first time then instead of navigating the user to Home Dashboard which is :

I want to display a page (like a form) where user needs to fill some additional details like current address, emergency contact number, age. The flow that I want is given below:
Expected Flow
So as shown above if a user logins in to the app or if the have not filled in the details then the Additional Details page will be shown, and all the fields are mandatory (so they cannot submit keeping it blank). Else if the user has filled all the details then they should be navigated to Home dashboard.

So if a user wants to use the application so they need to register first and after registration is done then if they login they should be shown the additional details page, after the details are filled they are navigated to Home. On Home screen at the top-bar there will be a button, on its on-click the additional details should be shown.

For the additional details: I was thinking of creating another SharePoint list which stores the details (like emergency contact number, address and when the user clicks on the button on home dashboard additional details for the logged in {like if sam is logged in } then only his details should be shown not everyone's

Login Screen submit button expression:

SharePoint List used to user details (Login List)

I have created a new SharePoint List named Additional Details: (with the three fields for now: Title=FirstName, Last Name, Address {Multi Line}

Additional Details Page:

So let's say there is a user named: Sam. He logins in to the app (the check is done if he has entered correct details) then my doubts were:
1. How to check if that user has entered the additional details or not. If they have not then only they should be navigated to the Additional Details page else Home screen because if a user fills the additional details logs off and logs in then if the additional details page is shown (it will create redundancy).

2. User: Sam has not filled the additional details then he is navigated to the Additional data page. He (Sam) fills the details and they are saved in the new SharePoint list named (AdditionalDetails_1) after that he is navigated to the Home Screen. Here on a button provided to view the details how to show only the additional details for the current user (not through Microsoft 365 Account connector, as here the user is different). I wanted to show the details based on the logged in user (Here the additional details should be shown for Sam only)

Do share your inputs on how to implement this functionality in Power Apps.
@timl , @Ramole , @KeithAtherton , @Pstork1 , @v-jefferni (If you guys can have a look and suggest how to do it, it will be helpful).

Regards,
Sidhant

Categories:

Building Power Apps

image.png

I have the same question (0)

All responses (16)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: Additional Details when User logins for first time

In the list where you are storing the user authentication information add the extra fields that you want to collect. When a user logs in check to see if that information is blank. If it is send them to the page to gather the additional information. It will be blank when they login for the first time and will continue to be blank if they don't supply it.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Re: Additional Details when User logins for first time

Hi @Pstork1 ,
Could you please mention the steps (from the above information). I am storing the details of user credentials in another SharePointList which is named as Login List.
As you have mentioned I have added some additional fields (for checking failed attempts), and I have posted my query on the forum as well, so could you please have a look at that as well?
Link: (For my other query)
Track Failed Login Attempts

Regards,
Sidhant.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Re: Additional Details when User logins for first time

I was thinking of creating a variable which stores the username (title) of the user who is logging in the application and if that user has not filled the details then they must be shown the Additional Details page and after that Home screen
So I tried this (but have some issues):

Some of my queries how to store the username in a variable (here varAdditionalDetails) which is entered by the user in Login screen. Based on that perform a check if the user has filled the Additional Details or not. If they have not then show the Additional Details page, else Home screen.

(I had created the varAdditionalDetails variable OnStart, but I guess it is not correct)

Do share your input on how to implement this functionality in Power Apps.
@timl , @Ramole , @KeithAtherton , @v-jefferni,@AshishJaiswal (If you guys can have a look and suggest how to do it, it will be helpful).
Regards,
Sidhant.

Was this reply helpful? Yes No
Aapok on at

Like (1)

Report
Re: Additional Details when User logins for first time

There are some errors in your formula: Your 2nd LookUp is missing a field to check against TextInput1.Text, and you are giving 4 arguments to your first If statement.

You can try something like this:
If( !IsBlank( LookUp( 'Login List', Title = TextInput1.Text And Password = TextINput2.Text ).Title ), //User Exists If( IsBlank( LookUp( AdditionalDetails_1, Title? = TextInput1.Text ) ), //Additional Details is Blank Navigate(AdditionalDetails), //Additional Details is not Blank Navigate(Home) ), //User does not exist / incorrect combination Navigate('Incorrect Details') );
It's free typed so there might be some syntax errors, but the logic should work.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Re: Additional Details when User logins for first time

Hi @Aapok ,
Thanks for the expression, I did use it but was for the second If condition it was displaying this:
It was expecting a boolean value and then this:
Could you please let me know what's wrong?

Regards,
Sidhant.

Was this reply helpful? Yes No
Aapok on at

Like (1)

Report

Re: Additional Details when User logins for first time

Hi.

Replace "Title?" with the field you want to compare TextInput1.Text with, I wasn't sure what the name of the field in your SP list was. Also as I mentioned, the code was free typed, so double check that all parenthesis are closed properly.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Re: Additional Details when User logins for first time

Okay, I will have a look. So the AdditionalDetails page looks like this:
And the SharePointList for it is like:
So here the Title=FirstName
And in the second if Statement I wanted to check if the user (like Sam is logging in) (all the credentials like username and Password are stored in another SharePoint List named Login List) so if that user has entered the additional details or not, if not then show the additional details page:
Login List (which stores all the credential information)
So here the Title= username (which I want to use in the second if block)

And now I have made the changes as per the SharePoint list (username=title so used it in the 2nd if block)
But now after checking the openings

And when I removed the extra parenthesis there was no error, but the last parenthesis was considered for the second if block and first if block had no ending

Resolved it: (I had given a ',' after Home that's why the first If-block was not closed😉
So this is right?
Regards,
Sidhant

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Re: Additional Details when User logins for first time

Hi @Aapok ,
Only thing that is remaining is after user logins in-> Enter's the details -> Goes to Home screen
For the Logged in user (here let's say Sam) on the top bar I was going to place a button and on-click of it the logged in user should be able to view the details-> And if they want to they can edit and Save them. SO could you just help me with it?

So on Submit button of the Additional Details page:
How should the details be saved in the list and then only for the user logged
(say we have 4 users: Jim, Raj, Rahul, Sam) and Sam logins fills the details -> goes to Home screen and clicks on an icon which should show only his additional details not for other users which he can edit and save if he wants to. (what should be the steps?)

Regards,
Sidhant

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Re: Additional Details when User logins for first time

Hi @Aapok and @Pstork1 ,
Just had thought user can have any username its not mandatory that they need to use First name as Username, they can different username (like Sam Johnson can enter username as Sam22) so in this case the expression that we are using (2nd if block where we are checking with username field in the Login list DB {which has username and password}), so in that case if a user fills the additional details and logs off and logs in then they will be asked again to fill the details which should not happen.
So is there way we can solve it?.

Regards,
Sidhant.

Was this reply helpful? Yes No
Aapok on at

Like (0)

Report

Re: Additional Details when User logins for first time

Hi.

This shouldn't be the case with the code I provided, can you show me the code you use to initialize the 'Additional Details' list item.

Was this reply helpful? Yes No