Updating Column Value in Bulk

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
ikmalfikri 48 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
ikmalfikri 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Something like this,
Select period>submit and submit will update the column as the text above the submit

Was this reply helpful? Yes No
WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
ikmalfikri 48 on at

Like
a
(0)

Report
Copy link

Link copied!

yes...that works but the :
UpdateIf(ColTest,true,
{
Cell4
)
)
);
is the issue
I'm sorry i'm still new to this platform..

Was this reply helpful? Yes No
WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
ikmalfikri 48 on at

Like
a
(0)

Report
Copy link

Link copied!

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..

Was this reply helpful? Yes No
WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@ikmalfikri ,

I think we have a communication incapability . . .

Was this reply helpful? Yes No
ikmalfikri 48 on at

Like
a
(0)

Report
Copy link

Link copied!

I think so..I'm sorry about that..
If possible, could you kindly develop a sample and share to me?thanks

Was this reply helpful? Yes No