Power Platform Community Forum Thread Details

I have written the below code while running the patch command, so that it can obtain max+1 for each records

RecoNo:(First(Sort(colAllWsOrders, RecoNo, SortOrder.Descending)).RecoNo)+1,

But the records which is posted having one time max+1,

I mean the max+1, was 15+1 = 16, so all the records which been posted have the 16 as the value of the RecoNo,

While it should be 16, for next 17, and so on.

Please advise, what changes I should do to the code to achieve this.

Full code:

ForAll(
GalleryCartOrder.AllItems,
Patch(
WsOrderTables, Defaults(WsOrderTables),
{
RecoNo:(First(Sort(colAllWsOrders, RecoNo, SortOrder.Descending)).RecoNo)+1,
RefJobNo:Upper(TextBox2_21.Value),
IssueForModel:Upper(TextBox2_26.Value),
IssueForSerial:Upper(TextBox2_27.Value),
LineExtPrice:ThisRecord.CostPrice*Value(CartQty.Value)
}
)
);

Hi,

(First(Sort(colAllWsOrders, RecoNo, SortOrder.Descending)).RecoNo)+1

This part of your formula is static since the number of items in colAllWsOrders

So to implement this correctly, you need to store the patched item into the said collection to have a +1 in each iterration

ForAll(
	GalleryCartOrder.AllItems,
	
	Collect(colAllWsOrders,
		Patch(
		WsOrderTables, Defaults(WsOrderTables),
			{
				RecoNo:(First(Sort(colAllWsOrders, RecoNo, SortOrder.Descending)).RecoNo)+1,
				RefJobNo:Upper(TextBox2_21.Value),
				IssueForModel:Upper(TextBox2_26.Value),
				IssueForSerial:Upper(TextBox2_27.Value),
				LineExtPrice:ThisRecord.CostPrice*Value(CartQty.Value)
			}
		)
	)
);

I guess something like this should works.

Regards,