How to fulfill multi-select edit function at galleryscreen?

[Dennis_Qiang]

Please see my attachment first. Thank you!

I want the function like that first create a buttom at galleryscreen to enable multi-select function.

And When I select the item I want to edit, ,then click another buttom for submit.

At that time the selected item In_Status column will change from "Wait For Confirm" to "Warehousing success" automatically.

At present, my way of modifying the In_Status column is to select an item and then enter the editform for this item to change it, as shown in the gif. Does POWERAPPS support the functions I described? How can the function of multi-select modification be realized? Thank you.

B&R

Dennis

[v-bofeng-msft · Accepted solution]

Hi @Dennis_Qiang :

Do you want to use checkbox to batch modify records?

Coud you tell me:

• What is your data source? Is it SharePoint list?
• What is In_Status's date type?

I assume the the data source is a SP list and In_Status is Choice type.

The point is to add one more column to store the value of check box,I've made a test for your reference:

My data source(List A):

In_Status-Choice(do not allow mutiple choices)

Checkbox-Yes/No

1\Add a check box

OnCheck:

Set(visible,true) /*visible is my custom variable*/

OnUncheck:

Set(visible,false)

2\Add a gallery

Item:

'list A'

3\Add a check box into this gallery:

OnCheck:

Patch('List A',ThisItem,{CheckBox:true})

OnUncheck:

Patch('List A',ThisItem,{CheckBox:false})

Default:

ThisItem.CheckBox

Visible:

visible /*visible is my custom variable*/

4\Add a button:

OnSelect:

UpdateIf('List A',CheckBox,{In_Status:{Value:"Warehousing success"},CheckBox:false});

In addition,if In_Status is text type,just set the button's OnSelect property to:

UpdateIf('List A',CheckBox,{In_Status:"Warehousing success",CheckBox:false});

Best Regards,

Bof

[Dennis_Qiang]

Thank you for your reply!!!! I can implement this function!!!!

[Dennis_Qiang]

Hi @v-bofeng-msft 

How can this multi-select change function implement for the update to another list?

For example, if i have list A and list B. i want to create multi-select change function for List A galleryscreen. Follow you method, i can fulfill the function to change In_Status. But i also want when the In_Status change to "Warehousing success" and the same time, List B Quantity column can be update at the same time. ( Quantity(List B) = Quantity(List A) + Quantity(List B) ) according with the same Material Code match row.

Thank you!

Dennis