Patch working fine until wrapped in ForAll

[cfidler72]

I have created a collection of records that I am trying to patch to a dataverse table.  

The following Patch code works fine:

Patch(
        'Job Cards',
        Defaults('Job Cards'),
        {'Connected To': "kk"}
)

However, when I wrap the patch into a ForAll command like below I start having problems

ForAll(
    colAddedDrives,
    Patch(
        'Job Cards',
        Defaults('Job Cards'),
        {'Connected To': "kk"}
    )
)

 The colAddedDrives contains the records with the data I wish to patch but I'm receiving an error saying that "The specified column 'Connected To' does not exist.  Below is a snap shot of the Job Cards table 

I have also tried changing the reference from 'Connected To' to the schema name but receiving the same errors.

I'm also receiving errors saying that the ForAll and Patch functions have invalid arguments, which I believe all relates back to the specified column error.

What am I missing?

[PowerGirl]

Do you have the same column name in colAddedDrives? Maybe you can try using RenameColumn(colAddedDrives,”Connected To”, “CnctdTo”) in the patch to see if it helps. If both tables have the same column name, sometimes in the ForAll is not clear which one it is using. 

[cfidler72]

I checked the colAddedDrives collection and discovered that the collection contained a number of fields with the table schema names.  I tried renaming the relevant column as suggested but still receiving the same error that the "Connected To" column doesn't exist

[PowerGirl]

Is the column name ‘Connected To’ appearing in the suggested column names when you write the patch function? try to erase it, start writing it again and choose it from the suggested list. 

If everything else seems ok, sometimes closing the app and opening it again solves the problem. 

[cfidler72]

The only suggested names appearing are actually from the collection colAddedDrives and not from the dataverse table.

I've tried closing the app and reopening it, but still not fixing the problem unfortunately.

[PowerGirl]

Does your table ‘Job Cards’ have an identity column (with unique ID values for each row) ?

[cfidler72]

No it doesn't.  It has a unique identifier in "Job Card No" but there could be a number of line items associated with a separate job card

[tareqrosul]

ForAll(
    colAddedDrives,
    Patch(
        'Job Cards',
        Defaults('Job Cards'),
        {'Connected To': ThisRecord.ColumnNsmeOfTheCollectionThatYouWantToPatch}
    )
)

If you need further help paste the Collection code 
If my response was beneficial to you, feel free to leave a 👍 symbol. If it effectively resolved your query, please signify with a 👍 and mark it as the Solution, assisting other community members in locating this helpful information more readily.

[cfidler72 · Accepted solution]

I ended up starting from scratch again and seem to have resolved it.

The problem appears to be that most of the column names needed to be the schema name.  I say most as some, such as lookup columns, would only accept the display name.  Took a lot of rewriting of code and trial and error, but the problem now seems to have been resolved