Answered

How to check bulk data in checkbox gallery, edit the checked data and patch the data into sharepoint

(0) Share

Report

Posted on by PTDamia

I found a few videos in youtube and google about this but still can't figure out why i can't patch the data in sharepoint.

Problem no.1

I have this sharepoint called as "Receiving CKD K7". In this case, when I want to bulk check the check box of the data in gallery, the pillar, subpillar and storage bin will appear the same value. this is what it looks like in powerapps.

but unfortunately, when i select the data that i want to choose the pillar, sub pillar and storage location, it only appear in one data only like the first picture.

The code is already messy. Its been two weeks i try to solve but still can't solve the problem. I found a few people solve the problem but they didn't provide the full code which is hard for me as a beginner to understand the code.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PTDamia ,

if you would like to modify the three Choices column values for selected Gallery items, please try below formula OnSelect of the Submit button:

ForAll(Filter(YourGallery.AllItems, Checkbox.Value = true) As Checked, Patch('Receiving CKD K7', LookUp('Receiving CKD K7', ID = Checked.ID), {Pillar: PillarCombobox.Selected, 'Sub Pillar': SubPillarCombobox.Selected, 'Storage Location': StorageLocationCombobox.Selected})

Best regards,

Was this reply helpful? Yes No
PTDamia 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi thank you for the solution but seems like it still didn't work 😞 there's no error in the code but it did not patch the data in powerapps. I will provide my code one by one.

Oncheck checkbox= Collect(colselected,ThisItem)
OnUncheck checkbox= Remove(colselected,ThisItem)
Default= varallcheck

I also create checkbox for select all
Oncheck= Set(varallcheck,true)
Onuncheck= Set(varallcheck,false)
Default= varallcheck

In Gallery Items
SortByColumns(
Filter(
'Receiving CKD K7',
DataCardValue14_12.Text in Invoice,
Lot = Dropdown2_6.SelectedText.Value,
Categoryy=Dropdown2_7.SelectedText.Value

),
"Invoice",
If(
SortDescending1,
Descending,
Ascending
)
)

Im sorry but its's kinda messy. In gallery, i need to filter based on what i choose in the drop down (Lot number and Category)
For now, Im using RF Scanner to scan QR Barcode and i use separater technique to get invoice number based on the QR Code. so i hope you understand the senario here.

This is the code you gave me. really appreciate it but still doesn't work. :((

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PTDamia ,

Sorry, I was about to reply but mistakenly accepted it as solution, I have cancelled this operation.

For your case, you have a collection to include the checked invoices, that's great. So, you can use the collection in ForAll function instead of the Filter. Please make sure the Items of Combo boxes are set to the Choices columns of the list:

Choices('Receiving CKD K7'.Pillar)
Choices('Receiving CKD K7'.Pillar)
Choices('Receiving CKD K7'.'Storage Location')

To test the Gallery checkboxes before submitting, you can select the collection name in formula bar and see if current table is correct.

Patch function will be the followings:

ForAll(colselected As tmp, Patch('Receiving CKD K7', LookUp('Receiving CKD K7', ID = tmp.ID), {Pillar: Combobox1_1.Selected, 'Sub Pillar': Combobox2.Selected, 'Storage Location': Combobox3_1.Selected})

Best regards,

Was this reply helpful? Yes No
PTDamia 59 on at

Like
a
(0)

Report
Copy link

Link copied!

OMGG !! Its work nowww ! 😭 Thank you soo much !

But i faced another problem in combobox.
So my subpillar option is based on what i choose in pillar.
This is else if function that i created before (pic attached).
i don't have any problem for pillar since i put the value in sharepoint colum

How can i put this else if function if i use choices function? Is there any solution for this senario either in powerapps or sharepoint?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PTDamia ,

So, you have not set the Sub Pillar Choices column using all the selections, just let users add values manually? That's not a good idea, because add new selections from in PowerApps cannot affect in SharePoint column settings. Please try and set Items of Sub pillar Combo box to the original If statement (note that there are duplicate values please remove them), and in SharePoint if the sub pillar column is Choices set it with proper selections.

If you think it's too cumbersome to add so many selections, you can change the column to be single line of text, then just need to modify the Patch function (Items of sub pillar combo box is the previous If statement):

ForAll(colselected As tmp, Patch('Receiving CKD K7', LookUp('Receiving CKD K7', ID = tmp.ID), {Pillar: Combobox1_1.Selected, 'Sub Pillar': Combobox2.Selected.Value, 'Storage Location': Combobox3_1.Selected})

Best regards,

Was this reply helpful? Yes No
PTDamia 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Solved em! Really appreciate your help! Thank you soo muchh !! 💌

Was this reply helpful? Yes No