Good day,
The flow I built is to update SharePoint from Excel Online.
In the excel file, there are 6 columns with dates in a serial format (e.g. 44346.2291666667). In order to show it correctly in SP, I need to, for each column, initialize variable 1 (float)-> initialize variable 2 (string) -> Set variable 2 with value addSeconds('1899-12-30',int(formatNumber(mul(variables('variable 1'),86400),'0','en-us')),'yyyy-MM-dd HH:mm:ss').
Since there are 6 columns, my flow has 12 initialized variables, and 6 set variables.
Is there any way to simplify the flow?
P.s., Also tried to initialize variable 1 &2 as Object ( instead of float and string), but got an error in "Set Variable" since the MUL function in the formula cannot calculate Object variables


Report
All responses (
Answers (