Unanswered

Adding date and time fails the flow

(0) Share

Report

Posted on by Bill51106

152

Before the Flow worked great. The file name would always stay the same and I wanted to add a time stamp. I added this function

"formatDateTime(utcnow(),'Pacific Standard Time''MM-dd-yyyy hh:mm tt')" and now the flow fails, I also added .xlsx to the end thinking that was the problem. This function works on my other flows, what am I missing?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

PrasadAthalye on at

Like (1)

Report

I think the format DateTime function returns time with a colon in it which can not be used in filenames. It's a special character. I put together the following expression. Can you try it?

replace(replace(convertFromUtc(utcNow(), 'Pacific Standard Time'), ':', ''), '.', '')

Was this reply helpful? Yes No
Bill51106 152 on at

Like (0)

Report

@PrasadAthalye First, thank you for responding. Previously my function worked to timestamp files and produced "filename 04-04-2021 11_30 PM.xls" now it fails, with your code it produces "filename.xlsx2021-04-0409321199445922 "

Was this reply helpful? Yes No
Bill51106 152 on at

Like (0)

Report

I figured out what the problem was, my previous file creations needed me to build the file name and I could add in functions and finish it off with .xls.

This flow is different I see, it creates the entire file name. I got around this by placing this function prior "convertTimeZone(utcnow(),'UTC','Pacific Standard Time','MM-dd-yyyy hh:mm tt')"

Was this reply helpful? Yes No