cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cooper01
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:

Collect(
    'Order Products',
    AddColumns(
        colRequestedItems,
        "cra00_requestedby",
        gblCurrentUserRecord,
        "cra00_order",
        locSelectedOrder.OrderID
    )
)

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?

10 REPLIES 10
Cooper01
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

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,166)