I'm having a two tables in dataverse Table1 and Table 2 respectively, I wanted to take the values from Table1 and patch it to table 2. In Table2 I want to add the values of (Group sequence, Account Sequence) from table1 by 1 and the set the max value to 1.
Table 1 -> Table 2
Group sequence = Group sequence + 1
Account Sequence = Account Sequence + 1
Max of Sub Group Sequence = 1 Max of Account Sequence = 1