I am stuck on a problem after migrating from spreadsheet to app formulas.
We have company-wide settings used in app formulas in a second table. We would like to re-calculate these app formulas when any of these settings are changed. Also, it would be nice to be able to manually “force” a re-sync if things go haywire or we change the formulas.
Table 1: Company Settings
Item | Value
1AUD= Pound | 0.55
1AUD= USD | 0.70
Shipping cost UK per kg | $5.00
Shipping cost US per kg | $3.00
Minimum shipping cost | $15.00
Minimum profit margin | 15%
Table 2: Items
Name | Description | Country | Weight | Currency Exchange Rate
Item 1 | … | England | 5kg | <app formula>
Item 2 | … | US | 7kg | <app formula>
This is an example app formula used for a field in the Items table:
IF([Country]=“England”, “1AUD= Pound”, “1AUD= USD”),
“Company Settings”, “Item”, “Value”)
I have tried the following:
An Action with “Data: execute on a set of rows” with Referenced Rows column “SELECT(Items[Item Id], 1=1)” with the Action: Edit. However, I suspect this is not working because the table is not referenced so no rows are selected.
A workflow with a custom action and the following configuration:
“Rows”: <<Start: SELECT(Items[Item Id], 1=1)>><>
This gives the following error:
“Description”: “Failed to parse JSON due to Unexpected character encountered while parsing value: }. Path ‘Rows’, line 1, position 25… Invalid JSON value starts with: }”
Thanks in advance!