lookup a list and fetch a related column text based on a selection of another column selected by dropdown box

[Awad0367]

I have a  vendor list "leverantor"with 2 columns vendor name and organization number 

I Have a parent list for my invoice called rekvisition that has a lookup column ""LeverantörNamn" . I need to create a new field Column LevOrgNr in parent list  be populated with org number based on a selection of a leverantornamn "combobox "

in power app page create new invoice 

se bilder

[v-qiaqi-msft · Accepted solution]

Hi @Awad0367,

If you want to populate the LevOrgNr with organization number from leverantor based on leverantornamn Combo Box selected, you should define the one-to-one correspondence between the two columns, for example, if the leverantor is ALINGSAS BILDELAR, the organization number should be 1001, just as below:

So please input the corresponding organization number within the leverantor list, then you could populate the the LevOrgNr name(If it is a text column type) by setting a default property of the textinput control as below:

LookUp(Leverantor,Leverantor=ComboBox.Selected.Value).Organizationname

[Awad0367]

Thank you for your help, I did figure it out exact as you did but column name worked with Title instead for Leverantor. 

I have an issue with my invoice number variable that generate a number when a new invoice button at start is pressed. I need this number to decrement IF the new form is not submitted so that I do not consume that numeber in vain. Here is the variable 

Set(
varRkv;
First(
Filter(
'Rekvisition nummer';
ID =1
)
).Title
);;
UpdateIf(
'Rekvisition nummer';
ID = 1;
{
Title: Concatenate(
"RikvNo-";
Text(
Right(
varRkv;
5
) + 1
)
)
}
)

Se the image where the new number is generated