How to save a lookup column from another list to use it in current list

[Gul123]

I have a sharepoint list and it’s name services, it contain’s the service name(single line of text) and the assigned to person’s(person or group).

I have another list which it’s name submit request

and it contains a field of request type which is a lookup from the first list as a drop down menu (service name) , assigned to column and reassigned column(person).

I created 3 forms in power apps, one for submitting the request, the second for viewing the request by the admin and the last for updating the request by admin.

I will not put the assigned field to be shown in the form of submitting the request , so the user will not see the assigned to persons.but what i want to do is when the user chooses the request type which is lookup from the second list, and when he submits the request by clicking on the button, i want the value of assigned to column from the second list to be save in the assigned to column in the first list depending on the request type that he chooses.

Then using power automation I want to send email to the assigned to persons( when new item created).

the assigned to persons will be admin, one of them will open the request and will reassign it to another one using view form and update form.Then the email will be send to the re-assigned person. How to do all of this? I am new in power apps and power automation. Please tell me step by step

[RandyHayes]

@Gul123 

You can achieve this by placing the logic in your formula for the Update property of the datacard for the 'Assign To' column in your EditForm.  

There you can use the logic to look at the request type and then assign the Assign to directly at that point.

You will need to be a little clearer on the column you are using, is it truly a Lookup to another list, or a Person column?  Usually this is done with a Person column, which is why I want to be sure.

I hope this is helpful for you.

[Gul123]

Please let me know step by step. from 1 week i am trying to reply on this topic but it's returning an error. That's why I created a new topic. It's important for me to know how to return 3 managers from list1 to list 2 depending on user selection in list2. I am new in this field.

I have 2 sharepoint lists.

Request type list which containts:

1. Type of service: single line of text

2. Required files: single line of text

3. Assigned To(3 managers): person or group

Help Desk list which contains(custom list):
1.Type of service(which is a lookup column from the Request type list)

2.priority: choices

3.Assigned to column(should be return from Request type list depending on user selection for Type of service)

4.Description: multi line of text

5. Required files: single line of text

When the user add a new item in power app, he will choose the Type of service (which is a drop down menu from Request Type list) and according to this, the required files will be return  as single line of text from the first list depending on the type of service selection).
The client user who want to submit a request should not be able to see the assigned to managers in the creating ticket form, However depending on user selection in Type of service it should save the Assigned to persons from Request type list in Assigned to column in the Help desk list. So when the user submits his request,  in sharepoint when we open the Help desk list, we can see the assigned to persons and when the user clicks on submit button the flow should send the email to Assigned to persons that are saved in Help desk list.

What I did for selection drop down: in Items: I put the following function:
SortByColumns('Request Type'.Type of service,"Type of service")

to Return the value of Required files from the first list depending on user selection I put the following function:
" Required files"& LookUp('Request Type',Title = Dropdown2.Selected.Title,Required files)
But now how to save the person and group filed in the second list after choosing the type of service to be use in the flow to send email?

[RandyHayes]

@Gul123 

Sorry for delay...trying to catch up on all the posts.  Are you still experiencing issues that you need help with?

[Gul123]

yes still I need answer for my question