Hi @Big_S :
In theory, your needs should be achievable.But you need to use the forall function to operate on the records in the MasterCollection one by one.For example:
1\My table
ClearCollect(TheTable,{Column1:"A"},{Column1:"B"},{Column1:"C"},{Column1:"D"},{Column1:"E"},{Column1:"F"},{Column1:"G"})
2\Add a button and set it's OnSelect property to
Collect(TheTable,{No:999});
RemoveIf(TheTable,No=999);
ForAll(Sequence(CountRows(TheTable)),Patch(TheTable,Last(FirstN(TheTable,Value)),{No:Value}))

However, according to the information you provide, the number of records to be processed may reach more than 10,000. This will seriously affect the performance of the app and may eventually cause the program to crash.
I suggest you to create an AUTO INCREMENT Field directly in [dbo].[Request].
ALTER TABLE dbo.Request
ADD TheID INT Identity(1,1) NOT NULL
I think this link will help you a lot:
SQL AUTO INCREMENT Field
Best Regards,
Bof