Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to save person field from another list depending on user selection lookup field

I am new in power apps. Please I need a step by step explanation.
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?


I am using the following function in update to return one record for each selection:
It's working fine. But How Can I add for each selection 3 persons?
OR if it is not possible, How Can I add a group rather than person?

{ Claims:"i:0#.f|membership|",
{ Claims:"i:0#.f|membership|",


Frequent Visitor

No answer on my question 😟

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,238)