Hi All,
I have a dataverse table where i'm initializing a value as like 1000 ( Powerapp user input ) and it is a incremental value by 1 for each new record. For example records created already as: 1001,1002,1003 ....
My requirement is like if i update the initial value as 3000, i need to update the existing values as 3001,3002,3003... and so on.
I have implemented like:
Set(varDifferenceNum, Abs(varLatestNum - varInitialnum));
colTest1 is the second table which is having all the incremental values.
ClearCollect(colTest,
ForAll(
Sequence(CountRows(colTest1),varInitialnum + varDifferenceNum,1) As A,
{
ID1: AB& "" & (A[@Value]),
ID2: A[@Value]
}
)
);
My issue is i'm not able to map the both results from tables colTest and colTest1 and unable to update using patch look up.
Can someone help on this.
Thanks in advance.

Report
All responses (
Answers (