Move Dataverse rows when a condition is met

[Anonymous]

Is it possible to move rows in a Dataverse table to another table when a condition is met?
Example:

Condition is when the status is changed to inactive, it will be moved to the inactive list table (Table B)
Table A; Row 1; Quantity Column is now Inactive, it should be removed from Table A (active list) and moved to table B (inactive list)

[StephanPrnb · Accepted solution]

Why would you move it to a different table? Just being courions beacause in my opinion if you have records related to a entity they can have a status and in your applications you can filter for the status column. Otherwise you have to access two different entities just to look wich entries are active and wich are not.

Nevertheless you could make a cloud flow which only triggers if the status column in table A is set to inactive. Make a new entry in table B and then delete the record in table A.

[Anonymous]

@StephanPrnb 

You are right!! Thank you! That actually makes sense! I would do that instead. 

[StephanPrnb · Accepted solution]

you could either implement a calculated column and enter the condition there, a formula column where you can enter Power Fx code (e.g. IF(<condition>, <then>, <else>)) to automate it or making a business rule to change the value of your desired column depending on some condition.

[Kumar_bi]

@StephanPrnb  sir, i just wanted to ask , i have 2 separate views on my table for my needs , for status Active and another view with status "Inactive". So, how to use both views within the same group of model driven app without changing them from the top table name , can i have a vertical layout of them below my group showing both views ? Pls suggest , many thanks 

[Stevieed]

create 2 subgrid next to each other, and assign different views to each subgrid

[Kumar_bi]

Thanks much @Stevieed  for your reply 
But then grid would be part of the same form , cant i separate them out , 2 views with 2 different form  (under one or different group) ?

One  align to active status 
one aligning to inactive status 

[Stevieed]

Yes you can create 2 forms for the same entity, just add another form for the entity, one form to have subgrid A, another form to have subgrid B.