Power Platform Community Forum Thread Details

Not able to patch values to list from the gallery collection in powerapps getting below error.

If(
IsBlank(
LookUp(
colgridupdate,
ID = ThisItem.ID
)
),
Collect(
colgridupdate,
ThisItem
)
);

UpdateIf(
    colgridupdate,
   ( ID = ThisItem.ID),
    {
       'Onsite/Offshore':OnsiteDrpdn_1.Selected,
Role:RoleDrp_1.Selected.'IGDC Roles',
'FTE Based efforts':Value(FTEBasdeffortTxt_1.Value),
'Monthly Fixed hrs':Value(MonthlyFixedhrTxt_1.Value),
'Start Date':StartDateDatePicker_1.Value,
'End Date':EndDateDatepicker_1.Value,
'Total Months':Value(TotalMonthTxt_1.Value),
'Base Location':BaseLctnDrpDn_1.Selected.Value,
'Total Working Days':Value(TotalEffortsDaysTxt_1.Value),
'Total Days':Value(TotalDaysTxt_1.Value),
'Total Efforts Days':Value(TotalEffortsDaysTxt_1.Value),
'Total FTE Efforts':Value(TotalFTEEffortsTxt_1.Value),
'Total Labor Cost':Value(TotalLabourCostTxt_1.Value),
ProjectID:ProjectID_Txt_2.Text,
EstimationID:EstIDTxt.Text,
SubmissionDate:Today(),
Status:Varstatus
}
);

Save Button Code:

Set(Varstatus, "Saved");
Patch(BAS_Estimation_v2, colgridupdate);

Notify("Data Updated successfully",NotificationType.Success,300);
Set(varreset,false);
Set(varreset,true);

Submit button Code:

Set(Varstatus, "Submitted_PO awaited");
Patch(BAS_Estimation_v2,colgridupdate);
Notify("Data Updated successfully",NotificationType.Success,300);
Set(varreset,false);
Set(varreset,true);
Refresh(BAS_Estimation_v2);

Note: Showcolumns not working.

Powerapps Patch error.png