How exactly to update a collection?

(0) Share

Report

Posted on by PytByt

943

Hi all,

I need to update my collection after its being edited.

This is the formula i'm using right now:
UpdateIf(FormColl, Gallery1.Selected.'Service Order Id' = FormColl.SO_Number,
{SO_Number: TextInput1.Text,
AssignedEngineer: TextInput2.Text,
Description:TextInput3.Text,
SiteName: TextInput4.Text,
ActualEngineer: Dropdown2.Selected.Value,
AssignedDate: TextInput6.Text,
ActualDate: DatePickerAct.SelectedDate + Time(Value(HourPickerAct.Selected.Value), Value(MinutePickerAct.Selected.Value), 0),
Visit: TextInput7.Text,
Status: "Saved Local",
Question1: Question1.Text,
Respond1: Respond1.Selected.Value,
Remarks1: Remarks1.Text,
Question2: Question2.Text,
Respond2: Respond2.Selected.Value,
Remarks2: Remarks2.Text,
Question3: Question3.Text,
Respond3: Respond3.Selected.Value,
Remarks3: Remarks3.Text,
Question4: Question4.Text,
Respond4: Respond4.Selected.Value,
Remarks4: Remarks4.Text
});

I dont't know what is wrong,

Please help.

Regards,

pytbyt

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

PavanKumar 479 on at

Like (1)

Report
Copy link

Link copied!

HI, There are multiple ways you can update in powerapps
1. Updateif - if you want to update one or more values (but not the entire record)
2. Update or Patch - if you want to update the whole record.

try using Patch once and see if the issue still persists and let me know.

Regards,
Pavan Kumar Garlapati

Was this reply helpful? Yes No
PytByt 943 on at

Like (0)

Report
Copy link

Link copied!

Hi @PavanKumar

Thanks for the reply,

Can i get a sneak peek for using those update & updateif function in real case similiar like me?
That'll really help.

Thanks,
pytbyt

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @PytByt ,
UpdateIf is used to update one/one fields that meet the formula.
For example:
table:formula:
UpdateIf( IceCream, Quantity > 175, { Quantity: Quantity + 10 } )
result:

Using this formula will only change the Quantity value of 200 and 300, not other fields.

I suggest you use Patch function.
What's more, FormColl.SO_Number represents a table.
The formula needs a field.
Try this:
Patch(FormColl, Gallery1.Selected.'Service Order Id' = SO_Number, {SO_Number: TextInput1.Text, AssignedEngineer: TextInput2.Text, Description:TextInput3.Text, SiteName: TextInput4.Text, ActualEngineer: Dropdown2.Selected.Value, AssignedDate: TextInput6.Text, ActualDate: DatePickerAct.SelectedDate + Time(Value(HourPickerAct.Selected.Value), Value(MinutePickerAct.Selected.Value), 0), Visit: TextInput7.Text, Status: "Saved Local", Question1: Question1.Text, Respond1: Respond1.Selected.Value, Remarks1: Remarks1.Text, Question2: Question2.Text, Respond2: Respond2.Selected.Value, Remarks2: Remarks2.Text, Question3: Question3.Text, Respond3: Respond3.Selected.Value, Remarks3: Remarks3.Text, Question4: Question4.Text, Respond4: Respond4.Selected.Value, Remarks4: Remarks4.Text });
Here are doc about patch, update, updateif for your reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-update-updateif
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
PytByt 943 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft

Thank you very much for your reply and explaination.
I will try your solution and get back to you again later.

Regards,
pytbyt

Was this reply helpful? Yes No
PytByt 943 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft

I'm back with error: Invalid Argument type.

The things is, i want to update 2 collection on the same time. So i use 1 single button, and i put this formula on its OnSelect Property:

Patch(HeaderColl, GalleryCDS.Selected.'Service Order Id' = SO_Number,
{SO_Number: TextInput1.Text,
AssignedEngineer: TextInput2.Text,
Description:TextInput3.Text, SiteName: TextInput4.Text,
ActualEngineer: Dropdown2.Selected.Value,
AssignedDate: TextInput6.Text,
ActualDate: DatePickerAct.SelectedDate + Time(Value(HourPickerAct.Selected.Value), Value(MinutePickerAct.Selected.Value), 0),
Visit: TextInput7.Text, Status: "Saved Local"});

ForAll(GalleryInspectionEdit.AllItems, Patch(LineColl, DataTableServiceHeader.Selected.SO_Number = SO_Number,
{SO_Number: TextInput1.Text,
No_Questions: NumberQuestion.Text,
Questions: TitleQuestion.Text,
Responds: RadioRespond.Selected.Value,
Remarks: TextInputRemarks.Text}));

What should i do?
I dont know what went wrong since its my first time using collection.

Edit:
I use the formula above to patch my collection after its data being edited.
I use the data table control to temporary store the data so it can be selected (or there any way around to select a data record in a collection?)
I use ForAll function to make sure that all data items that have been edited is collected (cmiiw).

Please help me.

BR,
pytbyt

Was this reply helpful? Yes No