Unable to patch bulk items in a Dataverse table from PowerApps application

[ChavdarD]

Hello everyone,

I'm trying to update multiple items in a Dataverse table but ForAll + Patch is updating only the currently selected row in a gallery. I have a gallery showing the items that need to be updated and I've put text input controls to collect the data that needs to be updated but when I press the button it updates only the last selected item and not all of them.

Here is what I'm using to bulk update all items:

ForAll(
           galProtocolItems.AllItems,
           Patch(
                     'Protocol Items',
                     {'Protocol Item': GUID(lblProtocolId.Text)},
                     {
                                  'AFE NO': txtAFE.Text,
                                  'Word Order NO': txtWorkOrder.Text,
                                  'Purchase Requisition No': txtPurchReqNo.Text
                     }
           )
);

Could you please advise what I need to change in my formula so it updates all items in the gallery?

Thanks

[StalinPonnusamy]

Hi @ChavdarD 

Please try this.

ForAll(
           galProtocolItems.AllItems,
           Patch(
                     'Protocol Items',
                     LookUp('Protocol Items', 'Protocol Item' = GUID(lblProtocolId.Text)),
                     {
                                  'AFE NO': txtAFE.Text,
                                  'Word Order NO': txtWorkOrder.Text,
                                  'Purchase Requisition No': txtPurchReqNo.Text
                     }
           )
);

Thanks,
Stalin

[StalinPonnusamy]

Hi @ChavdarD 

Here is my sample. Here I used with statement to avoid delegation warning when converting GUID.

ForAll(
    Gallery2.AllItems,
    With(
        {CurrentID: GUID(ContactGUID.Text)},
        Patch(
            Contacts,
            LookUp(
                Contacts,
                Contact = CurrentID
            ),
            {Email: TextInput2.Text}
        )
    )
);

Thanks,
Stalin - Learn To Illuminate

[ChavdarD]

Hi @StalinPonnusamy ,

Thank you for the quick response. I tried both suggestions as below...

ForAll(
    galProtocolItems.AllItems,
    Patch(
        'Protocol Items',
        LookUp(
            'Protocol Items',
            'Protocol Item' = GUID(lblProtocolId.Text)
        ),
        {
            'AFE NO': txtAFE.Text,
            'Word Order NO': txtWorkOrder.Text,
            'Purchase Requisition No': txtPurchReqNo.Text
        }
    )
)

ForAll(
    galProtocolItems.AllItems,
    With(
        {'Protocol Item': GUID(lblProtocolId.Text)},
        Patch(
            'Protocol Items',
            LookUp(
                'Protocol Items',
                'Protocol Item' = GUID(lblProtocolId.Text)
            ),
            {
                'AFE NO': txtAFE.Text,
                'Word Order NO': txtWorkOrder.Text,
                'Purchase Requisition No': txtPurchReqNo.Text
            }
        )
    )
)

...but it is still updating only the selected item in the gallery

Here are some screenshots of the process.

The initial state of the gallery

Before clicking the Save button

After clicking Save button

I checked the lblProductId label controls in the gallery and they have the GUID of each item. I also replaced the lblProductId in the formula with ThisRecord.'Protocol Item' but then when I click the Save button it updates all items with the values entered only in the selected item.

[StalinPonnusamy]

I tried to update multiple and works

In general, it updates only one row when column name conflicts. So we used to rename the column in the gallery before using it. But our case, we are not using referencing any column from the gallery.

Few troubleshoot items

• Get the count of the Gallery

CountRows(galProtocolItems.AllItems)

• Updated a bit

ForAll(
    galProtocolItems.AllItems,
    With(
        {ProtocolId: GUID(ThisRecord.lblProtocolId.Text)},
        Patch(
            'Protocol Items',
            LookUp(
                'Protocol Items',
                'Protocol Item' = ProtocolId
            ),
            {
                'AFE NO': txtAFE.Text,
                'Word Order NO': txtWorkOrder.Text,
                'Purchase Requisition No': txtPurchReqNo.Text
            }
        )
    )
)

[StalinPonnusamy]

Hi @ChavdarD 

Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate