Power Platform Community Forum Thread Details

Hello everyone, as you can see from the subject i would like to know if is possible to update a row into a table with complex formulas.

I tried but give me the the following error: "The argument is invalid or missing or has an incorrect format."

This is the JSON code:

{
"Utente": "ZZ",
"Casella": "=IF(E2=\"0000006705490966\";\"FSI Casualty\";IF(B2=\"980\";\"FSI Casualty\";IF(C2=\"430783590\";\"FSI Casualty\";IF(G2=\"ENGINEERING\";\"Engineering\";AT2))))",
"Delta GG": "=NETWORKDAYS.INTL(R2;S2)-1",
"KPI": "=IF(AM2<3;\"2gg\";SE(AM2>10;\"Oltre 10gg\";\"da3 a10\"))",
"CO": "=VLOOKUP(K2;CO!A:D;2;FALSE)",
"Cas1": "=VLOOKUP(K2;CO!A:C;3;FALSE)",
"Cas2": "=IF(AG2=\"FES\";\"FSI Property\";IF(AP2=\"BBL\";SE(A2=\"E\";\"Property\";IF(J2=\"544\";\"Banche Leasing\";\"Banche\"));AP2))",
"Cas3": "=IF(AQ2=\"BP\";IF(A2=\"E\";\"Property\";IF(J2=\"544\";\"Banche Leasing\";\"Banche\"));AQ2)",
"Cas4": "=IF(AR2=\"Casualty\";IF(AD2=\"194\";\"Casualty RC P./P.I\";\"Casualty RCT/RCO\");AR2)",
"Cas5": "=IF(AS2=\"Property\";IF(A2=\"B\";\"Banche\";AS2);AS2)",
"Canale": "=IF(O(B2=\"900\";B2=\"901\";B2=\"904\";B2=\"907\";B2=\"926\";B2=\"980\";B2=\"988\");\"DG\";\"AG\")"
}

The "CO" sheet for the VLOOKUP is already present in the file as a table.

Thanks!!

Categories:

Building flows