Update Multiple Columns with One Button

[newgirlflow]

Hi, everyone!

I'm a beginner in PowerApps and I'm working on a project that would track the Delivery Receipt (DR) documents. Our process is that the DRs are first Printed in our Plant, then Passed to Sales, then Passed to Client. 

I made a SharePoint list where the DR references can be entered per row. The other columns showing the date of when it was printed, another date column for the date when it was passed to Sales, and another date column showing when it was passed to client. Then, I have a choice column showing 'Status', whether it has just been "Printed", "Sent to Sales", and "Sent to Client". So overall, I have these basic columns:

DR Reference	Client Number	Date Printed	Date Sent to Sales	Date Sent to Client	Status
123	50000001	Jan 1, 2021	Jan 3, 2021	Jan 5, 2021	Passed to Client
124	50000001	Jan 1, 2021			Printed

I made it this way since they would also like to download these info after, from the SharePoint list.

Anyway, the purpose of the app is to basically list down the DRs, filter accordingly, select which DR to update, and update a Date column and the Status column. So for example, if I were to update DR reference 124, I would update the 'Date Sent to Sales' column to whichever date I select and then update the 'Status' column to "Sent to Sales".  Then, the person from Sales who received the DR would update the "Date Sent to Client" date column and update the 'Status' column to "Sent to Client".

I have already set up my app, with the search boxes and a date dropdown for the user to filter the gallery view accordingly. The gallery view also already has a check box. 

My next step is setting up the button that would update those checked and update 2 columns (one of the 3 date columns and the status column). 

I have tried following a Youtube tutorial about this, but it only updates one column. So far, my check boxes already have the following formulas:

OnCheck

Collect(colUpdates,ThisItem)

OnUnCheck

Remove(colUpdates,ThisItem)

Then I tried updating one column for now for one button. The 'DropdownStatus' is a drop down for the user to select which status they want to be the new status for the selected DRs while the 'Sample Document Tracking 2' is the name of the SharePoint list.

UpdateIf(
    colUpdates,
    true,
    {Status:DropdownStatus.Selected});
Patch(
    'Sample Document Tracking 2',
    colUpdates)

 This one works, but again, it only updates one column, specifically the status column.

I made another button to update a specific column. The 'Date Sent to Sales Admin' is a date column.

UpdateIf(
    colUpdates,
    true,
    {'Date Sent to Sales': DateUpdateSentToSales.SelectedDate});
Patch(
    'Sample Document Tracking 2',
    colUpdates)

 again, this also works,  but it only updates one column per button.

How to incorporate in one button, but would update 2 columns in one click? 

[WarrenBelz]

Hi @newgirlflow ,

What are the Items of the gallery you have posted and are all fields connected to the data (they will be ThisItem.xxxx) - xxxx is data source field name.

[newgirlflow]

Hi, @WarrenBelz !

I'm not sure if I understand your question correctly but I will try to answer it.

The items in the gallery view are all from one SharePoint list, named 'Sample Document Tracking 2'. I simply had the columns from that SharePoint list show in the gallery view. 

[WarrenBelz]

Hi @newgirlflow ,

What I asked is important to find the problem. The Items of your gallery you find by selecting the gallery and then Items from the top-left drop-down. I also need to know the Text of any labels or Default of any inputs in the Gallery.

[newgirlflow]

Ohh okay, I think I'm getting to understand your question. Here is the Items of my gallery. The formula is mainly to filter. 

Filter(
    'Sample Document Tracking 2',
    StartsWith('Client Number',COMSearchBox.Text) &&
    StartsWith(Title, DRSearchBox.Text),
    Dropdown1.Selected.Value = "All" || Status.Value = Dropdown1.Selected.Value,
    'Delivery Date'>=DateFrom.SelectedDate && 'Delivery Date'<=DateTo.SelectedDate
)

The Delivery Date column, I wasn't able to mention it in my original post but it's just another date column that shows additional info for the DR.

When you say "I also need to know the Text of any labels or Default of any inputs in the Gallery.", I'm not sure if I understand it. But when I click on the gallery and choose Default in the dropdown found in the upper left, I don't have any formula there.

[WarrenBelz]

Thanks @newgirlflow ,

I am trying to eliminate possible causes - your gallery contains the entire record required, so the problem is not there, however it confirms a better way of doing this. Firstly, if you want to update a record in the collection, you can do this (assuming Status is a Choice column)

Patch(
   colUpdates,
   {ID:ThisItem.ID},
   {
      Status:
      {Value:DropdownStatus.Selected.Value}
   }
)

Now to add the Collection colUpdates to your list 'Sample Document Tracking 2' as new records

Collect(
   'Sample Document Tracking 2',
   colUpdates
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[newgirlflow]

Hi @WarrenBelz !

The first code you gave could be helpful since it updates the status column of the item (yes, 'Status' columns is a choice column). However, what I need is not to add the Collection to the SharePoint list.

What I need is how to combine in one button to do 2 things. After checking the boxes for the selected DRs, the button should:

- update the 'Status' column and

- update another column which is a date column based on a date picker 

[newgirlflow]

Hi, @WarrenBelz 

I meant something like this,

UpdateIf(
    colUpdates,
    true,
    {Status:DropdownStatus.Selected});
Patch(
    'Sample Document Tracking 2',
    colUpdates);
UpdateIf(
    colUpdates,
    true,
    {'Date Sent to Sales Admin': DateUpdateSentToSalesAd.SelectedDate});
Patch(
    'Sample Document Tracking 2',
    colUpdates)

in which the idea is when the user clicks the button, it will update 2 columns. I tried this, but it doesn't work, it only updates the status.

Maybe you could help me modify this formula?

[WarrenBelz]

Hi @newgirlflow , 

I steered you away from the Patch that relies on all the fields in the collection to match the list - I have never been able to get that to work reliably. Have a go at the "simple" way of patching both columns by referring to them. The syntax I gave you uses the ID (which is present in both) to patch the correct record.

[newgirlflow]

Hi, @WarrenBelz 

I tried the formula you provided, but it returns an error. 

This is what appears when I hover on the underlined.