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

(1) Share

Report

Posted on by CU12111019-0

110

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 ?

power apps form.PNG power apps problem.PNG

Categories:

Building flows

All responses (7)

Answers (0)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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
CU12111019-0 110 on at

Like
a
(1)

Report
Copy link

Link copied!

@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 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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
CU12111019-0 110 on at

Like
a
(1)

Report
Copy link

Link copied!
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 ?
CU12111019-0 110 on at

Like
a
(1)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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
CU12111019-0 110 on at

Like
a
(1)

Report
Copy link

Link copied!

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