Hi There,
I am getting better at building my flows, just parsed my first JSON that was inside another array (Whoa ... I got confused just writing that). But now I have run into a problem with formatting the date time value.
The value I pull from the JSON is "PublishedTime" with a value of "2018-11-27T22:48:00Z".
The problem is that when I try to use the expression builder I can't access the "PublishedTime" value/identifer.
The only thing availible from the Parse JSON action is "body".
I am kind of lost ...
Thanks, Mike
Solved! Go to Solution.
Hi @mikedumka,
You could add a Compose action inside the Apply to each, and then refer to screenshot below to create the flow:
The expression in the Body field as below:
formatDateTime(outputs('Compose'),'yyyy-MM-dd')
Best regards,
Alice
Hi @mikedumka,
Could you please share a screenshot of the configuration of your flow?
Could you please share more details about the JSON that you mentioned.
I have made a test on my side and my flow works fine to get the value in the JSON as below:
The JSON:
[ { "Title": "1", "PublishedTime": "2018-11-27T08:00:00Z" } ]
The flow:
Run history:
Please share more details so we would try to provide a proper workaround for you.
Best regards,
Alice
Thanks so much for the help ...
I should have explained more, I can do everything you laid out, but when it comes to the expression builder, I want to format the time. So I have this ... which has the correct JSON value "PublishedTime"
But as soon as I go into the "Expression" tab and try to format the time, the JSON value changes to "body" like below ...
What is going on with this ... and again, thank you so much for the help!
Hi @mikedumka,
You could add a Compose action inside the Apply to each, and then refer to screenshot below to create the flow:
The expression in the Body field as below:
formatDateTime(outputs('Compose'),'yyyy-MM-dd')
Best regards,
Alice
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
86 | |
57 | |
42 | |
37 | |
33 |
User | Count |
---|---|
91 | |
73 | |
71 | |
60 | |
40 |