Answered

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

I have the same question (0)

All responses (8)

Answers (1)

Sort by

AshleyTaylor on at

Like (0)

Report
Copy link

Link copied!

Can anyone point me in the right direction?

Was this reply helpful? Yes No
AshleyTaylor on at

Like (0)

Report
Copy link

Link copied!

I would really appreciate any help with this

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

Like (0)

Report
Copy link

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

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

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

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Like (0)

Report
Copy link

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

Link copied!

Perfect, Thanks!

Was this reply helpful? Yes No