i want to desplay item from anather data user for the current user to creat new form

[safaayadi]

i want to desplay item from anather data user for the current user to creat new form

i have 2 data source "client" and "Liste Ticket Hotel" i want to get the value of (contrat Materiel)  of the current user from client list to creat new form in  my data source  "Liste Ticket Hotel" 

 this is my function : 

ClearCollect(MYCLIENT;ShowColumns(Client,"Mail","Etat"));

If((User().Email= ThisItem.'Mail') && (ThisItem.'Etat '),Choice[@'Client'].ContratMat_x00e9_riel )

any help ?

[v-yueyun-msft]

Hi , @safaayadi 

What's the data type of your [contrat Materiel] in your "Liste Ticket Hotel"?

And what's the data type of your [ContratMat_x00e9_riel] in your Client list? What dose the [Etat ] column to judge in your side?

Best Regards,

Yueyun Zhang

[safaayadi]

@v-yueyun-msft 

my data type is sharepoint list

ContratMat_x00e9_riel = contrat Materiel which is sharepoint list 

mail and etat column in client list 

and this list client is containe many client and each client is repeat in this list i use etat to get the new client 

i want to get this iteam in the form for each user to creat new  the form

[v-yueyun-msft]

Hi , @safaayadi 

According to your screenshot , the [contrat Materiel] is a column in your  Liste Ticket Hotel" list.

Dose the [contrat Materiel] is a mul-LookUp column in your list? And the lookup field is the [Etat] field in Client List?

And do you mean you want to show the [Etat] field in your Combo box selection and default select the Login users' [Etat]?

Best Regards,

Yueyun Zhang

[safaayadi]

hi,@v-yueyun-msft 

i have 2 data source :

• the [contrat Materiel] is a column in my  Liste" Ticket Hotel" and the column is type lookup  
• the [contrat Materiel] is a column in my  Liste" client"  and the column is type lookup==>2 list in 2 different site i want to get each 

[contrat Materiel] value from client list for the user connect to creat new form in  Liste Ticket Hotel

is that possible ?

[safaayadi]

hi,@v-yueyun-msft 

 [contrat Materiel] is LookUp column in my list client 

i want to show the [contrat Materiel] in my combobox 

[v-yueyun-msft]

Hi, @safaayadi 

If you just want to show the LookUp column , you can just use the code in Combo box - items property:

Choices([@TestList].LookUpColumnName)

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[safaayadi]

hi, @v-yueyun-msft 

i want to desplay the value that reside in the list client each user use use the (if user().email = Mail)  then my Combo box get the  [Contrat maintenance Logiciels] of that user  to creat new form in  hotel ticket list which is anather list