Power Platform Community Forum Thread Details

Hi,

I have a table with 15k record in sql server. and I wanted to updated and insert records using power apps. Please find below code and suggest.

Sometimes records are getting inserted and updated and sometimes not.

Please suggest.

ForAll(
Gallery3.AllItems,
If(
IsEmpty(
Filter(
StatsPackActualInput,
FinancialYear = FinYear And SiteID = SiteIDVar And CostLineGrandParent = CostLineGrandParentVar And Department = DepartmentVar And CostLineParent = CostLineParentVar And CostLineDescription = CostLineDescriptionVar And WeekNumber = Value(TextInput1.Text)
)
),
Patch(
StatsPackActualInput,
Defaults(StatsPackActualInput),
{
FinancialYear: FinYear,
SiteID: SiteIDVar,
Department: DepartmentVar,
CostLineGrandParent: CostLineGrandParentVar,
CostLineParent: CostLineParentVar,
CostLineDescription: CostLineDescriptionVar,
WeekNumber: Value(TextInput1.Text),

Actual: Value(TextInput4.Text)
}
),
Patch(
StatsPackActualInput,
First(
Filter(
StatsPackActualInput,
FinancialYear = FinYear And SiteID = SiteIDVar And CostLineGrandParent = CostLineGrandParentVar And Department = DepartmentVar And CostLineParent = CostLineParentVar And CostLineDescription = CostLineDescriptionVar And WeekNumber = Value(TextInput1.Text)
)
),
{Actual: Value(TextInput4.Text)}
)
)
);
UpdateContext({Popup: true})

Categories:

Building Power Apps

@surbhibhandari1

Can you try to update the expressions to below mentioned expression?

ForAll(
Gallery3.AllItems,
If(
IsEmpty(
Filter(
StatsPackActualInput,
FinancialYear = FinYear && SiteID = SiteIDVar && CostLineGrandParent = CostLineGrandParentVar && Department = DepartmentVar && CostLineParent = CostLineParentVar && CostLineDescription = CostLineDescriptionVar && WeekNumber = Value(TextInput1.Text)
)
),
Patch(
StatsPackActualInput,
Defaults(StatsPackActualInput),
{
FinancialYear: FinYear,
SiteID: SiteIDVar,
Department: DepartmentVar,
CostLineGrandParent: CostLineGrandParentVar,
CostLineParent: CostLineParentVar,
CostLineDescription: CostLineDescriptionVar,
WeekNumber: Value(TextInput1.Text),
Actual: Value(TextInput4.Text)
}
),
Patch(
StatsPackActualInput,
LookUp(
StatsPackActualInput,
FinancialYear = FinYear && SiteID = SiteIDVar && CostLineGrandParent = CostLineGrandParentVar && Department = DepartmentVar && CostLineParent = CostLineParentVar && CostLineDescription = CostLineDescriptionVar && WeekNumber = Value(TextInput1.Text)
),
{Actual: Value(TextInput4.Text)}
)
)
);
UpdateContext({Popup: true})

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!