In the doc I am working on, I duplicate a page with a table. I use the “DuplicateData” parameter in the DuplicatePage action, but I have an issue.
The original table uses formulas that depend on the value of a control. Even if I use that parameter, when the control is changed, the table values change.
I need a way to prevent the table from recalculating.
One method I have tried is to create a SwitchIf function to only to that calculation if a condition is met, but then the ELSE part would be circular - e.g. SwitchIf(condition, formula, current value), but that throws an error.
Can you share why do you want to duplicate pages/tables? Probably there are much more efficient ways to achieve your goals than duplicating.
If the page you want to duplicate contains both the table of them and the control, the two will be duplicated and the new table will be dependent on the new control, not the old one.
Columns either have values or formulas, cannot have both. So I don’t understand what do you mean by ‘current value’.