Filter an edit Form on results from a Combo box used on another screen not working

[matty2000]

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. 

[v-mengmli-msft]

Hi @matty2000 ,

There are columns in Dataverse that have different data than SharePoint.

What is type of 'MMS Unique Task Number' column and Items of ComboBox2?

Best regards,

Rimmon

[matty2000]

Hi Rimmon,

Thanks for your Fast response and below is some further details around the field within the Power App and from the data verse table. 

Combo box:

Edit form:

Table: 

Happy to discuss further,

With Thanks,

Matty

[v-mengmli-msft · Accepted solution]

Hi @matty2000 ,

I think this is because you are using modern combo box, the modern combo box doesn't support ".Value" sometimes, so please try this.

LookUp(PCS,'MMS Unique Task Number' = ComboBox2.Selected.'MMS Unique Task Number')

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept it as a solution.😀

Best regards,

Rimmon