301
I have used
Share
Reportaddseconds('1899-12-30',int(formatnumber(mul(float(triggerBody()['serialdate']),86400),'0’)))to convert my time format field in excel to put value into SP list as date along with my Start date to form End Date
End date = Start date (which value as date format is coming right) + Start Time ( which is Generalformat coming as text converted)
Hi @apeawakening ,
It seems that for the item(s) that is(/are) causing this error don't have a value for the serialdate column or the column is not found.
The latter can be easily checked in the triggerbody outputs to make sure serialdate is a valid column name (including casing, etc.)
If it is a valid column name, but you have items that don't have a value, you can add an If function to make sure the float function is only called in case the column does have a value:
All responses (
Answers (
If(
equals(
triggerBody()['serialdate'],
null
),
null,
addseconds('1899-12-30',int(formatnumber(mul(float(triggerBody()['serialdate']),86400),'0’)))
)
