Showing results for 
Search instead for 
Did you mean: 
Continued Contributor
Continued Contributor

Fields not resolving when patching multiple records at once

I have a collection of items I'd like to patch to a Dataverse table. I am trying to patch them all at once instead of using ForEach to increase performance. This is what the statement looks like:

    'Order Products',

The collection already includes a column with the schema name of another column in the Order Products table, cra00_productname which is a text field. cra00_requestedby is a lookup field to User and cra00_order is text field. Requested By and Order columns are supposed to be the same for all items being patched, which is why I'm using AddColumns instead of adding it to the collection.


The warning I am getting is in the AddColumns section. It says "The specified column 'cra00_requestedby' does not exist. The column with the most similar name is 'Requested By'". cra00_requestedby is the schema/internal name of the table in CDS while Requested By is the display name. I also tried to change it to use the display names in AddColumns, as referenced in the warning message. This just changes the error message to "The specified column 'Requested By' does not exist. The column with the most similar name is 'Requested By'". I can get similar message to surface if I delete the Requested By portion on the Order column.


The strange thing is that since this is just a warning, I tried it anyway. The Order will patch as expected but the Requested By will not, that column is just blank for the new records. There are no errors when clicking the button through the studio.


Anyone know what the actual issue is here?

Continued Contributor
Continued Contributor

Thanks again @v-jefferni . The blog gave me enough background to understand the logic in the solution. Really appreciate your help and patience with this!

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,485)