We are having some issue with displaying Combo box results in edit forms when using a Dataverse table. The goal is to be have a copy line form where a one field needs the value updated (Minus number) in the same table. The original idea was to have a Combo box that we use to look up the values in the table (Display form) and then have another Edit Form (New) with a Save button that will trigger a creation of a new entry into the table. The combo box lookup value will be what is displayed in the Display form and in the Edit Form(New) as default values.
The issue i am having is when i am attempting to use the same formulas that work for other apps to display my Combo selection of entries in the same table via an edit form. The below is the error details and suspect that it might be different data type due to most of my other apps being SharePoint List based data and not Dataverse tables. Please advise if the same functionality is able to happen and if anybody has an easy way to copy lines
The below is the error that i am receiving when using the below item for the Data driven table:
Combo box code that finds the values from the table successfully:
Filter(PCS,'MMS Unique Task Number')
Edit Form Item queries that do not return any values and gives the same error:
1:
LookUp(PCS,'MMS Unique Task Number' = ComboBox2.Selected.Value)
2:
First(Filter('PCS','MMS Unique Task Number' = ComboBox2.Selected.Value))
I am not sure on what to change or do i need to do something else to make this connection with my data table.
Any help would be greatly appreciated.
