Hey fellow dudes/dudettes,
My flow fetches data from an excel file using the "List rows from table action". Then, I use the "Create csv table" action to map field names to their values as shown below:
However, Test Due, because it is a date in the Excel file, gets converted to a number. I have a formula that I use to revert back that number to a date. But, I cannot apply that formula to the "Test Due" dynamic field without getting an error. This is quite logical since "Test Due" here is not a one value: it represents the whole column of Test Due data.
Please advise as to how I can apply this formula for each value in the "Test Due" column.

Report
All responses (
Answers (