Updating Column Value in Bulk

[ikmalfikri]

Hi,

I need assistance on this matter.

I want to make an option where the user can select a dropdown to select the column to update :
Eg, Jan,Feb,March....

So i make a combobox to allow multiple selection.

Now i want to make based on the selection on the combobox, it will update in bulk (patch) the column selected like

if user select jan and feb

the apps will update as such 'Jan':true,'Feb';true

Any idea on how to do this?preferably without using Power Automate

Thank you

[WarrenBelz]

Hi @ikmalfikri ,

Assuming you are writing back to a Text column, the Update of the Data Card would be 

Concat(
   ComboBoxName.SelectedItems,
   Value & ":true,"
)

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.

Visit my blog Practical Power Apps

[ikmalfikri]

I tried that but it seems like error;
UpdateIf(ColTest,true,
{
Set(Cell,Concat(
ComboBox1.SelectedItems,
Value & ":true,"
)
}
);
Patch(PeriodLock,ColTest);
Clear(ColTest)
or
UpdateIf(ColTest,true,
{

 Update
);
Patch(PeriodLock,ColTest);
Clear(ColTest)

Can you advise?thanks

[WarrenBelz]

@ikmalfikri ,

What is the name of the field you are trying to update and what type of field is it. Also what is the field name (and type) that has to match the combo box output?

[ikmalfikri]

Something like this,

Select period>submit and submit will update the column as the text above the submit

[WarrenBelz]

@ikmalfikri ,

If you are able to answer the questions I asked, I may be able to look at some code. Also my original post will produce exactly what you have in that label.

[ikmalfikri]

yes...that works but the :

UpdateIf(ColTest,true,
{
Cell4
)
)
);

is the issue

I'm sorry i'm still new to this platform..

[WarrenBelz]

@ikmalfikri ,

Yes - your UpdateIf code is not the correct structure and I honesty cannot work out your intentions from it. What I asked previously was 

What is the name of the field you are trying to update and what type of field is it. Also what is the field name (and type) that has to match the combo box output?

[ikmalfikri]

Field Name :
0 1 2 3 
The type is Yes/No 

Basically from the combobox, we select the field to be update eg 0/1/2and if we submit, it will update all selected field to true..

[WarrenBelz]

@ikmalfikri ,

I think we have a communication incapability  . . .