How to convert string into time format and pass the right type to json file

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear experts

the following flow scans a CSV file and imports into D365.

I got stuck to the column Delivery Time

I need to convert delivery time from string to time in order to be able to feed the D365 data entity .

DELIVERYDATE,DELIVERYTIME,ITEMNUMBER,PRODUCTIONPOOLID,PRODUCTIONSITEID,SCHEDULEDQUANTITY
2020-12-01 00:00:00,10:00:00,2000029,IMP,B01,4000.000000
2020-12-01 00:00:00,12:00:00,2000029,IMP,B01,5000.000000
2021-12-01 00:00:00,14:04:00,2000029,IMP,B01,6000.000000

So when defining the delivery time variable , I thought I would need to convert the string into time using the following expression

formatdatetime(split(item(),',')?[1],'hh:mm')

but even if the above is correct , I get stuck in the Parse Json file as it does not accept type datetime.

Can you please help?

Categories:

General topics

All responses (8)

Answers (0)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I am not sure what is the purpose of the parseJson step here? You can directly do your apply to each on the select outputs and insert in Dynamics 365
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I removed the Json and now I cannot select any variable
DamoBird365 8,942 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

I've tested out your problem and your expression works for me:

What error are you getting?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello
thanks for looking into this

I get the following
DamoBird365 8,942 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

if you're sticking with the parsing - it's possibly "date-time" and not "datetime".
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I just tried and get the same error
I am using the parsing but honestly if there is a better way can you show me how to do it ?
My knoweldge in PowerAutomate is clearly very low and I am trying to test this flow.
DamoBird365 8,942 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous ,

I think you are over complicating as I don't believe you need your Parse Json step as you can split the items straight from your apply to each. See below for an example:

Hope we've got you sorted.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hELLO

Can we please stick to use parse JSON ? I don't have any expertise on how to do this in any other way .
I put back the flow as originally was ,
the column time is then a string containg hh:mm

but once I tried to feed the data entity and specify the variable time , it is not available as the data entity seems to accept only numeric values.

Is there a way to convert the output of the variable time in numeric BEFORE feeding the data entity?