cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Imade
Helper I
Helper I

Get Back the filed person of other SharePoint List

Hello,

 

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 :

Imade_0-1615979431551.png


This is the field with the format text

Imade_1-1615979473648.png

 

Could you please help me?


Thank you in advance

Imade.

 

2 REPLIES 2
RandyHayes
Super User
Super User

@Imade 

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.

 

Now...you 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

Imade_1-1615993286462.png

 

Helpful resources

Announcements
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)