how to map users from login screen to another sharepoint list

[MAYURIV]

Hi,

In my project, I had no login screen initially. Only forms were there. Based on forms filled, we were updating the response of form in another sharepoint list1.In this list, we were updating user name by ThisItem.'Created By'.DisplayName. This list was updating  O365 user of powerapp.

Now instead of updating the sharepoint list 1 response sheet with O365 powerapp user name, we want to update with user created in login screen.

I have created a login screen from one sharepoint list2 having list of users and password.

I want to update these user names from login screen to  sharepoint list1.

Please help.

[WarrenBelz · Accepted solution]

Hi @MAYURIV ,

I do something similar with audit logs of user's actions. You just need a second list and write a new record to it (example with one field called Activity)

Patch(
   YourAuditListName,
   Defaults(YourAuditListName),
   {Activity:"LoggedIn"}
)

You then have Created and Created by fields to show who did it and when.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[WarrenBelz]

Hi @MAYURIV ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[MAYURIV]

I am not getting the result.

ForAll(Gallery_Check_List_Details.AllItems,

Patch(AOA_FT_Response,Defaults(AOA_FT_Response),
{Equipment_Name:Var_Eqp_Selected_Cond,
Check_List:Lbl_CheckPoint.Text,
Check_Sr_N:lbl_Sino.Text,
Response_Value:If(Radio4.Visible,Radio4.SelectedText.Value,Txt_Ip_Data.Text),
Actions_Taken:If(Chk_Box_Action_1.Value,"* " &Chk_Box_Action_1.Text)&If(Chk_Box_Action_2.Value," * "& Chk_Box_Action_2.Text)&If(Chk_Box_Action_3.Value," * " & Chk_Box_Action_3.Text)&If(Chk_Box_Action_4.Value," * " & Chk_Box_Action_4.Text)&If(Chk_Box_Action_5.Value," * " & Chk_Box_Action_5.Text)&If(Chk_Box_Action_6.Value," * " & Chk_Box_Action_6.Text),
Start_Time:Var_Start_Time,
End_Time:Now()
})
);

This is the initial code where we are able to read powerapps user but now we want to read user from login screen created in powerapps.

Please help.

[MAYURIV]

I am not getting the result.

ForAll(Gallery_Check_List_Details.AllItems,

Patch(AOA_FT_Response,Defaults(AOA_FT_Response),
{Equipment_Name:Var_Eqp_Selected_Cond,
Check_List:Lbl_CheckPoint.Text,
Check_Sr_N:lbl_Sino.Text,
Response_Value:If(Radio4.Visible,Radio4.SelectedText.Value,Txt_Ip_Data.Text),
Actions_Taken:If(Chk_Box_Action_1.Value,"* " &Chk_Box_Action_1.Text)&If(Chk_Box_Action_2.Value," * "& Chk_Box_Action_2.Text)&If(Chk_Box_Action_3.Value," * " & Chk_Box_Action_3.Text)&If(Chk_Box_Action_4.Value," * " & Chk_Box_Action_4.Text)&If(Chk_Box_Action_5.Value," * " & Chk_Box_Action_5.Text)&If(Chk_Box_Action_6.Value," * " & Chk_Box_Action_6.Text),
Start_Time:Var_Start_Time,
End_Time:Now()
})
);

This is the initial code where we are able to read powerapps user but now we want to read user from login screen created in powerapps.

Please help.

[WarrenBelz]

@MAYURIV ,

Sorry totally lost here - your code posted seems to have no relationship to what I suggested. What exactly do you mean by but now we want to read user from login screen created in powerapps. Where do you want to write this data?

[SUPRIYAK]

Sir, actually our response sheet is showing record of powerapp user login in 'created by' column , but we want to show record of user login page of the app (which has seperate sharpoint list of all the users using the app). As per your suggestion, we have added one more coulmn in response list with name 'user' and added in patch function with textinput. But still we are unable to get result.

patch code:

ForAll(Gallery_Check_List_Details.AllItems,

Patch(AOA_FT_Response,Defaults(AOA_FT_Response),
{field_Equipment_Name:Var_Eqp_Selected_Cond,
field_Check_List:Lbl_CheckPoint.Text,
Check_Sr_N:lbl_Sino.Text,
field_Response_Value:If(Radio4.Visible,Radio4.SelectedText.Value,Txt_Ip_Data.Text),
field_Actions_Taken:If(Chk_Box_Action_1.Value,"* " &Chk_Box_Action_1.Text)&If(Chk_Box_Action_2.Value," * "& Chk_Box_Action_2.Text)&If(Chk_Box_Action_3.Value," * " & Chk_Box_Action_3.Text)&If(Chk_Box_Action_4.Value," * " & Chk_Box_Action_4.Text)&If(Chk_Box_Action_5.Value," * " & Chk_Box_Action_5.Text)&If(Chk_Box_Action_6.Value," * " & Chk_Box_Action_6.Text),
field_Start_Time:Var_Start_Time,
field_End_Time:Now(),
USER:TextInput3
})
);

[WarrenBelz · Accepted solution]

@SUPRIYAK @MAYURIV ,

I seem to be dealing with 2 users here? If TextInput3 contains the user's name, you need to refer to the control output as below

ForAll(
   Gallery_Check_List_Details.AllItems,
   Patch(
      AOA_FT_Response,
      Defaults(AOA_FT_Response),
      {
         Equipment_Name:Var_Eqp_Selected_Cond,
         Check_List:Lbl_CheckPoint.Text,
         Check_Sr_N:lbl_Sino.Text,
         Response_Value:
         If(
            Radio4.Visible,
            Radio4.SelectedText.Value,
            Txt_Ip_Data.Text
         ),
         Actions_Taken:
         If(Chk_Box_Action_1.Value," * " & Chk_Box_Action_1.Text) &
         If(Chk_Box_Action_2.Value," * " & Chk_Box_Action_2.Text) &
         If(Chk_Box_Action_3.Value," * " & Chk_Box_Action_3.Text) & 
         If(Chk_Box_Action_4.Value," * " & Chk_Box_Action_4.Text) & 
         If(Chk_Box_Action_5.Value," * " & Chk_Box_Action_5.Text) & 
         If(Chk_Box_Action_6.Value," * " & Chk_Box_Action_6.Text),
         Start_Time:Var_Start_Time, 
         End_Time:Now(),
         USER: TextInput3.Text
      }
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[SUPRIYAK]

Thanks sir, its working now.

And, yes we both are working in same project thats why i replied in MAYURIV post.

I really appreciate your quick response everytime. 🙂

[WarrenBelz]

Hi @SUPRIYAK ,

So this is solved now?