filter gallery list by checkbox and bulk update SharePoint list

(0) Share

Report

Posted on by shelleyb

193

Hello,

I'm in the process of creating an inventory app. I'm stuck on how to select items on the Gallery List using the checkbox function to filter the view and then bulk update Status by click Bulk Update button. So scenario would be select items that are being returned. Tick the check box to filter the gallery list and then click Return button to update status column to returned.

This is what I have under Items I'm assuming I'd need to add a layer to filter by CheckboxCanvas1 and then I'm at a loss what I need to enter on the button to Patch and change the status on the SharePoint List

Any help would be warmly welcomed 😊

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

turnerj3 2,039 on at

Like (0)

Report

@shelleyb ,
This is what I have done to make it work.
I made a collection based on checked gallery items.
Then patched to my list (Photos) based on ID
I patched a title because it is required and passed Complete to the Status column. If you have an input for status you can use that as well or a Checkbox.value
Change Photos to your list and the details between the { } to your info.

ClearCollect(colGallerySelects,Filter(Gallery3.AllItems,Checkbox1.Value=true));
ForAll(colGallerySelects, Patch(Photos,LookUp(Photos,ID=colGallerySelects[@ID]),{Title:TextInput4.Text,Status:"Complete"}))

Was this reply helpful? Yes No
shelleyb 193 on at

Like (0)

Report

Thanks @turnerj3 just what I need 😊

I'm getting 2 error messages (see below) unsure how to amend so its reads the record as text

Error seems to be because the Sharepoint column is a choice column tried changing to TEXT but it generated more errors on the rest of the app 😑

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report

What type of column is Status?
My bad didn’t see last paragraph. Are you using a drop-down to select the choice?

Was this reply helpful? Yes No
Verified answer

turnerj3 2,039 on at

Like (0)

Report

Try this for the Status:

Status: {Value: "YourValue"}

If you were using a drop-down tied to the choices column you would use:
Status: dropdown.Selected

Was this reply helpful? Yes No