Bulk update AND Bulk Create

[imranamikhan]

Hi everyone,

Does anyone know if it possible to Bulk create and Bulk update a SharePoint list with one button/one execution?

I have the following code working in the Gallery for single records. This will either create an item or update an item if the item already exists:

If(CountRows(Filter(DB_MarketFeedback, CustomerID = ThisItem.Customer)) > 0,

Patch(

    DB_MarketFeedback,

    LookUp(DB_MarketFeedback,CustomerID=ThisItem.Customer),

    {

        Title: Dropdown_Status.SelectedText.Value,

        Comment: TextInput_Comment.Text

        }),

Patch(

    DB_MarketFeedback,

    Defaults(DB_MarketFeedback),

    {

        Title: Dropdown_Status.SelectedText.Value,

        Comment: TextInput_Comment.Text,

        CustomerID: ThisItem.Customer

        }))

I have following working to update all items in the Gallery:

ForAll(
    Gallery1.AllItems,
    Patch(
        DB_MarketFeedback,
        LookUp(
            DB_MarketFeedback,
            CustomerID = Customer
        ),
        {
            Validation_Status: Dropdown_Status.SelectedText.Value,
            Comment: TextInput_Comment.Text
        }
    )
)

And I have the following working to create items in the Gallery:

ForAll(
    Gallery1.AllItems,
        Patch(
        DB_MarketFeedback,
        Defaults(DB_MarketFeedback),
        {
            Title: Dropdown_Status.SelectedText.Value,
            Comment: TextInput_Comment.Text,
            CustomerID: Customer
        }
    )
)

Any thoughts would be appreciated.

Best regards,

Ami

[flugaoveltem]

Hello @imranamikhan 

The Gallery control does not support multi-selection, I think you can add a Checkbox control on your gallery, update OnSelect property with: 
Collect(Selected,ThisItem)

That will create a collection with all selected items of the gallery, use UpdateIf to change the values then submit the changes with Forall and Patch. 
Take a look in this article
https://sachinbansal.blog/2018/08/06/powerapp-cds-multi-select-items-in-gallery-using-checkbox-bulk-...

[v-xiaochen-msft · Accepted solution]

Hi @imranamikhan ,

Could you tell me:

• What’s the Items property of your gallery control?

I assume:

1. The Items property of the gallery control is a single column table.
2. “Customer” column is the only column in the table.
3. When the record exists, modify the value of the “Validation_Status” column and the value of the “Comment” column.
4. When the record does not exist, create a new record. Fill in the value of Tilte column, the value of Comment column and the value of CustomerID column.

If my assumptions are correct, the point is to use the If() function to determine whether there is an existing record.

If so, modify the existing record. If not, create a new record.

I've made a test for your reference:

1\ This is my list “DB_MarketFeedback”. There are some test records in it .

2\ Add a gallery control and set its Items property to:

Table({Customer:1},{Customer:2},{Customer:3},{Customer:4},{Customer:5})

3\ Add a dropdown control “Dropdown_Status” and set its Items property to:

Table({Test:"Test1"},{Test:"Test2"})

4\ Add a Textinput control “TextInput_Comment” .

5\ Add a button control and set its onselect property to:

ForAll(

    Gallery1.AllItems,

    If(

        CountRows(

            Filter(

                DB_MarketFeedback,

                CustomerID = Customer

            )

        ) > 0,

        Patch(

            DB_MarketFeedback,

            LookUp(

                DB_MarketFeedback,

                CustomerID = Customer

            ),

            {

                ' Validation_Status': Dropdown_Status.SelectedText.Value,

                Comment: TextInput_Comment.Text

            }

        ),

        Patch(

            DB_MarketFeedback,

            Defaults(DB_MarketFeedback),

            {

                Title: Dropdown_Status.SelectedText.Value,

                Comment: TextInput_Comment.Text,

                CustomerID: Customer

            }

        )

    )

)

6\ The result is as follows:

Best Regards,

Wearsky

[imranamikhan]

Thank you very much @v-xiaochen-msft. I was not clear on combining create and update in one execution and this is perfect.