Power Platform Community Forum Thread Details

Hello, i would like to get help for my problem.

I have SQL table "db.Asbestos_Sampling", all record have columns ID, old_record, new_record.

Created record cannot be edited or deleted. Could be only replaced by new record but have to be to intertwine. Therefore when i repair of record i need save new record ID to old record and old id record to new record.

When im go from original record screen im set his ID record to variable _OldId. If _OldId not blank so field with oldid is visible and will be save. This is easier step.

But now if i want save this replacement record (new) i need save his ID to old record to column "new_record".

How could i make it?

Categories:

Building Power Apps