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
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:
I hope this is helpful for you.
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