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

Get Back the filed person of other SharePoint List



I need your help
I am making a PowerApps with a connection to two sharepoint lists.
List 1 for entering a new contract
List 2 where the contract numbers are stored + the sales assistant in person fields.
I can retrieve the Client Name and Code Client from the second sharepoint list, but I can't retrieve the Sales Assistant field.
I would like to have the commercial assistant (Assistante Commercial) if contract number X is selected in order to make my flow


Seconde liste SharePoint :


This is the field with the format text



Could you please help me?

Thank you in advance



Super User
Super User


You can do this with a simple lookup to the other list.

LookUp(list2, criteriaToTheOtherRecord, 'Assistante Commercial').DisplayName

This will give you the display name of that person in the other list. say you already are getting the Name and Code of the other record, so the reality is, if you are getting that, then you are already getting the information you need, so you can just reference that.


What are your formulas on those dropdowns/comboboxes?  If they are getting the full record, then you can use that.


Example, if the Items property of the first dropdown (I'll call it ddClientName for this example) is something like list2 then, you can change the formula above that I suggest, to:

  ddClientName.Selected.'Assistante Commercial'.DisplayName


I hope this is helpful for you.

Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Hello @RandyHayes ,

Thank you for your answer.
This is my formula for the field "Code Client" it is self-completing in relation to the client name (Nom Client)field



Filter('Clients et AC contrats';'Nom client'=ddClient.SelectedText.Value)



In Items I tried with your formula like this



Filter('Clients et AC contrats';ddClient.Selected.'Assistante commerciale'.DisplayName)



and it doesen't work



Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,608)