SubmitForm with lookupvalue gives error 'Value must be a data entity record' using CDS

[ThomasVDS]

Hi,

I want to create a new record which contains lookupvalues using the submitform formula.

I use CDS as data source.

I get the error 'Value must be a data entity record' for the lookupvalue (combo box).

On top of the screen I get: 'an entry is required or has invalid value'

How can I solve this?

Thank you!

[v-xida-msft · Accepted solution]

Hi @ThomasVDS ,

Could you please share more details about the formula you typed within the Items property of the Training ID ComboBox?

Based on the issue that you mentioned, I have made a test on my side. Please make sure the Items property of the Training ID ComboBox is set to following formula as below:

Choices(YourEntityName.'Training ID')          /* <-- 'Training ID' represents the LookUp field in your CDS Entity */

Note: The 'Traning ID' represents the Display name of your LookUp filed rather than logic name (e.g. crba2_TaskLists_Task) of your LookUp filed.

If the issue still exists, please consider re-generate a new app based on your CDS Entity, then try above solution again, check if the issue is solved.

Best regards,

[ThomasVDS]

@v-xida-msftThank you very much! It works now!