Unanswered

Update form field with a choices from other list

(0) Share

Report

Posted on by RoberthCB

I have 2 SharePoint List: Company and Contact list. The company has Title (Code for company C1,C2,C3, etc) and Company Name, Contact list has Id Company (C1, C2) for relation with Company List.

I to need and i have a problem:

1. Display in the form Contact the Drop Down with all names from the company Name from company List

2. When submit the form y to need saved the Id company in the contact list (IdCompany), but i do not how to do that

1. I can show the company in the Drop Down.

a. Look the image:

b. Default Value: If(VarNuevoRegistro,"NEW COMPANY",LookUp(CompaniaCRM, Title = GalContactos.Selected.IdCompania,NombreCompania))

2. But I can not save the form with the choices from the list, i need save the code, how to do that?

Thanks a lot.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try this

Set(varSelectedCompanyCode, LookUp(Company, CompanyName = Dropdown1.Selected.Value, Title));
SubmitForm(FormName);

This in the Default value of id field

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
varSelectedCompanyCode

Was this reply helpful? Yes No
RoberthCB on at

Like (0)

Report
Copy link

Link copied!

I obtain this error:

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RoberthCB，

Could you please tell me that:

1). If the 'Id Company' column in your Contact list is LookUp type?

2). How you set the Items property of the IdCompany dropdown?

3). What exactly you want to save to Contact list, IdCompany or corresponding company name based on IdCompany?

4). Why you set a TextInput and a Dropdown box at a single data card?

I think 'Id Company' column in your Contact list is not a LookUp type, there is just relationship between contact list and company list, right?

Actually, I don't understand much more about your scenario, most of the users will use the LookUp column to relate two lists.

By the way, you could not set a variable into the Default property of the dropdown

Was this reply helpful? Yes No
RoberthCB on at

Like (0)

Report
Copy link

Link copied!

Hi, here my answer to your questions.
1). If the 'Id Company' column in your Contact list is LookUp type?, The field in the contact list is IdCompnay that equal to Title in the Company list.

2). How you set the Items property of the IdCompany dropdown?, with this instruction:
In Items: Distinct(Sort(Company,NameCompany),NameCompany)
In default: If(VarNuevoRegistro,"NEW COMPANY",LookUp(Company Title = GalContactos.Selected.IdCompany,NombreCompany))
3). What exactly you want to save to Contact list, IdCompany or corresponding company name based on IdCompany?: I need to save IdCompany
4). Why you set a TextInput and a Dropdown box at a single data card?

Regards

Was this reply helpful? Yes No