Requirement :
Please assume below table as My power apps UI.
S.no | Field-1 | Field-2 | Record Version |
Row 1 | X1 | LIVE | 1 |
Row 2 | X1 | ON HOLD | 2 |
Row 3 | X1 | LIVE | 2 |
Row 4 | X1 | ON HOLD | 3 |
Row 5 | X1 | LIVE | 3 |
- Scenario-1: When users visit my UI, they will select “Row-1” and change the status of “Field-2” from “Live” to “On Hold”. Then, they will click the “Start” button. As soon as they click the “Start” button, I want to create a new row with the updated record (Row-2). In addition, I need to display both versions of the records in my UI, which means both Row-1 and Row-2 should be visible in my UI.
- Scenario-2 : In Scenario 2, the user will select “Row-2” and change the status of “Field-2” from “ON HOLD” to “LIVE”. Then, they will click the “Complete” button. As soon as they click the “Complete” button, I want to create a new row with the updated records (Row-3). In addition, once the user clicks the “Complete” button, I need to display only Row-3 in my UI, And Row-1 and Row-2 should be removed or archived from the UI.
- Scenario-3 : Scenario-3 would repeat of sce-1 and sce-2. they will select “Row-3” and change the status of “Field-2” from “Live” to “On Hold”. Then, they will click the “Start” button. As soon as they click the “Start” button, I want to create a new row with the updated record (Row-4). In addition, I need to display both versions of the records in my UI, which means both Row-3 and Row-4 should be visible in my UI.
Note : actually i have try with flagging technique, I have add additional column "IsHide", So when ever user click "Complete" Button will try mark Row-1 and Row-2 as "Archived".So that way i can filter the record Row-3 in my UI. I don't know how to achieve this in power apps.

Report
All responses (
Answers (