Hello to every one, i'm a new user in this wonderful app, but in my trying to understand the use of this app i have had troubles customizing my date of register from survey123 to a row in table excel.
I have written this piece of function in my box
Solved! Go to Solution.
Hi @jalastrag28 :
Firstly, let me explain why you encountered this problem.
The point is the value of
concat(addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['FECHA'],1000) , 'dd/MM/yyyy'),' ',triggerBody()?['feature']?['attributes']?['HORA'])
do not match ISO 8601 format.
The correct ISO 8601format is
yyyy-MM-ddThh:mm
Finally, please try this formula:
formatDateTime(concat(addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['FECHA'],1000) , 'yyyy-MM-dd'),'T',triggerBody()?['feature']?['attributes']?['HORA']) , 'dd/MM/yyyy hh:mm')
Best Regards,
Bof
Hi @jalastrag28 :
Firstly, let me explain why you encountered this problem.
The point is the value of
concat(addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['FECHA'],1000) , 'dd/MM/yyyy'),' ',triggerBody()?['feature']?['attributes']?['HORA'])
do not match ISO 8601 format.
The correct ISO 8601format is
yyyy-MM-ddThh:mm
Finally, please try this formula:
formatDateTime(concat(addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['FECHA'],1000) , 'yyyy-MM-dd'),'T',triggerBody()?['feature']?['attributes']?['HORA']) , 'dd/MM/yyyy hh:mm')
Best Regards,
Bof
I am having the same issue. Could you please provide the complete workflow?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
72 | |
27 | |
22 | |
15 | |
13 |
User | Count |
---|---|
141 | |
43 | |
42 | |
34 | |
30 |