Hi @jaipalambati ,
It is simply because at the end, you are doing this
ClearCollect(
colMappingTable_Full,
mapping_table
);
and only picking up the first 2,000 items of the table. An alternative (I also have some other suggestions here).
Screen OnVisible - collect all records in Table
Clear(colMappingTable_Full);
With(
{
_Sets:
With(
{
_Limits:
With(
{
_Limit:
Sort(
mapping_table,
item_num,
Descending
)
},
RoundDown(
First(_Limit).item_num / 2000,
0
) + 1
)
},
AddColumns(
RenameColumns(
Sequence(
_Limits,
0,
2000
),
"Value",
"LowID"
),
"HighID",
LowID + 2000
)
)
},
ForAll(
_Sets As _MaxMin,
Collect(
colMappingTable_Full,
Filter(
mapping_table,
item_num > _MaxMin.LowID && item_num <= _MaxMin.HighID
)
)
)
);
Your Gallery Items
With(
{_Text: TextInput1.Text},
SortByColumns(
Filter(
colMappingTable_Full,
(
IsBlank(_Text) Or
_Text in contract_name Or
_Text in mapping_item Or
_Text in item_short_name Or
_Text in status
) &&
(
Len(ComboBox2_Client.Selected.Value) = 0 ||
Lower(client_name) in Lower(ComboBox2_Client.SelectedItems.Value)
)
),
"contract_name",
SortOrder.Descending
)
)
and now the important part - Patch both the Table and the Collection (I am assuming here your Patch button is inside the Gallery)
Patch(
mapping_table,
LookUp(
mapping_table,
id = ThisItem.id
),
{
item_short_name: TextInput2.Text,
status: ComboBox4.Selected.Value
}
);
Patch(
colMappingTable_Full,
ThisItem,
{
item_short_name: TextInput2.Text,
status: ComboBox4.Selected.Value
}
);
Notify(
"Item Short Name Updated successfully",
NotificationType.Success
);
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.
MVP (Business Applications) Visit my blog Practical Power Apps
