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!
Solved! Go to 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,
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,
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
29 | |
24 | |
19 | |
12 | |
11 |