I have a simple PowerApp that is essentially a form that the user fills out that collects information from 15 different fields, free text and drop downs. Each data card corresponds to a column in my SharePoint list. The idea is simple, each time the form is completed and submitted, a new row is created in SharePoint.
Working in conjunction with the PowerApp above, I have another app that serves as a work queue.
The work queue has logic that only shows certain Work Order #s depending on the selections made on the first input form above. The queue is then sorted by Work Order # and then by created time. The users have the ability to select multiple records, typically grabbing all from the same Work Order # that is present.
Gallery Code
Items:
SortByColumns(
Filter('Daily Picking Data - NEW DRAFT','Material Needed'.Value = "Yes" && Fulfillment.Value = "Review Needed" && Cancellation.Value = Blank()),
"WO_x0023_", Descending, "Created", Descending)
Once the user decides which records/tasks they are going to work on by checking the boxes, they then click the arrow to advance to the next screen.
Checkbox Code
OnCheck:
Collect(SelectedWO,ThisItem)
OnUncheck:
Remove(SelectedWO, LookUp(SelectedWO, ID = WorkqueueGallery_1.Selected.ID))
Arrow Code
OnSelect: Navigate(Screen1)
Once the user gets to Screen 1, they will see a data table containing specific information from the data collection that was created.
The user then uses the information from this screen to complete some manual tasks. I am using a data table format so that the user can print the screen and have a cleaner view, especially when many records may be selected.
My questions now… how can I bulk update only the entries that populate on this table in the SharePoint data source, not the collection? Within my SharePoint List I have two other fields that I would like this bulk update to impact, which ultimately drive the work queue previously mentioned:
- Fulfiller Initials
- Fulfillment
In my previous version of the app the user was taken to a page for each individual record where they would look at the data, perform their task and then complete the following by entering their initials, choosing Fulfillment = “Complete” and then hitting submit.
Once they submit, they are taken back to the work queue page and the Work Order # drops off the list and they keep working through the queue.
Having said all that, how can I replicate the functionality above, except that it will bulk update all the selected records in the SharePoint data source, that landed in my temporary collection and were shown in the data table?
