Unanswered

Passing a value from label to combo box using a variable

(0) Share

Report

Posted on by AshleyTaylor

Hi All,

I am trying to pass a value from a label in an edit form to a combobox in a different edit form. I have set a variable that is trigged by a new buttons OnSelect Set(label1.Text) and in the combo box DefaultSelectedItem Table({Value:Var}).

This works as expected however when I click my save button OnSelect SubmitForm('Form1'). I get the following error message in the combo box datacard 'Value must be a data entity record'

Can anyone advise?

Thanks

Categories:

Building Power Apps

error value1.jpg

I have the same question (0)

All responses (8)

Answers (1)

AshleyTaylor on at

Like (0)

Report

Can anyone point me in the right direction?

Was this reply helpful? Yes No
AshleyTaylor on at

Like (0)

Report

I would really appreciate any help with this

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @AshleyTaylor ,

It seems that the Combo box is used for a LookUp column, if this is the case, please try below formula:

LookUp(ComboBoxItems, Value = var)

ComboBoxItems means the formula Choices(...) in Items of the Combo box.

Best regards,

Was this reply helpful? Yes No
AshleyTaylor on at

Like (0)

Report
Thanks for your reply,

The combo box is indeed used for a lookup column
(AssemblySpec Lookup is in tblToolsForAssemblies with has a many to one relationship with tblAssemblies which contains column AssembliesPK - This is the value I need passing to the combo box)

I have just tried:
LookUp(tblAssemblies,Value = Var)

but I am getting 'incompatible types for comparison, these types can't be compared error, text'

Please see attached error and ER Diagram

Thanks

error combo.jpg

ER Diagram Update...

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @AshleyTaylor ,

I was thinking you are using SharePoint lists as data sources. But it seems not the case. Could you please confirm this? What data source are you using for the form?

Best regards,

Was this reply helpful? Yes No
AshleyTaylor on at

Like (0)

Report

Sorry, I forgot to specify all my tables/relationships are in Dataverse.

Please see form data sources in attached diagram

Thanks

DataSources.pdf

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @AshleyTaylor ,

OK, then DefaultSelectedItems of the Combo box:

LookUp(tblAssemblies, AssembliesPK = Var)

Actually, there is no need to use the variable, you can use the AssembliesPKlabel.Text directly:

LookUp(tblAssemblies, AssembliesPK = AssembliesPKlabel.Text)

Best regards,

Was this reply helpful? Yes No
AshleyTaylor on at

Like (0)

Report

Perfect, Thanks!

Was this reply helpful? Yes No