Answered

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

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Awad0367 61 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No